DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: how can i load data from a test file without using any utility

  1. #1
    Join Date
    Oct 2002
    Posts
    109

    how can i load data from a test file without using any utility

    Hi Friends
    I need on help.Can you tell me how can I load the data from a test file with fixed format into the table,without using sql loader or Proc or Procobol.
    Is there any built in package to load data from a test file to the table.
    Thanks and regards
    Praveen sharma

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    ext table
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Oct 2002
    Posts
    109

    how can i load data from a test file without using any utility

    Thanks abhaysk.
    But I am sorry to say that I don't know what is ext table.
    can you help me out

    regards
    praveen

    ]
    Originally posted by abhaysk
    ext table

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  5. #5
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  6. #6
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    DBASupport.com also has a document on the subject:
    http://www.dbasupport.com/oracle/ora...Tables9i.shtml

    Correct me if I'm wrong, but wasn't there a way to select external data through a SQL SELECT? (I'm only working with 8i, so I lack the 9i experience)
    Last edited by efrijters; 09-16-2003 at 08:00 AM.
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

  7. #7
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    All I can think of for 8i is to use UTL_FILE in PL/SQL - it means you will have to parse the input yourself.
    Last edited by DaPi; 09-16-2003 at 08:56 AM.

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