0911

来源:互联网 发布:seo外包hane888 编辑:程序博客网 时间:2024/06/02 00:56
ERROR at line 1:
ORA-01652: 无法通过 1024 (在表空间 DATA 中) 扩展 temp 段 ORA-06512:
在 "SYS.DBMS_REDEFINITION", line 52
ORA-06512: 在 "SYS.DBMS_REDEFINITION", line 1646


ERROR at line 1:
ORA-00600: 内部错误代码, 参数: [kkzucmvl_ChkMVLog: kkzlglnm], [], [], [], [],
[], [], [], [], [], [], []
ORA-06512: 在 "SYS.DBMS_REDEFINITION", line 52
ORA-06512: 在 "SYS.DBMS_REDEFINITION", line 1646
ORA-06512: 在 line 1



ORA-26563: 不允许重命名此表

USER is "AIKI"
SQL> drop materialized view log on t1;

Materialized view log dropped.


SQL>  EXEC DBMS_REDEFINITION.START_REDEF_TABLE(USER, 'T1','PT1');

PL/SQL procedure successfully completed.

Elapsed: 00:07:28.22
SQL> EXEC DBMS_REDEFINITION.FINISH_REDEF_TABLE(user,'T1','PT1');


SQL>  EXEC DBMS_REDEFINITION.START_REDEF_TABLE(USER, 'T1','PT1');

PL/SQL procedure successfully completed.

Elapsed: 00:00:40.33


原创粉丝点击