> Why do you have a separate "archive" table at all? exactly; it's possible good enough to have only an archive (e.g. read only) tablespace. Archive *table* could be appropriate if you keep only selected columns of the original table or only some aggregated data. Jaromir http://www.db-nemec.com ----- Original Message ----- From: "Tim Gorman" <tim@xxxxxxxxx> To: <Tony.Adolph@xxxxxx>; <oracle-l@xxxxxxxxxxxxx> Cc: <Maxim.Demenko@xxxxxx>; <Peter.Trischberger@xxxxxx>; "Tony Adolph" <t_adolph@xxxxxxxxxxx>; <tony.adolph@xxxxxxxxxx> Sent: Saturday, February 05, 2005 6:36 PM Subject: Re: Partitioning problems - Oracle 8.1.7.4 -- //www.freelists.org/webpage/oracle-l