刚接手一个使用exp/imp进行备份的系统,查看备份日志时发现如下错误
EXP-00079: Data in table "BILLMKTDETAIL" is protected. Conventional path may only be exporting partial table.
. . exporting table BILLMKTDETAIL 21793 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
对于EXP-00079,Metalink Doc ID 277606.1的解决方案有三种:
1. Run a DIRECT path export (Oracle8i and above), while connected as a user who has the EXP_FULL_DATABASE role.
2.Run the export while connected AS SYSDBA (Oracle8i and above).
3. Run the export while connected as a user who has the EXEMPT ACCESS POLICY (only available in Oracle9i and above).
对于第一种情况暂时不考虑,本想采用第二种情况,但是,在Doc ID 277237.1中指出
SYSDBA is used internally in the Oracle database and has specialized functions. Its behavior is not the same as for generalized users. For example, the SYS user cannot do a transaction level consistent read (read-only transaction). Queries by SYS will return changes made during the transaction even if SYS has set the transaction to be READ ONLY. Therefore export parameters like CONSISTENT, OBJECT_CONSISTENT, FLASHBACK_SCN, and FLASHBACK_TIME cannot be used.
这样,即使制定了consistent=y也不能保证表间的一致性。
因此,还是选择第三种方案,即:
grant emepty access policy to xxx;
对于EXP-00091,就简单多了,这个错误在Doc ID 730106.1里有详细的描述,知道NLS_LANG对就没有什么问题了。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19423/viewspace-1048658/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/19423/viewspace-1048658/