OraFAQ Forum: SQL & PL/SQL » regarding conversion of oracle database

Home » SQL & PL/SQL » SQL & PL/SQL » regarding conversion of oracle database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

regarding conversion of oracle database [message #23384]

Wed, 04 December 2002 21:54

sha
Messages: 84
Registered: July 2002

Member

Hi,
How can I convert a oracle table to non-oracle file like flat files(.csv,txt)?
explain me in detail.
thanx in advance
regards,
shastri

Report message to a moderator

Re: regarding conversion of oracle database [message #23385 is a reply to message #23384]

Wed, 04 December 2002 22:05

Barbara Boehmer
Messages: 9094
Registered: November 2002
Location: California, USA

Senior Member

Please click on the link below for Tom Kyte's response to this question. Notice that you can ask Tom Kyte questions about what he has written by scrolling down to where it says:

Was this response helpful to you? Let us know!

and clicking on it.

Extracting data to a flat file

Report message to a moderator

Re: still doubt regarding conversion of oracle database [message #23389 is a reply to message #23385]

Wed, 04 December 2002 23:00

sha
Messages: 84
Registered: July 2002

Member

hi,
still getting some errors,
file not found,load command not used etc.
I have issued this command at command prompt
sqlldr scott/tiger emp > emp.txt
I want my records to be comma delimited in emp.txt file
helpme
regards,
shastri

Report message to a moderator

Re: still doubt regarding conversion of oracle database [message #23391 is a reply to message #23385]

Thu, 05 December 2002 00:18

Barbara Boehmer
Messages: 9094
Registered: November 2002
Location: California, USA

Senior Member

I suspect that you did not read and understand all of the instructions or download the file and just tried to run the first command that you saw. Those methods may be too complicated for you at this point in time. Let's try something simpler for now, like this:

STORE  SET saved_settings REPLACE
SET    COLSEP ',' ECHO OFF FEEDBACK OFF HEADING OFF
SET    LINESIZE 1000 PAGESIZE 0 VERIFY OFF
SPOOL  emp.txt
SELECT * FROM emp;
SPOOL  OFF
START  saved_settings
EDIT   emp.txt

Report message to a moderator

thanx [message #23412 is a reply to message #23391]

Thu, 05 December 2002 20:39

sha
Messages: 84
Registered: July 2002

Member

thanx alot boehmer

Report message to a moderator

Previous Topic:	insert records from a table into another table ?
Next Topic:	String comparison...............

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 06:40:46 CDT 2024