DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Delete Column

Hybrid View

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    I heard there is a function in oracle8i to delete the columns .

    I wonder why it works , as I was taught in oracle7.3 , no possibility to do that.

    Is the whole table data will be rearranged and it should be very slow?

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Yes, in 8i you can drop a column. The column is deleted from the table definition with the data.
    dropping a column may be slow for large tables. In that case you can use ALTER TABLE SET UNUSED to mark the colum unused and can delete it later by ALTER TABLE DROP COLUMN..

    Sanjay

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