give full details of this ORA-12988: cannot drop column
from table owned by SYS

Answers were Sorted based on User's Feedback



give full details of this ORA-12988: cannot drop column from table owned by SYS..

Answer / sandeep

sys admin is the only authorized one can drop or alter the
table , others can't make any changes.

Is This Answer Correct ?    32 Yes 4 No

give full details of this ORA-12988: cannot drop column from table owned by SYS..

Answer / neeraj jha

If this is the only error message, you should stop trying to
modify a system table (table owned by sys), as this is not
allowed.

Is This Answer Correct ?    26 Yes 1 No

give full details of this ORA-12988: cannot drop column from table owned by SYS..

Answer / nitin yadav

u can not drop the column of SYS tables

u can drop the veiws or procedure or other plsql objects.

Is This Answer Correct ?    12 Yes 2 No

give full details of this ORA-12988: cannot drop column from table owned by SYS..

Answer / chandu

Cause: An attempt was made to drop a column from a system
table.
Action: This action is not allowed

Is This Answer Correct ?    13 Yes 4 No

give full details of this ORA-12988: cannot drop column from table owned by SYS..

Answer / soosairaj

Does not commit your changes, because this table is SYS
schema's table

Is This Answer Correct ?    10 Yes 4 No

give full details of this ORA-12988: cannot drop column from table owned by SYS..

Answer / master_dba

You do not have enought permission to do requested
operation.
If you need to search oracle errors, you can query all of
them at http://www.allaboutoracle.com

Is This Answer Correct ?    9 Yes 5 No

give full details of this ORA-12988: cannot drop column from table owned by SYS..

Answer / bhupesh

Dont have the permission to midify the Database Object

Is This Answer Correct ?    10 Yes 7 No

give full details of this ORA-12988: cannot drop column from table owned by SYS..

Answer / thirumal

Cause
An attempt was made to drop a column from a system table.

Action
This action is not allowed.

Is This Answer Correct ?    6 Yes 3 No

Post New Answer

More Oracle Errors Interview Questions

TNS-12229: TNS:Interchange has no more free connections

1 Answers  


TNS-00100: Unable to allocate memory

1 Answers  


QSM-01031: materialized view, string, is stale in TRUSTED integrity mode

1 Answers  


ORA-31520: CDC subscription string already subscribes to publication ID string

1 Answers  


ORA-28664: a partitioned table may not be coalesced as a whole

1 Answers  






ORA-08196: Flashback Table operation is not allowed on AQ tables

1 Answers  


ORA-25126: Invalid name specified for BUFFER_POOL

1 Answers  


TNS-12612: TNS:connection is busy

1 Answers  


DRG-11205: user filter command contains illegal characters

1 Answers  


ORA-36690: (NTEXTCNV01) Error during conversion from NTEXT to TEXT.

1 Answers  


ORA-25352: no current transaction

1 Answers  


ORA-16755: failed to set initialization parameter

1 Answers  


Categories