Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> archive solution problem
Hello,
I have trouble with archive solution.
There is big table TABLEX partitioned by Date (say week partitions,
number of records per month ~50*10^6).
There is also table PLUG_TABLEX with identical structure to TABLEX but
it has no records.
User can archive partition PARTITIONX - database file NEW_FILE is
created then tablespace New_TBS is created on new database file.
After this table ARCHIVE_TABLEX is created on NEW_TBS and data from
PARTITIONX is moved to it. PARTITIONX is deleted from TABLEX.
Tablespace NEW_TBS is exported from database, NEW_FILE is copied into
tape. Database file NEW_FILE is removed.
On schema stay TABLEX and PLUG_TABLEX - they have identical structure
but PLUG_TABLEX is empty.
When user want see some old data then NEW_FILE is imported into
database - and there is performed
partition exchange between ARCHIVE_TABLEX and some partition from
PLUG_TABLEX. User can browse data by select records
from PLUG_TABLEX. And this is OK - works fine but...
TABLEX sometimes (once per 6 months) changes its DDL - one columns is
added, one removed (PLUG_TABLEX follow changes).
Then exchange partition not work 'cos tables structures are different.
And what to do now?Every time when TABLEX changes - plug all archive
files into database and perform DDL on archive tables ?
Any ideas?
Thanks for your time,
Peter
Received on Thu Nov 25 2004 - 05:23:07 CST