ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-23539

ORA-23539

原创 Linux操作系统 作者:LDean 时间:2011-09-02 15:15:54 0 删除 编辑

在进行表分区在线重定义时人为终止了操作,结果报出12019错误,网上查询了一下,把对应的物化视图日志和分区表的物化视图删掉即可重新操作。但当重新执行dbms_redefinition.can_redef_table后,运行dbms_redefinition.start_redef_table抛出23539错误,百度上竟然搜不到,google一下,给出的解决方案就是等待,看来是源表在重定义,哎7个多G的表,不知道要等多久



ORA-12091:

cannot online redefine table "string"."string" with materialized views
Cause:An attempt was made to online redefine a table that had materialized views defined on it or had a materialized view log defined on it or is a master.
Action:Drop all materialized views and materialized view logs before attempting to online redefine the table.
Oracle Error :: ORA-23539

table "string"."string" currently being redefined

Cause

An attempt was made to redefine a table which is currently involved in an ongoing redefinition.

Action

Do not perform. this redefinition operation on this table or wait till the ongoing redefinition of the table is completed.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25680865/viewspace-706486/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-06-11

  • 博文量
    17
  • 访问量
    38638