OsBC_SYS_400 021 Problem Export OPERA

Problem :

Training schema Opera night audit issue was due to training schema export/import was not done properly.

While taking live schema export the Opera schema tables are not properly exporting, we have run the below scripts and then we have to take new export.

Solution:

1/ Lancer le script suivant :

Conn sys/P####S as sysdba

grant all on directory data_pump_dir to system;

grant export full database to system;

grant exp_full_database to system;

grant all on directory data_pump_dir to sys;

grant export full database to sys;

grant exp_full_database to sys;

purge dba_recyclebin;

GRANT EXEMPT ACCESS POLICY to OPERA;