ORA-30746: error occured while trying to drop column
"string" in table "string"



ORA-30746: error occured while trying to drop column "string" in table "string"..

Answer / guest

Cause: The user tried to drop a subtype with VALIDATE option
which tried to check for stored instances of the type in the
stated table

Action: Delete all instances of this subtype and then drop
the type.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-35587: (SQLOUT20) The nesting of table functions and SQL commands has exceeded the maximum of number levels.

1 Answers  


RMAN-04008: WARNING from target database: string

1 Answers  


ORA-25221: enqueue failed, signature specified queue not supporting non-repudiation

1 Answers  


NNL-00805: Queries received, type NAME-SERVER: number

1 Answers  


ORA-38442: The ADT "string" is not in a valid state.

1 Answers  






ORA-03123: operation would block

1 Answers  


ORA-38472: VARCHAR representation of the data item is too long.

1 Answers  


ORA-22888: duplicate SCOPE clauses for a REF column

1 Answers  


RMAN-06142: DEVICE TYPE cannot be specified with this command

1 Answers  


ORA-25250: Cannot specify a remote recipient for the message

1 Answers  


SQL*Loader-00285: %s may be used only in conventional path.

1 Answers  


ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable

3 Answers  


Categories