Results 1 to 4 of 4

Thread: Ora 904 Error

  1. #1
    Join Date
    Sep 2003
    Location
    lebanon
    Posts
    1

    Unanswered: Ora 904 Error

    Hi

    I AM TRYING TO EXPORT DATA FROM A 8.1.6.0.0 ORACLE DATABSE USING THE "EXP" FILE OF THE 8.1.7.0.0 ORACLE DATABASE

    AND IT GENERATES THIS ERROR
    ORA 904 COLUMN NAME INVALID

    CAN ANY ONE HELP TO RESOLVE THE PROBLEM

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: Ora 904 Error

    Originally posted by jadmoawad
    Hi

    I AM TRYING TO EXPORT DATA FROM A 8.1.6.0.0 ORACLE DATABSE USING THE "EXP" FILE OF THE 8.1.7.0.0 ORACLE DATABASE

    AND IT GENERATES THIS ERROR
    ORA 904 COLUMN NAME INVALID

    CAN ANY ONE HELP TO RESOLVE THE PROBLEM
    See Note:146392.1 on Metalink


    Known Bug:1470870

  3. #3
    Join Date
    Sep 2003
    Location
    LEBANON
    Posts
    1

    Re: Ora 904 Error

    Originally posted by anacedent
    See Note:146392.1 on Metalink


    Known Bug:1470870
    HI CAN U PLEASE GIVE ME THE EXACT SITE FOR THE NOTE COZ I DIDN'T SUCCEED TO FIND IT

  4. #4
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    what is means is that in 8.1.7 new columns were added to the export/import facility. So importing into a 8.1.7. database with the 8.1.6 imp utility fails with that problem.
    Also importing into 8.1.6. with the 8.1.7 utility fails with that error.
    To import succesfully, make sure that you use the 8.1.7 imp utility for importing into 8.1.7 database. To do so, go to shell or dos prompt and either set the ORACLE_HOME to the 8.1.7. home or change to the ORACLE_817HOME\bin directory and start imp from there.
    That should solve the problem

    Hope this helps
    Edwin van Hattem
    OCP DBA / System analyst

Posting Permissions

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