Home » RDBMS Server » Server Utilities » Export Table to free space in Production Database
Export Table to free space in Production Database [message #228656] Tue, 03 April 2007 10:02 Go to next message
ademirviana
Messages: 1
Registered: April 2007
Location: Brasil
Junior Member
Hello,
I am just new here and would like your support. Also new in DBA world...
We have a system that is becoming quite slow because it uses a table (created by a DBA who worked here) that stores production data every 30 sec... As its becoming quite large I want do delete old data from it in order to free space in DataBase, since data less than 2005 doesnt interests us anymore...But even accessing it the system is hanging...As far as I know only deletion will not free disk space... How can I free the DB space?

I exported this table in order to keep it in another meadia (DVD, for example), just in case of recovery of data...

Thank you in Advance.

Ademir Viana
Brasil

Re: Export Table to free space in Production Database [message #228658 is a reply to message #228656] Tue, 03 April 2007 10:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Search this forum for HWM. You get all information.
Delete will not release the space. But truncate/alter table move will release the space.
You have got many options.
Simply, keet the data you want and remove the rest.
create table temp1 as select * from old_table where ....
recreate the indexes.
Drop the old.
Re: Export Table to free space in Production Database [message #228659 is a reply to message #228656] Tue, 03 April 2007 10:07 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
You have to consider three main area.
1. Performance.
You should generate statspack report and findout bottleneck.

2. Database Free Space.
Delete will not clear free space in your database.
you should re-organize database objects.

3.Backup
Export / Import is not BACKUP METHOD.
you should go for PROPER BACKUP METHOD.

export/import just DATA MOVING TOOL.

regards
Taj
Re: Export Table to free space in Production Database [message #228660 is a reply to message #228658] Tue, 03 April 2007 10:09 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Also search for "delete huge data".
Many threads will discuss the optimum methods that can be employed.
one such
http://www.orafaq.com/forum/m/130643/42800/?srch=delete+huge+data#msg_130643

[Updated on: Tue, 03 April 2007 10:09]

Report message to a moderator

Previous Topic: SQL-LOADER
Next Topic: import and export
Goto Forum:
  


Current Time: Mon Dec 02 07:43:35 CST 2024