Re: Partitioning problems - Oracle 8.1.7.4

  • From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 6 Feb 2005 21:29:46 +0100

> 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

Other related posts: