Altering Object Types!URGENT!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Altering Object Types!URGENT!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    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.

  2. #2
    Join Date
    Nov 2000
    Posts
    65
    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

  3. #3
    Join Date
    Feb 2001
    Posts
    286

    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
  •  



Click Here to Expand Forum to Full Width