Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    42

    Unanswered: export data from sql to a file

    Hi all,

    iam trying to export the data from sql prompt to a file in oracle, can you tell me how can we achieve this.

    Thank you.

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    Sorry question is not clear!
    U can use "spool"
    or u can used utl_file package to export all retrieved data from
    oracle tables to a file
    Pagnint
    (No need to search web before posting new question)

  3. #3
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246

    Re: export data from sql to a file

    "Export" in Oracle means something specific. It means using a particular executable named exp.exe (or exp80.exe) to put database objects and data into a binary file that only Oracle can read (if you want to import the data into other Oracle databases.)

    The "export" command cannot be run from SQL*Plus. It must be run from the command prompt.

    One interesting way to get your data out of Oracle without using Export is to connect your database to Microsoft Excel using an ODBC connection, and pull data into a spreadsheet then save as a .csv file.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

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