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