Import backup - advise
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Import backup - advise

  1. #1
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    hi guys

    I am not a oracle dba but i have work to do .

    I have 2 instances on one machine. (test,demo)
    env oracle 8.1.7 / hp -Unix

    I am having a export backup from test instance.

    It is a user level backup. It is not a entire database backup.

    Now i have to import 3 users and their data in to demo instance for testing purpose.

    Note - The user names in the test instance are entirely different from those of demo.


    so what i will be doing is

    1 i will create those 3 users in the demo instance .

    2 i will give this Ignore = y option when i import.

    is this the correct way ?

    please advise me how to do this .

    Thanks

    pravin
    ----------------------------------------------
    In the middle of difficulty lies opportunity.
    Albert Einstein (1879-1955)






  2. #2
    Join Date
    Aug 2000
    Posts
    236
    1. 2 instances means 2 databases to keep it simple.
    2. User level import means you have only one user's data to import and not 3.

    So:

    1. Do a full database export from test or 2 user level exports from tes.

    2. When importing use: fromuser='xxx' touser='yyy' clause.

    And finally try to read the documentation at lease once.

    Nizar

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