Maybe you created table "ORDER" using quotes.Code:sql> create table ORDER (c1 number); create table ORDER (c1 number) * ERROR at line 1: ORA-00903: invalid table name Elapsed: 00:00:00.16 sql> create table "order" (c1 number); Table created. Elapsed: 00:00:00.32 sql> desc order ERROR: ORA-00931: missing identifier sql> desc "order" Name Null? Type -------------------------------------------------------------------- -------- --------------------- C1 NUMBER sql> drop table order; drop table order * ERROR at line 1: ORA-00903: invalid table name Elapsed: 00:00:00.00 sql> drop table "order"; Table dropped. Elapsed: 00:00:00.31
HTH




Reply With Quote