SQL & PL/SQL

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!

About tablespace objects

345144Nov 14 2002 — edited Dec 16 2006

I want to get rid of certain tablespace. But I do not want to lose any object from it. Therefore, INCLUDING CONTENTS is not an option for me. Prior to Drop, I want to get a list of all objects residing in this tablespace. DBA_OBJECTS does not list tablespace. Is there a way to find it ?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 13 2007

Added on Nov 14 2002

5 comments

1,750 views