HELP for control file [message #70194] |
Mon, 29 April 2002 19:43 |
kullawat
Messages: 3 Registered: April 2002
|
Junior Member |
|
|
Help me pls
if my data in fom like this
----------- my data --------------------------
HP-UX nmsdb B.11.00 A 9000/800 04/20/02
00:00:01 %usr %sys %wio %idle
00:05:01 52 39 8 1
00:10:01 51 37 12 0
00:15:01 58 28 14 0
00:20:01 68 30 2 0
00:25:01 68 29 2 0
00:30:01 67 27 6 0
...
...
--------------------------------------------------
and my table in form
-----my table -------------------------------
DATEDATA (date)
TIMEPOINT (varchar2)
USR(number)
SYS(number)
WIO(number)
IDLE(number)
-------------------------------------------------
How can I create control file
|
|
|
Re: HELP for control file [message #70198 is a reply to message #70194] |
Wed, 01 May 2002 07:12 |
shankar
Messages: 29 Registered: January 2002
|
Junior Member |
|
|
Hi
I need a help for writing control file to load remote database table. I am trying to load remote table with different database credentials. I understand remote link is created.
My present control file:
LOAD DATA
REPLACE
INTO TABLE SANKAR -- Remote database table.
FIELDS TERMINATED BY " "
SANKAR is a remote database table.
Will SQL*LOADER support loading remote table? If Yes,
How to modify the control file?
Thanks
Shankar
|
|
|