Problem solve Get help with specific problems with your technologies, process and projects.

Can I drop a column in SYS schema?

An Oracle user asks if they can drop a column in SYS schema.

I have a question about drop column features. I am not able to drop a column in SYS schema. I can drop a table in the same schema. Is it a feature of SYS schema or is there some other way to drop a column of my own table created in SYS schema?
You should never, never, never drop columns or tables in the SYS schema. The SYS schema is a special schema, containing the Data Dictionary. One should never drop tables or columns for Data Dictionary tables as this can lead to Data Dictionary corruption and a potentially unusable database. And one should never create their own tables in the SYS schema. If you have your own tables in the SYS schema, move them to a new schema. Then you wont have any problems dropping columns.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.