ORA-30739: cannot drop a table that has subtables

Question Posted / guest

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

NZE-28824: invalid encryption/decryption/signature state passed

1 Answers

PLS-00458: subprogram 'string' cannot be called from a REPEATABLE subprogram

1 Answers

ORA-30557: function based index could not be properly maintained

1 Answers

ORA-02164: DATAFILE clause specified more than once

1 Answers

ORA-29859: error occurred in the execution of ODCIINDEXTRUNCATE routine

1 Answers

ORA-30051: VERSIONS clause not allowed here

1 Answers

ORA-30087: Adding two datetime values is not allowed

1 Answers Oracle,

DRG-11870: Response From WAIS Server Too Large -- Extra Lines Ignored

1 Answers

RMAN-05507: standby controlfile checkpoint (string) is more recent than duplication point in time (string)

1 Answers

TNS-01441: Number of filtering rules currently in effect: number

1 Answers

RMAN-20039: format requires character when duplexing

1 Answers

ORA-27366: job "string.string" is not running

1 Answers

For more Oracle Errors Interview Questions Click Here