| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
