Linux

Drop Oracle datafile

Dropping a Tablespace: Example 

The following statement drops the sunvt01 tablespace and drops all referential integrity constraints that refer to primary and unique keys inside sunvt01

Show All tablespace on database :

Set pagessize 999

Set linesize 999

Select * from v$datafile; or

Select name from v$datafile;

DROP TABLESPACE sunvt01

INCLUDING CONTENTS

CASCADE CONSTRAINTS;

Deleting Operating System Files: Example 

The following example drops the sunvt01 tablespace and deletes all associated operating system datafiles:

DROP TABLESPACE sunvt01

INCLUDING CONTENTS AND DATAFILES;

Advertisements
Standard

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s