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

Thread: EXP-00008: ORACLE error 1003 encountered

  1. 02-07-2003, 10:04 AM #1
    ratfink
    ratfink is offline Junior Member
    Join Date
    Mar 2002
    Posts
    25

    Unhappy 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!
    Reply With Quote Reply With Quote
  2. 02-07-2003, 10:15 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!
    Reply With Quote Reply With Quote
  3. 02-07-2003, 11:31 AM #3
    ratfink
    ratfink is offline Junior Member
    Join Date
    Mar 2002
    Posts
    25
    Yes I did. I just ran them again to be sure. I did another export and got identical errors.
    Reply With Quote Reply With Quote
  4. 02-07-2003, 11:35 AM #4
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  5. 02-07-2003, 11:37 AM #5
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    How are you doing this export?
    Are you uing command line, parfile?

    MH
    I remember when this place was cool.
    Reply With Quote Reply With Quote
  6. 02-07-2003, 11:55 AM #6
    ratfink
    ratfink is offline Junior Member
    Join Date
    Mar 2002
    Posts
    25
    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
    Reply With Quote Reply With Quote
  7. 02-07-2003, 12:02 PM #7
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    is this a full or user level export
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  8. 02-07-2003, 12:29 PM #8
    ratfink
    ratfink is offline Junior Member
    Join Date
    Mar 2002
    Posts
    25
    It's both. I just put the user .bat in the last reply but I do a full also and get the same errors.
    Reply With Quote Reply With Quote
  9. 02-07-2003, 12:36 PM #9
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    Can you run this manually with a parfile?

    Try it with ROWS=N

    MH
    I remember when this place was cool.
    Reply With Quote Reply With Quote
  10. 02-07-2003, 12:43 PM #10
    ratfink
    ratfink is offline Junior Member
    Join Date
    Mar 2002
    Posts
    25
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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