Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    10

    Unanswered: Exp (Export) help

    hi

    I took a backup useing EXP for whole user.
    I have one doubt while Exporting Process all tablespaces are also included in .dmp .
    In Importing time can i create tablespaces or automatically created or all tables are imported in System Tablespace.

    thanks for help

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    In Importing time can i create tablespaces or automatically created or all tables are imported in System Tablespace...

    - Yes you can manually or automatically have the tablespaces created with import .... If you create the tablespaces in advance, in you IMPORT statement, include "ignore=y".

    - Were do you want the Tables to go ??? If you are looking to put all the tables in the SYSTEM tablespace (Please DONT !!!!) then you could do that ...

    The import will try to put the tables in the same tablespace they came out of ...

    HTH
    Gregg

  3. #3
    Join Date
    Nov 2003
    Posts
    10
    if i am not creating a tablespace, what happend in importing time.
    All tables will go on SYSTEM tablespace or any error show in importing time

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    they goto the DEFAULT tablespace of the user you are importing to.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Change the default database for the user you are importing into ... If you are using SYSTEM, change the default tablespace until after the import utility has run

    HTH
    Gregg

Posting Permissions

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