Need Urgent help [message #300854] |
Mon, 18 February 2008 05:04  |
rman_yv
Messages: 9 Registered: February 2008
|
Junior Member |
|
|
Hello everyone i'm new to form and DBA job
we are using oracle 10g with red-hat enterprise os and is data warehousing and analytics jobs going here.
The problem is our org. is planning to archive the old data and purge/delete the data from the database for better performance.
As there are few tables with partitions and sub-partitions and few tables without partitions - now i need a procedure to show all tables in our db to the user and user selected tables with time duration need to get archived or backup and purge/delete from the particular db
Can anyone suggest which is the best way to do the same and how to proceed
|
|
|
Re: Need Urgent help [message #300861 is a reply to message #300854] |
Mon, 18 February 2008 06:23   |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
It depends on your environment.
delete, truncate, exchange partition, drop, insert select, create table as select... many ways, it depends on your case.
And it can't be used in urgency.
Regards
Michel
[Updated on: Mon, 18 February 2008 06:23] Report message to a moderator
|
|
|
Re: Need Urgent help [message #300866 is a reply to message #300854] |
Mon, 18 February 2008 06:40  |
rman_yv
Messages: 9 Registered: February 2008
|
Junior Member |
|
|
Thankyou Michel,
i'm sorry for marking this as urgent
but our data is of one tera byte per month i cannot create another table and dump data to that..
and also all the table are not partitioned and so i didn't understood hw to
|
|
|