Advice/Strategy needed - archiving of old data

[JMac]

System is growing and I want to move old data to a separate database (Datawarehouse scenario).

Does anyone know of any good sources of info of a strategy for this - or any tried and trusted methods?

Using Ora8.1.5 on NT4.

Thanks

[patnams]

First of all, it is not a Warehousing senario

1. you want to move to a different server altogether, then how do you intend to access the data ? It is not exactly load sharing that is part of Replication.

2. If you want to move to a different location, Create TableSpaces on a different server using datafile paths pointing to that server. Make the tablespace READONLY if you are not going to change that data. This way, the overhead on the database is reduced.

--sridhar

[JMac]

Not worried about accessing it on a day to day basis.
But it needs to be 'available' for audit purposes by clients.

So... current projects are in out OLTP server/db.

Old projects 'moved' to separate server/db for reporting or audit purposes only. I'm not concerened about accessing it in tandem with live production system.

[Calvin_Qiu]

You might use a range partitioned table to exchange your date out the table weekly or monthly. see Data Warehousing Guide for detailed information.