[ora@nbserver admin]$ sqlplus test/test
SQL*Plus: Release 8.1.7.0.0 - Production on Sun Feb 9 18:04:03 2003
(c) Copyright 2000 Oracle Corporation.All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
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
abc
8 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> create table abc (id char);
Table created.
SQL> create table "ABC" (id char);
create table "ABC" (id char)
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
SQL> create table "abc" ( id char );
Table created.
谢谢mistfire的提醒,呵呵,不加双引号,原来是 当作 "ABC"了的说