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-06002: NETASY: port read failure

1 Answers  


NNL-00240: Starting "string"...

1 Answers  


ORA-12922: concurrent ALTER DATABASE [NO] FORCE LOGGING command is running

1 Answers  


NZE-29228: Cannot calculate the number of bytes for output.

1 Answers  


ORA-07226: rtneco: unable to get terminal mode.

1 Answers  






TNS-02521: encryption/crypto-checksumming: Diffie-Hellman seed too small

1 Answers  


DRG-11506: record ignored on line string because of error(s)

1 Answers  


NNL-00290: Cancelled cache flush

1 Answers  


ORA-40102: invalid input string for data mining operation string

1 Answers  


ORA-00258: manual archiving in NOARCHIVELOG mode must identify log

1 Answers  


TNS-12641: Authentication service failed to initialize

1 Answers  


IMP-00072: Warning: The object table's object identifier is invalid.

1 Answers  


Categories