当前位置: 代码迷 >> Oracle管理 >> 急到底为什么?解决办法
  详细解决方案

急到底为什么?解决办法

热度:100   发布时间:2016-04-24 05:23:36.0
急急急!!!到底为什么???
@ref_dis的时候,下面两条记录缺省了一段,怎么办 为何会如此
ALTER TABLE ATTRIBUTE_TRANSFORMATIONS$ disable CONSTRAINT ATTRIBUTE_TRANSFORMATI
ALTER TABLE REGISTRY$SCHEMAS disable CONSTRAINT REGISTRY_SCHEMA_FK 
SQL code
SQL> spool ref_dis.sqlStarted spooling to D:\maoweiting\softwear\oracle sql developer\ref_dis.sql SQL> SELECT 'ALTER TABLE ' || TABLE_NAME ||' '||  2  'disable CONSTRAINT ' || CONSTRAINT_NAME || ' ;'  3  FROM USER_CONSTRAINTS  4  WHERE  5  CONSTRAINT_TYPE = 'R'; 'ALTERTABLE'||TABLE_NAME||''||--------------------------------------------ALTER TABLE PLSQL_PROFILER_DATA disable CONSTRAINT SYS_C005466 ;ALTER TABLE PLSQL_PROFILER_UNITS disable CONSTRAINT SYS_C005463 ;ALTER TABLE OLAP_OLEDB_MDPROPS disable CONSTRAINT MDPROPVAL_FK ;ALTER TABLE WRM$_SNAPSHOT disable CONSTRAINT WRM$_SNAPSHOT_FK ;ALTER TABLE HS$_INST_INIT disable CONSTRAINT HS$_INST_INIT_FK1 ;ALTER TABLE HS$_CLASS_INIT disable CONSTRAINT HS$_CLASS_INIT_FK1 ;ALTER TABLE HS$_INST_DD disable CONSTRAINT HS$_INST_DD_FK1 ;ALTER TABLE HS$_INST_DD disable CONSTRAINT HS$_INST_DD_FK2 ;ALTER TABLE HS$_CLASS_DD disable CONSTRAINT HS$_CLASS_DD_FK1 ;ALTER TABLE HS$_CLASS_DD disable CONSTRAINT HS$_CLASS_DD_FK2 ;ALTER TABLE HS$_INST_CAPS disable CONSTRAINT HS$_INST_CAPS_FK1 ;ALTER TABLE HS$_INST_CAPS disable CONSTRAINT HS$_INST_CAPS_FK2 ;ALTER TABLE HS$_CLASS_CAPS disable CONSTRAINT HS$_CLASS_CAPS_FK1 ;ALTER TABLE HS$_CLASS_CAPS disable CONSTRAINT HS$_CLASS_CAPS_FK2 ;ALTER TABLE HS$_FDS_INST disable CONSTRAINT HS$_FDS_INST_FK1 ;ALTER TABLE ATTRIBUTE_TRANSFORMATIONS$ disable CONSTRAINT ATTRIBUTE_TRANSFORMATIALTER TABLE REGISTRY$SCHEMAS disable CONSTRAINT REGISTRY_SCHEMA_FK ;ALTER TABLE REGISTRY$ disable CONSTRAINT REGISTRY_PARENT_FK ; 18 rows selected SQL> spool offStopped spooling to D:\maoweiting\softwear\oracle sql developer\ref_dis.sql SQL> @ref_dis.sql 'ALTERTABLE'||TABLE_NAME||''||--------------------------------------------ALTER TABLE PLSQL_PROFILER_DATA disable CONSTRAINT SYS_C005466 ORA-00900: 无效 SQL 语句 Table altered Table altered Table altered Table altered Table altered Table altered Table altered Table altered Table altered Table altered Table altered Table altered Table altered Table altered ALTER TABLE ATTRIBUTE_TRANSFORMATIONS$ disable CONSTRAINT ATTRIBUTE_TRANSFORMATIALTER TABLE REGISTRY$SCHEMAS disable CONSTRAINT REGISTRY_SCHEMA_FK ORA-00933: SQL 命令未正确结束 Table altered 



------解决方案--------------------
你确定你文件保存了,重新启动了命令窗口?
------解决方案--------------------
ALTER TABLE ATTRIBUTE_TRANSFORMATIONS$ disable CONSTRAINT ATTRIBUTE_TRANSFORMATI
后面为什么没有分号呢?
  相关解决方案