DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Imp-00013

  1. #1
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865

    Imp-00013

    Hi All:

    I know it's pretty old issue but haven't find any standard solution either in google or in metalink.

    I have exported few tables from production with the user having full_export priv.

    while importing the same tables into test with the user having full_import priv. it is throughing the below errors.

    IMP-00013: only a DBA can import a file exported by another DBA

    IMP-00000: Import terminated unsuccessfully

    My Oracle version is 9.2.0.8.0 64bit on both the databases and the OS is SUN Sol 5.9

    Can any one provide me the solution / some links to find the solution?

    Thanks in advance,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    run the import as system. You are probably trying to do an imp fromuser...touser.

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool


    I beleive the message is self explanatory:


    IMP-00013: only a DBA can import a file exported by another DBA

    You need to import with an account with DBA privileges!

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    I am trying to Import with the user having DBA privs but no luck. I tried with SYSTEM and able to import successfully. It seems i need to drop and recreate the existing user from which I am trying to Import.

    Thank you,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

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