Home » RDBMS Server » Server Utilities » another external table problem - please help.
another external table problem - please help. [message #74163] Fri, 24 September 2004 02:07
petzi
Messages: 5
Registered: September 2004
Junior Member
Hi,

loading data from a file via external tables into an internal table, that is created every day (DATA_YYYYMMDD) - this is a requirement. - i have to load the data every hour because of the data amount.

I don't know how to resolve this problem...

maybe there's another possibility loading the records into the internal_table.

in the datafile the first datafield is a date (DATA_date - e.g. 20040923 --[>] this record needs to be inserted into the DATA_20040923 table,
- it's possible of an external application error - that a record 20040922 is in the same datafile)
I have to insert the record into the "right" DATA_YYYYMMDD table.

Is it possible to query all records on the external table (after the datafile is loaded into the external table) e.g. for "date" and then insert the "right" records into the "right" table???

I am googling for days....
thx...[<]!-- / message --[>]
Previous Topic: unable to start the oracleorahome81agent service
Next Topic: sql loader URGENT!
Goto Forum:
  


Current Time: Wed Jul 03 01:39:39 CDT 2024