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

Thread: Table Versioning for oracle8i

  1. #1
    Join Date
    Mar 2003
    Posts
    20

    Question Table Versioning for oracle8i

    Hi everybody,
    I have to implement table versioning to one of our projects. The scenario is as follows:
    I have a tab_A in schema user_1.When ever user modifies the table tab_A,just before modifying the table tab_A,I want to store this table tab_A in to user_2 with the table name as tab_A1.The table tab_A remains in the same schema as before with the modification.The old table is moved to user_2 schema with the name tab_A1. Here modification of table means adding columns to respective table.I want to increment the tab_A1..tab_A2..tab_A3..tab_An.. whenever the user modifies the table tab_A each time and move the corresponding table to user_2 schema.
    I am using oracle8i v8.1.7 on WIN2K.
    Any suggestions?
    Thanking you
    Suresh.H.T
    sureshht@yahoo.com

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    well i should say thats its not a very good idea of versioning. What if you database crashes ??

    User versioning tools like Designer, Clear Case (rational Rose) or in unix u can user sccs (Sourcs code control system)

    And if you want to do it your way, use triggers

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Mar 2003
    Posts
    20
    Can I write trigger when user modifies the table by adding a new column?
    Suresh.H.T

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    S
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #5
    Join Date
    Aug 2002
    Posts
    115
    wow..this is kewl!

    create or replace trigger DDLTrigger
    after DDL on database
    begin
    //ora_sysevent gives the evenr..like alter
    //ora_dict_obj_owner..gives user
    //ora_dict_obj_name...gives tablename

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