Workaround for ORA-00904 following set Invisible column to Unused
(Doc ID 2807538.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
SQL> connect test/test;
Connected.
SQL> CREATE TABLE test_case
( customer_id number(10) NOT NULL,
customer_name varchar2(50) NOT NULL,
city varchar2(50)
); 2 3 4 5
Table created.
SQL> ALTER TABLE test_case MODIFY city INVISIBLE;
Table altered.
SQL> ALTER TABLE test_case SET UNUSED (city);
Table altered.
SQL> desc test_case
Name Null? Type
----------------------------------------- -------- ----------------------------
CUSTOMER_ID NOT NULL NUMBER(10)
CUSTOMER_NAME NOT NULL VARCHAR2(50)
From remote database, I get error.
SQL> select * from test.test_case@testdblink;
select * from test.test_case@testdblink
*
ERROR at line 1:
ORA-00904: "TEST"."P"."SYS_C00003_21091613:13:33$": invalid identifier
ORA-02063: preceding line from TESTDBLINK
Changes
set Invisible column to Unused
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |