-
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.
-
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.
-
The syntax I use is the following:
imp80 logon/password@db fromuser=schema touser=schema file= feedback=100 log=;
The tablespaces and users are the same.
-
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.
