Results 1 to 4 of 4

Thread: export import

  1. #1
    Join Date
    Sep 2004

    Exclamation Unanswered: export import


    i am newbee to oracle 8i. i want to move my complete database with all roles,privs ,tables,data to an oracle residing on another machine.

    how can i use this using oem? please give me an elaborate help


  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 4
    Home machine:
    > exp sys/syspw file=db.dmp

    Another machine:
    > imp sys/syspw file=db.dmp

    If it is a newly created database, syspw is "change_on_install".

  3. #3
    Join Date
    Jun 2004
    Liverpool, NY USA
    Just an additional point for the newbie. You want to do a full database export and a full database import into an empty database. When you get done, your passwords and schemas will be the same as on your old machine. Also, make sure to pre-create your tablespaces with the approporate sizes to hold your copy of the data.
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Jun 2004
    Provided Answers: 1
    Using OEM, right-click on the database in the left-hand pane & select Data Management, then Export, & go through the wizard.

    When importing it's the same except, of course, you select Import instead of Export, & again go through the wizard.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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