Home » SQL & PL/SQL » SQL & PL/SQL » Need Urgent help
Need Urgent help [message #300854] Mon, 18 February 2008 05:04 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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

Previous Topic: Problem
Next Topic: Can i edit/add to tnsnames.ora file with SQLPLUS?
Goto Forum:
  


Current Time: Thu Feb 13 20:40:32 CST 2025