DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2000

    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
    The best way to do it in 7.3.4 is to upgrade to 8i


  3. #3
    Join Date
    Nov 1999
    Elbert, Colorado, USA
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.