Data Warehousing Community Forum
February 08, 2012, 10:39:04 am

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: System tablespace  (Read 1205 times)
unknown
DW Apprentice
**

Reputation: +8/-0
Offline Offline

Posts: 44



View Profile
« on: January 21, 2008, 11:00:31 pm »

Frnds  Wink,

I want to know can we drop the system tablespace in oracle 9i? And if not, why we can't drop the system tablespace? (having DBA access)

To increase/decrease the same system tablespace., what needs to be done ?

And also the same question for rollback the tablespaces.
Logged
Thanks
Unknown Smiley
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« Reply #1 on: December 28, 2010, 10:48:45 am »
Except the SYSTEM tablespace, Any tablespace in an Oracle database can be dropped. You must have the DROP TABLESPACE system privilege to drop a tablespace.

To drop the users tablespace, including the segments -
Code:
DROP TABLESPACE users INCLUDING CONTENTS;

To drop the USER tablespace and its associated datafiles -
Code:
DROP TABLESPACE users INCLUDING CONTENTS AND DATAFILES;

For the detail info, please go here
Logged
Sipra
Founder

www.dwforum.net
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: