Conversion from Text file to Oracle database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Conversion from Text file to Oracle database

  1. #1
    Join Date
    Apr 2001
    Posts
    12

    Exclamation

    I have a text file having the information about hotels in the following format

    "1","Hotel oberoi","123/24","Nehru Place","New Delhi","2100022","oberoihotel@hotmail.com","250","$200-$2500","Non Smoking","its a luxurious 5 star hotel situated in heart of city. It has every facility such as Market,Bar,Movie etc."


    "2","Hotel Maurya Sheraton"..............

    Now I have to convert it into Oracle Database. Please let me know how to do it.

  2. #2
    Join Date
    Apr 2001
    Location
    UK
    Posts
    137
    SQL*Loader sounds like a good bet.

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Create a table with all the columns listed for all field values in the flat file and use this flatfile as input to the SQL*Loader. That solves your problem.

    Reddy,Sam

  4. #4
    Join Date
    Feb 2001
    Posts
    203
    create a table and load the data through sql loader.
    1. CREATE A TABLE

    2. WRITE A CONTROL FILE like
    LOAD DATA
    INFILE 'temp.txt'
    append
    into table test
    fields terminated by ','
    (column_name char,
    column name integer)

    Anyway this is the time to give a look SQLLDR book. If you got problems you are welcome to post. Good Luck

    sree

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width