Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


QSM-00513: one or more of the workload tables is missing



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

Post New Answer

More Oracle Errors Interview Questions

TNS-12640: Authentication adapter initialization failed

1 Answers  


ORA-12539: TNS:buffer over- or under-flow

1 Answers  


ORA-25256: consumer cannot be specified with a single-consumer queue or an exception queue

1 Answers  


PCB-00105: Included file name "string" exceeds name limit of number characters

1 Answers  


RMAN-06069: the filename for datafile string is missing in the controlfile

1 Answers  






ORA-12221: TNS:illegal ADDRESS parameters

1 Answers  


ORA-12015: cannot create a fast refresh materialized view from a complex query

1 Answers  


NNO-00054: invalid domain name "string"

1 Answers  


O2U-00211: A type without attributes was translated

1 Answers  


NZE-29194: no CRL found in cache

1 Answers  


ORA-27417: BYWEEKNO clause is only supported when FREQ=YEARLY

1 Answers  


ORA-09977: skxfqhini: Error Connecting

1 Answers  






Categories