My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.