|
-
If you had the file in you control file, it could be something like this. I haven't tested this, but it should give you an idea of what to do.
LOAD DATA
INFILE *
INTO TABLE your_table
(call_date POSITION (1:18) "TO_DATE(:call_date, 'YYYY/MM/DDHH.MI.SS')",
account_id POSITION(19:41) )
BEGINDATA
2000/10/2306.58.39 006927279736
2000/10/2306.58.41 002947001037
2000/10/2306.59.01 004857213433
2000/10/2306.59.16 002940435236
2000/10/2306.59.22 008630556335
...
...
...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|