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-16514: the request was not found

1 Answers  


ORA-19691: %s is from different database: id=string, name=string

1 Answers  


NZE-28795: data type attribute did not terminate

1 Answers  


ORA-24059: invalid COMPATIBLE parameter setting string specified in DBMS_AQADM.string

1 Answers  


ORA-01118: cannot add any more database files: limit of string exceeded

1 Answers  






ORA-01632: max # extents (string) reached in index string.string

1 Answers  


ORA-31081: name not specified for global declaration

1 Answers  


ORA-29383: all leaves of top-plan string must be consumer groups

1 Answers  


ORA-30162: The OCIFile context is not initialzed

1 Answers  


PCC-00121: Arrays of VARCHAR pointers are not supported

1 Answers  


ORA-14637: cannot merge a subpartition with itself

1 Answers  


ORA-19637: backupPieceCreate requires file name when using DISK device

1 Answers  


Categories