ADD,DELETE,MANAGE FIELDS!!!!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ADD,DELETE,MANAGE FIELDS!!!!!

  1. #1
    Join Date
    Nov 2000
    Posts
    29

    How add, delete or change field of table?

    If i want to do it i can't do it because there are consrains which don't allow me to do it.

    It can be done to delete all schema and make it newerely
    using scripts, but i am iteresting is there another method to make such operation?

    I know that in Oracle 8i i can do it, but does anybody
    know how do it on Oracle 7.3.4???

    Please, Help

    It is a question of all MY LIFE!!!!!



  2. #2
    Join Date
    Aug 2000
    Location
    Ny
    Posts
    105
    The best way to do it in 7.3.4 is to upgrade to 8i

    :-)

  3. #3
    Join Date
    Nov 1999
    Location
    Elbert, Colorado, USA
    Posts
    81
    You can ALTER TABLE to add or modify a field. However, prior to 8.1, there is no easy way to delete a field. You have to
    CREATE TABLE new_table AS SELECT all_but_the_columns_you_want_to_drop;
    Drop the table after disabling any foreign key constraints.
    RENAME new_table TO old_table.
    Recreate indexes, constraints.

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