Oracle Database Discussions

Hi,

Customer on 11.2.0.1, Linux x86-64.

SQL> desc testtbl
Name Null? Type
----------------------------------------- -------- ----------------------------
COL1 VARCHAR2(10)
INCIDENT_DT_TM NOT NULL DATE
TESTCOL123456777 VARCHAR2(10)
TESTCOL1234567 VARCHAR2(10)

SQL> alter table testtbl drop column TESTCOL123456777;
alter table testtbl drop column TESTCOL123456777
*
ERROR at line 1:
ORA-00972: identifier is too long

I count 20 characters, not 30.

Customer is using/testing total recall.

customer then ran:
SQL> alter table testtbl rename column TESTCOL123456777 to testcol12345;

Table altered.

SQL> alter table testtbl drop column testcol12345;

Table altered.

SQL> select * from testtbl;

COL1 INCIDENT_ TESTCOL123
---------- --------- ----------
111 17-MAR-11
111 17-MAR-11
111 17-MAR-11
111 17-MAR-11

SQL> select * from testtbl as of timestamp(systimestamp -1);
select * from testtbl as of timestamp(systimestamp -1)
*
ERROR at line 1:
ORA-00904: "TESTCOL12345": invalid identifier

I'm not sure why the ORA-00972 signaled, nor why the column failed to materialize in the select from a flashed version.

Thanks,
Steve