Re: Weired: ORA-904 (invalid column name)

I've got this error with a couple of new tables I created with no data in it. I was setting up replication using 11 tables, but I do not know if it was somehow related. I droped all the tables and owner (cascade) recreated everything. Seems to be working OK.

I have a feeling that this error is realted to some procedures that may affect database dictionary. Any further info anywhere?

Friedel Hosenfeld (friedel_at_pz-oekosys.uni-kiel.d400.de) wrote:
: Gary Myers wrote:
: >
: > Have you tried going throutgh the tables record by record in a cursor.
: > Or an EXPORT/IMPORT ? Those might show where the problem lies ?
: > What are the datatypes/sizes of the columns ?
: > gary
 

: I tried EXPORT/IMPORT (there I discovered the problem):
: While exporting the error message occurs, but in the import
: only the table structure is then imported (without data).
: Then queries are possible on that table (without errors).
 

: I didn't try browsing with a cursor (yet).
 

: Best regards,
: friedel

: --
: Friedel Hosenfeld http://www.pz-oekosys.uni-kiel.de/~friedel
: Ecosystem Research Centre friedel_at_pz-oekosys.uni-kiel.d400.de
: Schauenburger Str. 112
: D-24118 Kiel * FRG blue in the face?

--
________________________________________________________
  Whatever goes up has to go down. Whatever goes down,
        will very likely bounce back again.
________________________________________________________
                 ekupr_at_soho.ios.com
________________________________________________________