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

Thread: urgent exp help pls

  1. #1
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87
    folks
    this is the error im getting when im exporting from one of our database.
    ''. . exporting table UPDATE_MGR 13 rows exported
    . . exporting table USER_RESOURCES 0 rows exported
    . exporting synonyms
    EXP-00008: ORACLE error 904 encountered
    ORA-00904: invalid column name
    EXP-00000: Export terminated unsuccessfully"

    due to this im not able to import all the objects in databse.
    this database from which ihave exported is working fine ,but this error of invalid column is what im concerned as there is nothing like that
    its very urgent
    folks
    pls
    sat

  2. #2
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    what version of oracle are you running?
    d.

  3. #3
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87
    hi im sorry..im running 8.1.5 on solaris 2.6..
    Now i did run catexp.sql after logging as internal still thats the problem thx
    sat
    sat

  4. #4
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    from metalink i have found (if running catexp doesn't work)
    Try after running $OH/javavm/install/initdbj.sql as internal (UNIX)
    read it first; i don't know what that script would do--i have not personally encountered

    d.

    [Edited by DBAtrix on 02-13-2001 at 05:13 PM]

  5. #5
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87
    Hi DBATrix.,
    the solution u gave solved my problem.Now im taking exports
    easily and importing..Thanks a lot buddy
    sat
    sat

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