Getting ORA-00942 error writing to BIX manifest tables
SummaryBIX extraction configured to write manifest data to a target database. Extraction is failing to write the PR_EXTRACT_SUMMARY and PR_EXTRACT_DETAIL manifest tables in target database.
ORA-00942 table or view does not exists
Steps to Reproduce
- In extract rule select the "Include Manifest" option and Output Format to be a database and specify the name of the database where you want the manifest to be written, for example yourTargetDB
- Run extract and see error in logs.
Root CauseA defect or configuration issue in the operating environment. The yourTargetDB default schema is not defined and as a result the current schema of the database user running the system is being used.
Add a prconfig (or Dynamic System Setting) setting like this for your TargetDB replacing yourTargetSchema with the name of the default schema where your manifest files are found in the yourTargetDB database.
<env name="database/databases/yourTargetDB/defaultSchema" value="yourTargetSchema" />
Published September 16, 2016 - Updated September 17, 2016