#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    India
    Posts
    22
    Rep Power
    0

    Question 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. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    India
    Posts
    22
    Rep Power
    0
    Thank you pabloj .. i solved my problem .. your reference link was very informative .. thanks .

IMN logo majestic logo threadwatch logo seochat tools logo