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

Thread: ORA-00904: invalid column name

Threaded View

  1. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Does this query show your column name?
    Do you have any miscellaneous characters around the new column name?
    Post the results of this query.

    Code:
    SELECT table_name, '|' || column_name || '|', data_type
      FROM all_tab_columns
     WHERE owner      = 'SCHEMAOWNER'    AND
           table_name = 'YOURTABLE_NAME'
     ORDER BY column_id;
    Last edited by gandolf989; 10-07-2004 at 10:24 AM.

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