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

ORA-31638: cannot attach to job string for user string

1 Answers  

DRG-50101: CORE LEM error: string

1 Answers  

IMG-00577: invalid quantize argument

1 Answers  

ORA-31122: The string operator has incorrect RHS value

1 Answers  

ORA-16599: Data Guard broker detected a stale configuration.

1 Answers  




ORA-08323: scnmin: close of bias lock failed

1 Answers  

ORA-12055: materialized view definition contains cyclic dependencies with existing materialized views

1 Answers  

ORA-19760: error starting change tracking

1 Answers  

RMAN-08549: database name (or lock name space) used for search: string

1 Answers  

ORA-16794: Database Guard is ON for primary database

1 Answers  

ORA-14626: values being added already exist in DEFAULT subpartition

1 Answers  

PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification

1 Answers  

For more Oracle Errors Interview Questions Click Here
Categories