Hi
I wanted to delete some unwanted data in one of my oracle
database.20 000 of records are there. This is actually on production .
manually to delete a record , it takes 2 mins of time.
So now i decided to write a perl script to do this function
by learning on the web. Can somebody give me a exact guide to delete
that amount of data , without giving any impact for performance of the
database and i would like to ask what is the better way to do such a
execution ?
Do we have to implement more threads ?
as i mentioned below , i am tring to write the code.
#!/usr/bin/perl -w
use DBI;
my ($dbh, $sth);
### Perform the connection using the Oracle driver
$dbh = DBI->connect( "dbi:Oracle:dbname", "login ID", "password" , {
PrintError => 0, ### Don't report errors via warn( )
RaiseError => 1 ### Do report errors via die( )
} );
### Prepare a SQL statement for execution
$sth = $dbh->prepare( "DELETE rec1,rec2 * FROM TB1" );
### Execute the statement in the database
$sth->execute( );
}
### Disconnect from the database
$dbh->disconnect( );
exit;
Many Thanks
Luke
New Email addresses available on Yahoo!
Get the Email name you've always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!
http://mail.promotions.yahoo.com/newdomains/aa/
