import/export different tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: import/export different tablespace

  1. #1
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Hi Friends..

    I have 2 databases.
    I want to export a schema frmo database 1 and import into database 2.

    Database 1 and database 2 have different tablespace names. How can the objects from database 1 be created in database 2 without having to change the name of tablespaces in database 2 ?

    Thanks

    Suresh


    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    change userīs default tablespace, the objects will be imported to this default


  3. #3
    Join Date
    Oct 2000
    Posts
    467
    Originally posted by pando
    change userīs default tablespace, the objects will be imported to this default

    Assuming the tablespace exists on database 2.
    Else you need to change the name using indexfile=y option while importing.
    Vinit

  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Thanks guys!
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

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