Can sqlldr automatically create a table?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Can sqlldr automatically create a table?

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Posts
    34

    Smile

    Just checking.

    I've got a flat file with about 450 columns in it (from an old VSAM database) that I want to load into a huge Oracle table.

    Can sqlldr automatically create this table for me?

    Thanks!

    Joe B.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    No.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378
    nope

    - magnus

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    You are doomed!!!

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    May 2001
    Posts
    41
    Yes you can do one thing open that data base data in Excel Worksheet and Save as comma delimated text file then you can load from SQLLDR....

    Enjoy.....

    ramesh


  6. #6
    Join Date
    Sep 2000
    Posts
    17
    Hi,

    SQL Loader cannot create a table. But you can do like this. Convert that flat file as Excel worksheet. Import that excel sheet into Access Database as a table. From there you can export to an oracle database. Access DB can create a table in Oracle Database.

    Nag.....
    nag

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