OEM Export/Import Urgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: OEM Export/Import Urgent

  1. #1
    Join Date
    Aug 2001
    Posts
    134

    Angry


    Hi All
    When I EXPORT a user/table with data from OEM the message is successfull run, See the job history. When I see the histroy the status is failed.
    How I can create Export file with OEM and Import that file in new schema. Please write step by step.
    Thanx

  2. #2
    Join Date
    Nov 2000
    Posts
    74
    Sometimes it says it failed when there are only warning messages. Did you look at the error message to see what the error was? Did your user id have the role of export_full_database and import_full_database? In Windows
    sometimes it is an authentication error because your user id doesn't have permission for "log on as batch job".
    After it exports correctly to a file such as D:\expdata.dmp, you go into OEM , select the target database you want to import into, and select IMPORT and list D:\expdata.dmp as the input data and it leads you through the screens to where you submit the job.

    Hope this helps.

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What is your OEM version?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Aug 2001
    Posts
    134

    I m using 8.1.7 and all privilages are grant to user.

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