rman 08591 oracle 10g,rman 备份archivelog报错:ORA-04063: view "SYS.DBA_CAPTURE" has errors

http://www.art2dec.com/documenta ... 01/README_rdbms.htm

Bug 3342089

Attempts to DROP TABLE result in an ORA-04063: table has errors when both of these conditions are true:

The table being dropped has columns that depend on an invalid type, such as a type that was altered or dropped forcibly without upgrading its dependents.

The RecycleBin feature is enabled for UNDROP TABLE support.

Workaround:

There are several workarounds for this problem:

Use DROP TABLE ... PURGE instead, if you are certain that you will not need to UNDROP the table at a later time.

Use ALTER TABLE ... UPGRADE INCLUDING DATA; DROP TABLE ..., if you will need to UNDROP the table at a later time.

Alternatively, you can use a temporary table, which allows you to delete the invalid table and retain the ability to UNDROP the valid subset of the original table. This is illustrated in the following script:

CREATE TABLE TMP AS SELECT * FROM ORIG;

DROP TABLE ORIG PURGE;

ALTER TABLE TMP RENAME TO ORIG;

DROP TABLE ORIG;

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值