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