Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Unanswered: Export and Import table from or to text file

    Hello all,

    Do you guys have any idea?
    I want to export my table to a text file
    and import a text file to a table

    Thanks a lot!!!

  2. #2
    Join Date
    May 2003
    Location
    France
    Posts
    112

    Re: Export and Import table from or to text file

    for export, you can use sqlplus and spool the result in a file or write pl/sql proc with utl_file to write a file

    for importing a text file, use sql*loader utility

    hope this help you

    Originally posted by lawbenny
    Hello all,

    Do you guys have any idea?
    I want to export my table to a text file
    and import a text file to a table

    Thanks a lot!!!

Posting Permissions

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