Support Article

Getting ORA-00942 error writing to BIX manifest tables

SA-28087

Summary



BIX 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.
 

Error Messages



ORA-00942 table or view does not exists


Steps to Reproduce

  1. 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
  2.  Run extract and see error in logs.


Root Cause



A 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.

Resolution



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

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.