-
EXP-00008: ORACLE error 1003 encountered
I have an 8.1.6 database patched to a 8.1.6.3.8. The database seems happy while it is running, but when I do an exp I get two errors
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
Please help!
-
Have you rerun catalog/catproc since patching the database?
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
Yes I did. I just ran them again to be sure. I did another export and got identical errors.
-
try running catexp.sql (i know its included in the catalog.sql)
and spool the output and see if any signnificant error is there.
Amar
"There is a difference between knowing the path and walking the path."
-
How are you doing this export?
Are you uing command line, parfile?
MH
I remember when this place was cool.
-
Actually I did run catexp.sql too - I tried that first.
I am running a .bat file - I use this same format on all of the other servers and it works beautifully.
D:
set oracle_sid=sid
cd Oracle\admin\sidname\exp
exp username/password file=username.dmp log=username.log
-
is this a full or user level export
Amar
"There is a difference between knowing the path and walking the path."
-
It's both. I just put the user .bat in the last reply but I do a full also and get the same errors.
-
Can you run this manually with a parfile?
Try it with ROWS=N
MH
I remember when this place was cool.
-
Didn't make a difference. I am trying right now on a test server I have that is currently having the same problems. It was loaded at the same time.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|