Project and Portfolio Management Practitioners Forum

Oracle Full DB Export / Import

Calvin KS Cheun
Valued Contributor.

Oracle Full DB Export / Import

Currently we backup our PPM instance using the Oracle Enterprise Manager and performing a database dump on the whole PPM database, however there's always one table that causes an error:

ORA-31693: Table data object "SYSMAN"."MGMT_NOTIFY_QTABLE" failed to load/unload and is being skipped due to error:
ORA-06564: object DB_EXPORTS does not exist

We're planning to do a disaster recovery exercise soon to see if it has any impact, but just want to know if anyone knows anything about that particular table or seen that error before?

Also, if anybody can outline some tips in addition to the steps provided in the Admin Guide of PPM that would be great.