Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    4

    Unanswered: Import from the export

    Hi all,

    I got a export dump which has to be imported on another database. But unfortunately no details where give with the dump. Could u please let me is there any chance to get the details to import as the dump size is around 200GB.

    Thanks in advance.

    Regards.
    hanumolu

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    What "details" do you have in mind? The simplest import statement is
    Code:
    IMP username/password@database FILE=export_file.dmp
    Obviously, file name is known. Connect string (username, password and database alias) is something you should know.

    Regarding information you provided, I wouldn't know what else you'd like to know. What other forum members might need are exported database version, version of the newly created database, is it precreated (tablespaces etc.) or not, etc.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    If you just want to see what it is going to do without actually doing the export,

    Code:
    imp username/password@database FILE=export_file.dmp SHOW=Y
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Perhaps to add the LOG parameter (as 200 GB export file is quite large, so - it would be difficult to memorize all information that scrolled on the screen).

Posting Permissions

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