Full database import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Full database import

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    286

    Full database import

    When doing full database import, Oracle will also create all the tablespace using the original file structure. If the server I am importint into does not have the same file structure, import fails. Do you have a good work around to tell Import not to use the old file structure?

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Precreate the tablespace as you like it, and use ignore=Y option in imp.

    Tamil

  3. #3
    Join Date
    Nov 2005
    Location
    USA
    Posts
    32
    Be careful in using ignore=Y option.
    Precreating tablespaces should solve your problem without any ignore=Y option(by default it is N).

  4. #4
    Join Date
    Feb 2003
    Posts
    63

    indexfile

    You could always use the indexfile option, this way you could get all of you DDL statements. You could then create them in the new tablespaces you wanted then use the ignore=y option

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