Re: Tablespace export ???? how ???

In article <3abd8267.0_at_news.tm.net.my>, Venkat Iyer <venkat_p_iyer_at_yahoo.com> writes:
>hi there guys and gals...
>
>i'm trying ot reclaim some space from my datafiles....i need to drop a
>tablespace and recreate it with the rite storage and sizing
>parameters.....how do i just export the contents of a tablespace, drop it
>and recreate it ?????
>
>thanx in advance
>venkat
>

There is not exp command to export only one tablespace for re-importation into the same database, but you can use the tables= parameter to export the tables in a tablespace. You can find the tables/indexes in a tablespace by searching on the tablespace_name column of sys.dba_tables and sys.dba_indexes or using dba_segments. I suggest you use compress=n on the export to prevent Oracle from over-allocating space to the objects on import.

Note, if the tablespace is all indexes you may want to generate the create index SQL, drop the tablespace including contents, re-create it, and just run the index DDL.

• Mark D. Powell --
  • Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net