QSM-00506: no fact-tables could be found



QSM-00506: no fact-tables could be found..

Answer / guest

Cause: The fact-filter is not specified, and there are no
fact-tables in the warehouse. A fact-table is a table having
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

DRG-13010: alt_value is already used by another sub lexer

1 Answers  


RMAN-06747: at least 1 channel of tertiary storage must be allocated to execute this command

1 Answers  


ORA-30133: reserved for future use

1 Answers  


ORA-12461: undefined level string for policy string

1 Answers  


SQL*Loader-00136: Invalid argument for RESUMABLE_NAME

1 Answers  






SQL*Loader-00942: partition string not part of table string

1 Answers  


ORA-25952: join index must only contain inner equi-joins

1 Answers  


ORA-12540: TNS:internal limit restriction exceeded

1 Answers  


LPX-00232: invalid use of a parameter entity reference

1 Answers  


RMAN-06599: tablespace string is not read-only

1 Answers  


ORA-29353: The transportable list is too long.

1 Answers  


NNO-00257: warning: cannot get serial number from region store

1 Answers  


Categories