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 ...