Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> archive solution problem

archive solution problem

From: Peter <petez_at_poczta.fm>
Date: 25 Nov 2004 03:23:07 -0800
Message-ID: <c4a853c6.0411250323.62c9f7bd@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US