Data Conversion

Hi, I have following code: foreach my $row (@$array_ref) { my ( $usr, $usr_det, $pwd_val) = @$row; #print "\tuser id :$usr\n"; #print "\tcard no :$usr_det\n"; #print "\tpasswd :$pwd_val\n"; open (FILE, "<file_name") die "Could not open the file: $!"; while (<FILE>) {

Hi all, I have to delete about 43 millions rows from a table, but the following conditions exist: - The table is not partitioned and unfortunately I can't modify the structure - The delete procedure must be done without stopping service, so I can't use CTAS, moving records and renaming table. - I can't use truncate because the records affected are selected in a

Hi all, I have two full sets of close database files backup. One on 28 June and another on 29 June. Today, 30 June, I need to restore the whole database by using the backup files on 29 June. But I found that one of the data files, user01.dbf, was corrupted. Since the database is running in noarchivelog mode and the online redo

Excellent website for MCSE, CCNA, A+, Oracle Exams, [link] Good luck.

It has come to my attention that my original post Mr Gordon Sauck Replies To Me By Email And Admits To Being A Police Agent has disappeared from Google Groups. But is archived here and other places on the web [link] It was sent Date: Sat, 14 Jun 2008 22:17:52 -0700 Message-ID:

Anyone using Samba here? Or knows how an INI-file structure looks like? What would you use to parse smb.conf or INI-files in a somehow automated/scripted manner? Let's say this is a part of smb.conf: [homes] valid users = user1, user2 [data] valid users = user1, user2 And we want to add "user3" to "valid users" in [homes] in a script.

From the "My other life chronicles" I have my first draft of my guide to House Concerts posted at MatthewMoranOnline.com. I've sent it to a few reviewers for clarity, spelling, usage, etc.  But, time being what it is (an old bald cheater ~ Ben Johnson), I

Hi, we're carrying out some data conversions, and do get a mysterious "INSERT INTO xxx_yyyyyyy ORA-00959: tablespace '_$deleted$8$0' does not exist" Things should be easy; just an ordinary tablespace with a normal table .... 10.2.0.1; linux. Any ideas ??; BR; Timo

thinking of writing a perl script with concurrent abilities. which Module is better 'Thread' or 'threads' ? thx.

LewisC's An Expert's Guide To Oracle Technology I've been working with EnterpriseDB's cloud offering recently and started looking around at what other databases are doing in the cloud. Amazon's SimpleDB Amazon is the 500 pound gorilla. The market leader in cloud computing

This is an excerpt from the latest version perlfaq8.pod, which comes with the standard Perl distribution. These postings aim to reduce the number of repeated questions as well as allow the community to review and update the answers. The latest version of the complete perlfaq is at [link] .

Hi all, we had corrupted one datafile and now the DB could not be open, but can be mount. Unfortunately, we are running our DB in NOARCHIVE mode and we don't have a backup too. We have a full dmp file only. STARTUP FORCE ORACLE instance started. Total System Global Area 27480224 bytes Fixed Size 73888 bytes

Hot off the presses; a new Redbook is available

There's no time left for DB2 Version 7 support after