SQL*Loader - Load Header Record
From: tone <dmclaude_at_yahoo.com>
Date: 10 Feb 2003 10:53:35 -0800
Message-ID: <5fff533a.0302101053.1234bcfd_at_posting.google.com>
Date: 10 Feb 2003 10:53:35 -0800
Message-ID: <5fff533a.0302101053.1234bcfd_at_posting.google.com>
Hi,
my question is this. is there any way (other than creating two control files) to load the first record of my text file into a "log" table?
so i have a text file like so
20020210005500
20020209450050009600 808
20020209450050009600 807
20020209450050009600 806
where the first row is a header of format (yyyymmddxxxxxxx) where the xxxxxxxx represents the count of records in the file. I want to load this date, count into a log table to verify that all records have been loaded into the data table.
Can anyone help me out?
-appreciate any help
-tone
Received on Mon Feb 10 2003 - 19:53:35 CET