| problem to load data TO ORACLE (merged 3 cross-posts) [message #169795] |
Fri, 28 April 2006 14:03  |
kespinoza97
Messages: 6
Registered: April 2006
Location: Panama
|
Junior Member |
|
|
I have a problem, I need to load data to ORACLE in this format .txt
DFASD|SIOFSF|34JKJ|^MRERWR|RERE|SDFSDF|^MDKFSDF|992K|JSFSD
This block it has several followed records or registry , that is the sign ^M is a end of record but when load the data ,it created as 1 single registry and does not have to be must create 3 registries because the sign ^M me does not recognize it like end of record.
MY QUESTION:
That steps I must do so that my CTL (control file) understands when raising the data that the sign ^M is a end of record and creates the following registry.. PLEASE,,,
|
|
|
|
| problem to load data [message #169796 is a reply to message #169795] |
Fri, 28 April 2006 14:06  |
kespinoza97
Messages: 6
Registered: April 2006
Location: Panama
|
Junior Member |
|
|
I have a problem, I need to load data to ORACLE in this format .txt
DFASD|SIOFSF|34JKJ|^MRERWR|RERE|SDFSDF|^MDKFSDF|992K|JSFSD
This block it has several followed records or registry , that is the sign ^M is a end of record but when load the data ,it created as 1 single registry and does not have to be must create 3 registries because the sign ^M me does not recognize it like end of record.
MY QUESTION:
That steps I must do so that my CTL (control file) understands when raising the data that the sign ^M is a end of record and creates the following registry.. PLEASE,,,
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
