匿名用户
5M参考了一个12c的样例
https://ezdba.wordpress.com/2016/05/17/logminer-pluggable-database/
在19.23做以下操作还是报错:
SQL> alter session set container=pdb1;
Session altered.
SQL> create directory scripts as '/home/oracle/dba/scripts';
Directory created.
SQL>
SQL> exec dbms_logmnr_d.build('minerPDB1.dic', 'SCRIPTS', dbms_logmnr_d.store_in_flat_file);
BEGIN dbms_logmnr_d.build('minerPDB1.dic', 'SCRIPTS', dbms_logmnr_d.store_in_flat_file); END;
*
ERROR at line 1:
ORA-29282: invalid file ID
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8660
ORA-06512: at "SYS.UTL_FILE", line 1160
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8185
ORA-65040: operation not allowed from within a pluggable database
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8065
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8608
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8674
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8822
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 55
ORA-06512: at line 1
请问19c怎么用logminer抓取pdb的信息,最好给个样例或者有样例的链接
墨值悬赏


评论
