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

SQL*Loader-00417: SQL string (on column string) not allowed in direct path.

1 Answers  


ORA-22281: cannot perform operation with an updated locator

1 Answers  


ORA-37021: (XSMULTI02) Object workspace object is not acquired.

1 Answers  


ORA-13781: The tuning task does not exist.

1 Answers  


ORA-14310: VALUES LESS THAN or AT clause cannot be used with List partitioned tables

1 Answers  






TNS-00076: component by specifying the component name in

1 Answers  


ORA-16060: Log file is current

1 Answers  


ORA-15042: ASM disk "string" is missing

1 Answers  


ORA-36268: (XSCGMDLAGG01) 'string' is not a valid dimension value.

1 Answers  


ORA-04070: invalid trigger name

1 Answers  


ORA-22279: cannot perform operation with LOB buffering enabled

1 Answers  


TNS-12202: TNS:internal navigation error

1 Answers  


Categories