Home » RDBMS Server » Server Administration » drop tablespace xxx including contents, what schema objects will be dropped ?
drop tablespace xxx including contents, what schema objects will be dropped ? [message #369303] Wed, 09 August 2000 19:15 Go to next message
Rick
Messages: 49
Registered: March 2000
Member
for example,
create user rick ... default tablespace ABC...;
then do some works.
then
drop tablespace ABC including contents;
besides table and index, what are other schema objects that will be dropped ?
db links ? function ? package ? sequence ? synonym ? trigger ? or view ?

thanks.
Re: drop tablespace xxx including contents, what schema objects will be dropped ? [message #369314 is a reply to message #369303] Mon, 14 August 2000 08:44 Go to previous message
Alpesh Patel
Messages: 4
Registered: August 2000
Junior Member
Hi If you drop a tablespace with including contents option then all the objects like tables, index, clusters will get dropped.

Oracle keeps info abt db links, function, package, sequence, synonym, trigger & view in system tablespace. so they won't be affected. & you can't drop System tablespace.

with regards,

Alpesh
Previous Topic: Size of transactions and number of transactions
Next Topic: Audit Transactions
Goto Forum:
  


Current Time: Wed Oct 21 11:51:27 CDT 2020