-
Hi!
Queries:
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!
Regards,
Amitstora.
-
In Oracle 8i, it is possible to drop a column from a table.
use:
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 ??
nk
-
Dropping exiting object type columns
Hi nk!
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!
Regards,
Amitstora.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|