ORA-30739: cannot drop a table that has subtables

Question Posted / guest

2 Answers
3544 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

PLS-00616: type mismatch found at 'string' among result expressions in a CASE expression

1 Answers

QSM-00779: the specified directive conflicts with the existing directive string

1 Answers

ORA-23619: non-Oracle system error: string

1 Answers

RMAN-05506: error during recursive execution

1 Answers

ORA-16644: apply instance not available

1 Answers

RMAN-05002: aborting point-in-time tablespace recovery

1 Answers

ORA-01337: log file has a different compatibility version

1 Answers

TNS-00503: Illegal ADDRESS parameters

1 Answers

ORA-26090: row is in partial state

1 Answers

ORA-01549: tablespace not empty, use INCLUDING CONTENTS option

1 Answers

ORA-00489: ARB* process terminated with error

1 Answers

ORA-28001: the password has expired

1 Answers

For more Oracle Errors Interview Questions Click Here