Drop Oracle Tablespaces

(!!!DO NOT delete dbf files from the file system directly!!!)

Solutions:

1. Check the tablespace names of the dbf files.

SELECT FILE_NAME, TABLESPACE_NAME FROM DBA_DATA_FILES

2. Make sure no objects are in the tablespace (drop user xxx cascade).

SELECT * FROM DBA_SEGMENTS WHERE TABLESPACE_NAME = TABLESPACE_NAME

3. Drop the tablespace and its contents.

DROP TABLESPACE TABLESPACE_NAME INCLUDING CONTENTS AND DATAFILES


Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s