Data in a text file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Data in a text file

  1. #1
    Join Date
    Jan 2001
    Posts
    138

    Data in a text file

    How do I dump data in a table into a text file? I have an export of the table. is there a way to do this? Thanks.

  2. #2
    Join Date
    Jun 2001
    Location
    California
    Posts
    124

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    the link is helpful to produce a flat file from an oracle table but as far as the dump file goes you will have to import the table first and then produce the flat file, you can't do it directly from a dump file
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    as far as the dump file goes you will have to import the table first

    But u you missed one thing - for import pls go through http://download-west.oracle.com/docs.../ch02.htm#1656
    Last edited by bhallar; 12-25-2003 at 10:32 PM.

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by bhallar
    as far as the dump file goes you will have to import the table first

    But u you missed one thing - for import pls go through http://download-west.oracle.com/docs.../ch02.htm#1656
    what am i missing, the poster said he had a dump file, you can't create a flat file from a dump file (at least not in an supported method), so he needs to import the dump file first
    I'm stmontgo and I approve of this message

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