ORA-30739: cannot drop a table that has subtables

Question Posted / guest

2 Answers
3694 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-06563: top level procedure/function specified, cannot have subparts

1 Answers

ORA-17613: Failed to initialize Oracle Disk Manager library: string

1 Answers

ORA-32827: Messaging Gateway agent must be shut down

1 Answers

DRG-10520: failed to drop index: string

1 Answers

PLS-00351: Not logged onto database 'string'

1 Answers

ORA-16223: DDL skipped, unsupported in current version

1 Answers

EXP-00075: rounding FILESIZE down, new value is string

1 Answers

ORA-00282: UPI string call not supported, use ALTER DATABASE RECOVER

1 Answers

NNL-00891: Corrupted messages received: number

1 Answers

ORA-02420: missing schema authorization clause

1 Answers

ORA-00329: archived log begins at change string, need change string

1 Answers

ORA-09918: Unable to get user privileges from SQL*Net

1 Answers

For more Oracle Errors Interview Questions Click Here