QSM-00511: invalid fact-tables specified in fact-filter



QSM-00511: invalid fact-tables specified in fact-filter..

Answer / guest

Cause: The tables specified in the fact-filter are not valid
fact-tables. A fact-table must have foreign-key constraints
to one or more of the dimension-tables in the data warehouse.

Action: Check the fact-filter is correctly specified; check
that appropriate constraints exist; and the user has
privileges to access the tables

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-08183: channel string: block restore complete, elapsed time: string

1 Answers  


NNL-00005: no server has been set. Use the "SET SERVER" command first

1 Answers  


PLS-00631: PARTITION-BY and CLUSTER/ORDER-BY clauses must be used with the same function argument

1 Answers  


RMAN-06487: changed proxy copy expired

1 Answers  


ORA-16725: the phase supplied to resource manager is invalid

1 Answers  


DRG-50933: parser hash insert failure

1 Answers  


ORA-29344: Owner validation failed - failed to match owner 'string'

1 Answers  


ORA-22369: invalid parameter encountered in method string

1 Answers  


ORA-01507: database not mounted

1 Answers  


ORA-10921: Cannot drop tablespace belonging to default temporary tablespace group

1 Answers  


PCC-02392: You are already in an EXEC SQL DECLARE SECTION

1 Answers  


ORA-27300: OS system dependent operation:string failed with status: string

1 Answers  


Categories