i*****t
发帖数: 220 | 1 Please tell me how to drop a table in Oracle. I used in this way but have
error:
SQL> drop table MESSAGE;
drop table MESSAGE
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04052: error occurred when looking up remote object
What is wrong with it? Thanks. |
l**y
发帖数: 3 | 2 maybe you can input like this:
drop table "MESSAGE";
【在 i*****t 的大作中提到】
: Please tell me how to drop a table in Oracle. I used in this way but have
: error:
: SQL> drop table MESSAGE;
: drop table MESSAGE
: *
: ERROR at line 1:
: ORA-00604: error occurred at recursive SQL level 1
: ORA-04052: error occurred when looking up remote object
: What is wrong with it? Thanks.
|
a*****a
发帖数: 438 | 3 mabye MESSAGE is a reserved keyword?
【在 l**y 的大作中提到】
: maybe you can input like this:
: drop table "MESSAGE";
|
l**y
发帖数: 3 | 4 nod :)
【在 a*****a 的大作中提到】
: mabye MESSAGE is a reserved keyword?
|
l***s
发帖数: 126 | 5 that's weird. when u create table no any warning? hehe
【在 l**y 的大作中提到】
: nod :)
|
l********h
发帖数: 16 | 6 Does this table have associated child tables?
【在 i*****t 的大作中提到】
: Please tell me how to drop a table in Oracle. I used in this way but have
: error:
: SQL> drop table MESSAGE;
: drop table MESSAGE
: *
: ERROR at line 1:
: ORA-00604: error occurred at recursive SQL level 1
: ORA-04052: error occurred when looking up remote object
: What is wrong with it? Thanks.
|
