Sign Up Login


  1. Categories >> ERRORS >> Database Errors >> Oracle Errors
  2. Suggest New Category

ORA-30739: cannot drop a table that has subtables

Question Posted / guest

Answers were Sorted based on User's Feedback



ORA-30739: cannot drop a table that has subtables..

Answer / guest

Cause: The user tried to drop a table that has subtables
defined under it.

Action: Drop all subtables before trying this operation.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

ORA-30739: cannot drop a table that has subtables..

Answer / reddy

how to hack the table

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

KUP-04059: found EOF in length portion of VARIABLE record in file string

1 Answers  

NMP-00002: no such SNMP variable name

1 Answers  

NNL-00410: Average response time: string

1 Answers  

SQL*Loader-00551: internal error: error initializing slf

1 Answers  

TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

1 Answers   Wipro,

DRG-11225: Third-party filter timed out.

1 Answers  

ORA-01631: max # extents (string) reached in table string.string

1 Answers  

ORA-39042: invalid transform name string

1 Answers  

ORA-39083: Object type string failed to create with error: string Failing sql is: string

1 Answers  

ORA-03127: no new operations allowed until the active operation ends

1 Answers  

TNS-12574: TNS:redirection denied

1 Answers  

ORA-30020: UNDO_MANAGEMENT=AUTO needs Compatibility string or greater

1 Answers  

For more Oracle Errors Interview Questions Click Here
Categories