import a full dump file - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: import a full dump file

  1. #11
    Join Date
    Dec 2001
    Location
    Duluth, Georgia, USA
    Posts
    99
    Hi pravin,

    I was trying to import only schema belonging to one user, not the entire dump file. The import proceeded for a while and imported some tables successfully, then ended while importing a large table.

    Jiong

  2. #12
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    Hi pravin,

    Now i got it , u want to have a USER created from the EXPORT FULL DUMP.

    imp userid =system/manager fromuser=xxxx touser=xxxx file=export.dmp.

    try doing this.

    once u do this u will have the user and all the schema objects created.

    Good luck. if u require any thing please question


    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  3. #13
    Join Date
    Dec 2001
    Location
    Duluth, Georgia, USA
    Posts
    99
    I used user_a to import schema belonging to user_a from a full dump file. The import proceeded for a while and successfully imported some tables then ended abnormally while importing a big table (see the record of the whole process in my previous post). I think I get the import started correctly. However, it ended in the middle of the import. I suspect the database could not start the archivelog so the import stopped. Hope this time I explained my question clearly.

    Thanks,
    Jiong

  4. #14
    Join Date
    Jan 2002
    Posts
    146
    Hi,

    IMP-00009: abnormal end of export file

    I suspect input file corruption or incompleteness.

    Try reading input file from start to end using...

    imp system/manager file=fname show=y full=y

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