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

Thread: Column Drop

  1. #1
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    I'm trying to drop column from the table (8i)

    First I have ran the statement
    Alter table table1 set unused (COL1)
    Table altered.


    Secondly I have ran the statement
    Alter table table1 drop column(COL1)

    I get error following error:
    ERROR at line 1:
    ORA-00904: invalid column name

    Thanks in Advance

  2. #2
    Join Date
    Feb 2001
    Posts
    184
    Hi,

    Once you have Unused Columns, You can not ask to to drop the column as you tried.

    Look

    Alter Table Mytable
    Set Unused (columnName);

    Now... You can't say to Drop Directly... Use This Instead

    Alter Table Mytable
    Drop Unused Columns; ... Don't change any thing in this except to give the Table name ..

    It should be fine... Any question

    oracledba8@orasearch.net

    Thanks..

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