Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002

    Unanswered: import full database

    I've an Oracle instance ORAX with 200 users

    The user TOM is the owner of the oracle objects and 199 users that are created with grant and private synonyms.

    Now I must EXPORT instance ORAX and import full in new instance ORAY.

    exp system/manager@orax full=y file=........ log=.........

    is correct this import?

    imp system/manager@oray full=y file=...... log=..............

    I'll import also 199 users???


  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 4
    Yes, it will. Actually, it will import ALL users, including your TOM and another 199 you know about and some others you (perhaps) don't know they even exist.

    Everything that was found in your old database will be imported into your new database.
    Last edited by Littlefoot; 09-02-04 at 08:32.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts