Re: Partitioning problems - Oracle 8.1.7.4

From: jaromir nemec <jaromir_at_db-nemec.com>
Date: Sun, 6 Feb 2005 21:29:46 +0100
Message-ID: <01b401c50c8a$9b731d80$3c02a8c0@JARAWIN>

> 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

Original Message ----- From: "Tim Gorman" <tim_at_evdbt.com> To: <Tony.Adolph_at_o2.com>; <oracle-l_at_freelists.org> Cc: <Maxim.Demenko_at_o2.com>; <Peter.Trischberger_at_o2.com>; "Tony Adolph" <t_adolph_at_hotmail.com>; <tony.adolph_at_tiscali.de> Sent: Saturday, February 05, 2005 6:36 PM Subject: Re: Partitioning problems - Oracle 8.1.7.4

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Feb 06 2005 - 15:32:49 CST