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

Thread: Import Problems!!!

  1. #1
    Join Date
    Mar 2001
    Posts
    4

    Angry

    IMP-00017: following statement failed with ORACLE error 3113:
    "GRANT SELECT ON "VWRAPPMCSTATUS" TO "DEFACTO""
    IMP-00003: ORACLE error 3113 encountered
    ORA-03113: end-of-file on communication channel
    IMP-00021: operating system error - error code (dec 2, hex 0x2)
    IMP-00000: Import terminated unsuccessfully

    IMP-00021: operating system error - error code (dec 2, hex 0x2)


    This is what I get when I'm trying to import a database.
    I'm using Oracle8.0.4 on NT4.0

    I'm at a loss. Please if anyone is familiar with this same type of import problems please let me know.

    Thanx in advance.

  2. #2
    Join Date
    Nov 2000
    Posts
    89
    Can you show us the actual imp command you used ?

    I usually have a process that I go through before I import:

    -Check the exports to see if they are OK

    -Gather user info for the schema that will be imported

    -Once I have all the info and a "gaurantee" that I have enough to import, I drop the user(cascade)- re-create the user giving him the exact tablespaces, grants and permissions that he had before the process.

    I always get errors if I don't do this carefully. Don't drop anything unless/before your sure of your exports and backups.


  3. #3
    Join Date
    Mar 2001
    Posts
    4
    The syntax I use is the following:

    imp80 logon/password@db fromuser=schema touser=schema file=<path> feedback=100 log=<path>;

    The tablespaces and users are the same.

  4. #4
    Join Date
    Mar 2001
    Posts
    4
    Sorry this is the right one.



    The syntax I use is the following:

    imp80 logon/password@db fromuser=schema touser=schema file=path feedback=100 log=path;

    The tablespaces and users are the same.

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