logo
Redian新闻
>未名空间
>Database - 数据库
>
drop a table
avatar
drop a table# Database - 数据库
i*t
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.
avatar
l*y
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.
avatar
a*a
3 楼
mabye MESSAGE is a reserved keyword?

【在 l**y 的大作中提到】
: maybe you can input like this:
: drop table "MESSAGE";
avatar
l*y
4 楼
nod :)

【在 a*****a 的大作中提到】
: mabye MESSAGE is a reserved keyword?
avatar
l*s
5 楼
that's weird. when u create table no any warning? hehe

【在 l**y 的大作中提到】
: nod :)
avatar
l*h
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.
相关阅读
Re: how to use c language to implement Access Database operations?who has registration code for toad?Re: 蒙古国土荒漠化严重急：为何ACCESS中数据export为.txt文件后格式丢失？如何用join ... on语句查询三张表db2 default passwordhow to use c language to implement Access Database operations?Re: how to separate the table ---PSoracle help?Managment server in Oracle8iDoes VB works with OracleRe: 用Servlet显示数据库里的数据,分页的? (答案在这里)how to open .db file? how to particially delete record in sql server --- there is no field for autonumberIs there a download site of ERwin?远程配置ACCESS数据库how to register SQL Server in intranetbackup and refresh a web site server关于oracle的一个问题!Help! about Access2000 and VB6
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章，不代表同意其说法或描述，仅为提供更多信息，也不构成任何建议。文章信息的合法性及真实性由其作者负责，与Redian.news及其运营公司无关。欢迎投稿，如发现稿件侵权，或作者不愿在本网发表文章，请版权拥有者通知本网处理。