I have a very large table (Partitioned already ) with about 30Gb in size .
Once a row is inserted Normally we do not update or delete any records in it .
The daily inserts will be only 100-200MB per day for this table ...
To back this 200MB i backup a table which is 30Gb and which makes the dumpfile 19GB.
In case of any imports /recovery it is very time consumming
How do i split the table into two separate tables (Say old and new).
I want that to made as a read only tablespace then to be backed only once ...
I will jion the two tables as a single table as view ..
How how do enforce the constarints(Primary and unique etc ..)
It has to check for the values in the old table also ...
Any help will be of much use ...
Click Here to Expand Forum to Full Width