import into 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: import into 9i

  1. #1
    Join Date
    Dec 2001
    Posts
    96

    import into 9i

    Hi friends,
    e
    I have created a 9i database on server 2. I have taken the FULL EXPORT of 9i db in server 1.

    In Server 2, I have also created the same users and tablespaces as in server 1.

    My question is: Can I do a FULL ImPORT into the server 2 ?
    I read somewhere that users are not necessary to be created for FULL IMPORT as the export dump will already have scripts to create users.

    SInce i have already created users, should I drop them or can I go ahead and do import with full =Y of the export dmp file ?

    Thanks

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    You can go ahead with the ignore=y.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    You can go ahead with or without IGNORE=Y, since it does not have any effect on import regarding users, roles, tablespaces, etc... creation.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Correct, only if tables are precreated use ignore=y. My mistake...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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