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

ORA-19578: end of volume while duplexing to sequential files, backup piece incomplete

1 Answers  


EXP-00033: Could not find environment character set

1 Answers  


RMAN-10026: network error number-number occurred registering connection

1 Answers  


LPX-00306: inputed string ended with no corresponding closing '}'

1 Answers  


PLS-00629: PIPE statement cannot be used in non-pipelined functions

1 Answers  






RMAN-06069: the filename for datafile string is missing in the controlfile

1 Answers  


DRG-10708: invalid class id string for preference string

1 Answers  


NNO-00155: warning: hint number has missing address, hint ignored

1 Answers  


ORA-08433: invalid picture type in convert raw to number

1 Answers  


AUD-00806: first argument to SpeechContains must be a column

1 Answers  


ORA-06143: NETTCP: maximum connections exceeded

1 Answers  


ORA-03238: unable to extend LOB segment string.string subpartition string by string in tablespace string

1 Answers  


Categories