1.We are using Object Types named Contact_ty.
Now I would like to delete two existing columns from it.
Is there a possibility to alter exiting object types or do it needs to be dropped and re-created again!
PS:The above object type is being used by several tables as of now!
In Oracle 8i, it is possible to drop a column from a table.
alter table employee
drop column comments
cascade constraints checkpoint 1000;
The above removes the column(comments) length and data from each row, freeing space in the data block. Because dropping a column in a large table can generate a large amount of rollback space, in the above a checkpoint is forced every 1000 rows.
I hope this helps ??
Dropping exiting object type columns
Thanks for your reply!
But you see the thing stands as I would like to drop columns in Object types and not from tables!
Your reply states dropping columns from tables!
Awaiting your reply!
Click Here to Expand Forum to Full Width