Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

drop tablespace

591183Jul 8 2008 — edited Jul 8 2008

Folks,

I'm trying to drop a tablespace that is converted from DMT to LMT using the dbms_space_admin.Tablespace_Migrate_TO_Local package. I moved all the objects from the tablespace but i see one object of type space header which i guess was created as part of the migration process.

Is it safe to drop the tablespace? Do i encounter any issues because droping the tablespace will also drop the space header.

Please advice.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 5 2008

Added on Jul 8 2008

#general-database-discussions

3 comments

344 views