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

Thread: Unused columns in 8i

  1. 01-10-2001, 03:56 AM #1
    darshil_db
    darshil_db is offline Junior Member
    Join Date
    Dec 2000
    Posts
    10
    Hi,

    I have set a column unused in 8i. Now I want to use it again. So what is syntex for that?
    Reply With Quote Reply With Quote
  2. 01-10-2001, 04:17 AM #2
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    You have to drop that column firs by

    ALTER TABLE tab DROP UNUSED COLUMNS;

    and then add a new column with the same name. There is no way you can reuse the column (I mean it's data) once it has ben marked UNUSED.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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