|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
You don't need a fax machine to get faxes. Get a fax-to-email fax number from CallWave. Try it free.
|
|
#1
October 30th, 2003, 06:30 AM
|
|||
|
|||
importing into oracle table from '|' delimited file
We have our database running in INTEGRA4 (RDBMS) , and we want to migrate to Oracle, and as such we have to import data to oracle.
INTEGRA4 supports SELECT FROM Table INTO file .. delimited by ‘|’ command to get an Ascii dump of the table, and this is the only way I can export data in INTEGRA4. My problem is to import this ‘|’ delimited ASCII file in ORALCE table . Can someone help ? .. which is the best way to import such a file in an oracle table ? (I have 200 tables in my schema) 
|
|
#2
October 30th, 2003, 07:03 AM
|
||||
|
||||
|
Use SQLLoader, see this for reference, there is also a nice O'Reilly book
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) Understanding SQL Joins An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Last edited by pabloj : October 30th, 2003 at 07:06 AM.
|
|
#3
November 21st, 2003, 01:21 AM
|
|||
|
|||
|
Thank you pabloj .. i solved my problem .. your reference link was very informative .. thanks .
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > importing into oracle table from '|' delimited file |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
