| Archiving Huge tables [message #369520] |
Thu, 12 October 2000 04:51  |
Umitha Davey
Messages: 1
Registered: October 2000
|
Junior Member |
|
|
Hi,
We have a table to be archived ( around 19 million records), we tried the the following options
Option 1 :
 Create a new archive table and then
 Insert into archive table from main table
 Delete from Main table
 Commit frequently
But this method is taking a very long time (more than 24 hours)
Option 2 :
Create a Archive table and then populate with those that have to be retained, then rename using another temp table so that now the main table becomes the archive and the vice versa, here the concern is that all tables will have to be redone in terms of Synonyms and Indexes..
Can you please suggest some other better way of doing the same job in an efficient manner..
This is an urgent rqmt so would appreciate if you can get back to me immediately at
Umitha.davey@wipro.com
Thanks in Advance,
Umitha
|
|
|
|
| Re: Archiving Huge tables [message #369521 is a reply to message #369520] |
Thu, 12 October 2000 06:57  |
Girodaon
Messages: 4
Registered: August 2000
|
Junior Member |
|
|
Hi there!
Whats about using the MATERIALIZED VIEW / SNAPSHOT function. You simply create a MV archive
as select * from main (refresh never/on demand)!
hope it helps
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
