drop schema问题?
先说一下环境,AIX 5.3 上安装的DB2 V9.1。无法删除一个schema。$ db2 set current schema agent
DB20000IThe SQL command completed successfully.
$ db2 "select current schema from sysibm.sysdummy1"
1
--------------------------------------------------------------------------------------------------------------------------------
AGENT
1 record(s) selected.
$ db2 drop schema agent restrict
DB21034EThe command was processed as an SQL statement because it was not a
valid Command Line Processor command.During SQL processing it returned:
SQL0204N"AGENT " is an undefined name.SQLSTATE=42704
$ db2 set current schema db2inst1
DB20000IThe SQL command completed successfully.
$ db2 "select current schema from sysibm.sysdummy1"
1
--------------------------------------------------------------------------------------------------------------------------------
DB2INST1
1 record(s) selected.
$ db2 drop schema agentrestrict
DB21034EThe command was processed as an SQL statement because it was not a
valid Command Line Processor command.During SQL processing it returned:
SQL0204N"AGENT " is an undefined name.SQLSTATE=42704
$ db2 set current schema agent
你可以设成当前的,但是他可以不存在!
你要是再建个表了,这个agent就存了!
删除schema之前必须行清理属于它的对象! 原帖由 大梦 于 2010-1-18 22:24 发表 http://bbs.chinaunix.net/images/common/back.gif
db2 set current schema agent
你可以设成当前的,但是他可以不存在!
你要是再建个表了,这个agent就存了!
删除schema之前必须行清理属于它的对象!
多谢斑竹!非常感谢!
这个DB2是怎么设计的,不存在的模式也可以设置,真是不可思议! 不存在的模式创建对象时会自动生成
db2好像在淡化模式的生成过程,只是作为对象的一个分类使用
页:
[1]