Export and Import on Certain tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Export and Import on Certain tablespace

  1. #1
    Join Date
    Dec 2002
    Posts
    9

    Export and Import on Certain tablespace

    Hello,

    We have a total of 20 tablespaces in our database. I would like to export all the objects incluing data from a special tablespace only. This tablespace have objects corresponding to different users.

    Could you please tell me how can I perform the export and import on this specific tablespace?

    Thanks,
    Allen

  2. #2
    Join Date
    Jul 2000
    Posts
    521
    The exp utility from Oracle doesn't have such option : export a tablespace.

    You will have to be creative if this (exporting objects from a special tablespace) is a hard requirement.
    svk

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    Well, here is one alternative...

    SQL> Spool table_list.txt

    SQL> select table_name||','
    from dba_tables
    where tablespace_name in ('your_mama','your_dada')
    ;

    This will create a comma delimited file, you can use that to do a table level export, just cut and paste.

    TABLES=(,,,,,,,,,,,,,,,,)

    Got it?

    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Dec 2000
    Posts
    138
    How about transportable tablespaces?
    -dharma

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    In 9i you have TABLESPACES parameter.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width