SQL> create table abc (id char(1));Table created.SQL> create table ABC (id char(1)); create table ABC (id char(1)) * ERROR at line 1: ORA-00955: name is already used by an existing object SQL> create table "abc" (id char(1));Table created.SQL> select table_name from user_tables;TABLE_NAME ------------------------------ ABC COLOCATED DISORGANIZED PLAN_TABLE TEST TMPTEST TST abc8 rows selected.SQL> drop table abc 2 ;Table dropped.SQL> desc abc ERROR: ORA-04043: object abc does not exist SQL> desc "abc"; Name Null? Type ----------------------------------------- -------- ---------------------------- ID CHAR(1)SQL> drop table ABC; drop table ABC * ERROR at line 1: ORA-00942: table or view does not exist SQL> drop table "ABC"; drop table "ABC" * ERROR at line 1: ORA-00942: table or view does not exist SQL> drop table "abc";Table dropped.
create table "Customer"也就是说把你的表名是“Customer”,也就是说你建 的表的表名包括引号啊,你Drop customer肯定找不到这个表了
create table ABC (id char(1))
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
SQL> create table "abc" (id char(1));Table created.SQL> select table_name from user_tables;TABLE_NAME
------------------------------
ABC
COLOCATED
DISORGANIZED
PLAN_TABLE
TEST
TMPTEST
TST
abc8 rows selected.SQL> drop table abc
2 ;Table dropped.SQL> desc abc
ERROR:
ORA-04043: object abc does not exist
SQL> desc "abc";
Name Null? Type
----------------------------------------- -------- ----------------------------
ID CHAR(1)SQL> drop table ABC;
drop table ABC
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> drop table "ABC";
drop table "ABC"
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> drop table "abc";Table dropped.