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


ORA-38445: TOP clause not allowed with no statistics



ORA-38445: TOP clause not allowed with no statistics..

Answer / guest

Cause: An attempt was made to use the TOP parameters clause
with no statistics available for the expression set.

Action: Collect statistics for the expression set and try again.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LPX-00284: namespace prefix to NULL URI is not allowed

1 Answers  


LPX-00320: No more attributes can be added to a non empty element

1 Answers  


ORA-15197: suppressing string additional ASM messages

1 Answers  


ORA-06906: CMX: cannot get maximum packet size from CMX

1 Answers  


In VB program, I got message as " No Transaction is Active" , Backend database is Oracle, This message is coming some user's PC and Not all user's PC Please help me to resolve this issue

2 Answers  






ORA-14287: cannot REBUILD a partition of a Composite Range partitioned index

1 Answers  


PCC-02391: Runtime context variable not of correct type

1 Answers  


RMAN-08047: channel string: starting compressed incremental level string datafile backupset

1 Answers  


ORA-01190: controlfile or data file string is from before the last RESETLOGS

1 Answers  


ORA-16511: messaging error using ksrget

1 Answers  


ORA-16520: unable to allocate resource id

1 Answers  


RMAN-06428: recovery catalog is not installed

1 Answers  






Categories