Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227

    Unanswered: ORA-00904 during export

    Hi,

    we have an oracle 8.1.5 database on Windows 2000 Server. Everything seems to work ok, but when I want to create a dump I get an ORA-00904 error as soon as it starts exporting the synonyms. Anyone got a clue?
    Johan

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Are you using the 8.1.5 export or are you using a different oracle version (check your path).

    Alan

  3. #3
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    using 8.1.5. Just found on another site that this is probable caused by the java virtual machine. I'm looking into that now.
    Johan

  4. #4
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    drop public synonym dbms_java;

    should work fine then - used to have same problem.

    Rgs,
    Breen.

  5. #5
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    ok, this did the trick.
    Thanks.
    Johan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •