Re: Tablespace Reorg

As long as you are not doing reorg on system tablespace, you should be ok. I don't think all tablespaces other than system can have anything other than tables, indexes, clusters etc. See everything is user_segments or dba_segments with a given tablepspace name and you should see all objects.

"Mark C. Rush" <mrush_at_ocdis01.tinker.af.mil> wrote:
>How do you reorg a tablespace?
>
>Export all the objects in the tablespace, drop them, then import?
>
>If so, how do you find all of the objects in a tablespace?
>
>I know how to find all the tables, indexes, or clusters in a specific
>tablespace.
>Are the objects stored in a tablespace either tables, indexes, or clusters?
>
>Like in which tablespace are procedures and packages and triggers stored. I
>don't want to export only the tables and indexes and miss exporting procedures.
>
>Is there a way of exporting the contents of an entire tablespace?
>
>I know I should probably buy a utility to do this, but that takes time. If I
>were to buy such software, any recommendations?
>
>Thanks
>Mark Rush
>mrush_at_ocdis01.tinker.af.mil
>
Received on Sat Jan 27 1996 - 00:00:00 CET