for that drop table error - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

for that drop table error

for that drop table error# Database - 数据库

g*o2002-05-09 07:05

1 楼

For that drop table error.
I met the same problem with you today.
The situation is that I exported one table called "Contact_LIST_2001" from MS ACCESS into ORACLE, after exported successfully,
I tried to drop this table by using query
DROP TABLE Contact_LIST_2001;
I got the error "the table or view does not exist"
Then I use the query
DROP TABLE "Contact_LIST_2001";
I was successfully dopping that table.

c*d2002-05-09 07:05

2 楼

lol. some oracle ABC, oracle will take all your command line input as upper
case.

MS ACCESS into ORACLE, after exported successfully,

【在 g***o 的大作中提到】

: For that drop table error.
: I met the same problem with you today.
: The situation is that I exported one table called "Contact_LIST_2001" from MS ACCESS into ORACLE, after exported successfully,
: I tried to drop this table by using query
: DROP TABLE Contact_LIST_2001;
: I got the error "the table or view does not exist"
: Then I use the query
: DROP TABLE "Contact_LIST_2001";
: I was successfully dopping that table.