| Snapshot refresh - giving invalid column name [message #68858] |
Mon, 06 December 2004 01:34  |
Rashmi Gohel
Messages: 1
Registered: December 2004
|
Junior Member |
|
|
Database Oracle 8i
After adding 2 new columns in the base table in database I created a snapshot for this in the other remote database (8i). But when I try to refresh this it gives the message 'Invalid column name'.
The same setup was functioning properly befire the 2 new columns were added.
I tried creating another table as the base table with the same set of data and column names, the snapshot created on this table works fine. But after renaming this table, to the original base table name, it gave the same error of 'Invalid column name'.
Which is the Dictionary table where the table column names are stored.
Thanks in advance.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
