ORA-30739: cannot drop a table that has subtables

Question Posted / guest

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

KUP-04037: terminator not found

1 Answers

ORA-01686: max # files (string) reached for the tablespace string

1 Answers

ORA-25293: Remote Recipient Subsribers and buffered operations not possible for Queue string

1 Answers

TNS-12675: External user name not available yet

1 Answers

ORA-09760: osnpui: cannot send break message

1 Answers

LFI-00113: Unable to initialize the Standard File object string.

1 Answers

ORA-09283: sllfsk: error skipping records

1 Answers

ORA-27034: maximum length of ORACLE_SID exceeded

1 Answers

ORA-29814: expecting USING or DEFAULT keyword

1 Answers

ORA-24281: invalid access past the maximum size of LOB parameter string

1 Answers

ORA-10648: Tablespace SYSAUX is not offline

1 Answers

ORA-10584: Can not invoke parallel recovery for test recovery

1 Answers

For more Oracle Errors Interview Questions Click Here