ORA-30739: cannot drop a table that has subtables

Question Posted / guest

2 Answers
3440 Views
I also Faced
E-Mail Answers

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-16724: the intended state for the database has been set to OFFLINE

1 Answers

PLS-00630: pipelined functions must have a supported collection return type

2 Answers

ORA-26711: remote table does not contain a primary key constraint

1 Answers

ORA-28670: mapping table cannot be dropped due to an existing bitmap index

1 Answers

PCC-00128: Command line processor severe error

1 Answers

AMD-00146: Custom Measure "string" already exists in Workspace "string"

1 Answers

TNS-12640: Authentication adapter initialization failed

1 Answers

ORA-25244: dequeue index key not found, QUEUE string, rowid string

1 Answers

NNO-00803: Error: OCI_INVALID_HANDLE

1 Answers

SQL*Loader-00620: Initial enclosure character not found

1 Answers

ORA-38422: invalid datatype for the attribute: string

1 Answers

ORA-28030: Server encountered problems accessing LDAP directory service

1 Answers

For more Oracle Errors Interview Questions Click Here