QSM-00513: one or more of the workload tables is missing
Answer / guest
Cause: One or both of the workload tables are missing. The
two workload tables which should be present in the user's
schema are V_192216243_F_5_E_14_8_1 and
V_192216243_F_5_E_15_8_1; the former is mapped to
WORK$_IDEAL_MVIEW and the latter to WORK$_MVIEW_USAGE. The
workload tables are created by the Oracle Trace Formatter
when the data-collection-file (oraclesm.dat) is formatted by
the user.
Action: Check whether the Formatter succeeded in formatting
the data collection. Sometimes the V_192216243_F_5_E_14_8_1
(i.e WORK$_IDEAL_MVIEW) may not be created whereas the other
table is created. The most likely cause of this is the
init.ora parameters needed to invoke mview-rewrite are not
enabled. Check your
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-19755: could not open change tracking file
EXP-00007: dictionary shows no columns for string.string
ORA-19853: error preparing auxiliary instance string (error string)
ORA-12211: TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA
ORA-27366: job "string.string" is not running
ORA-27365: job has been notified to stop, but failed to do so immediately
ORA-00360: not a logfile member: string
ORA-31059: Cannot insert root XML document node if it already exists
ORA-27367: program "string.string" associated with this job is disabled
ORA-09743: smscre: could not attach shared memory.
ORA-27011: skgfrd: cannot read from file opened for write
ORA-12058: materialized view cannot use prebuilt table