OraFAQ Forum: Windows » converting text file into oracle table

Home » Infrastructure » Windows » converting text file into oracle table

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

converting text file into oracle table [message #100121]

Sat, 27 July 2002 04:59

mayur chudnaik
Messages: 4
Registered: July 2002

Junior Member

how can i take a text file data into oracle table.
and how can i take oracle data into text file.

for example:
i want to take emp table data into text file.and again i want to insert that data from text file to other table emp1. how can i do that?

Report message to a moderator

Re: converting text file into oracle table [message #100124 is a reply to message #100121]

Mon, 29 July 2002 13:11

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

1. use spooling (if the volume of data is small), utl_file( if volume is large) to unload data from oracle table into a text file.
2. Use sql*loader to load the text file with some data,
into an oracle table.

Report message to a moderator

Re: converting text file into oracle table [message #100126 is a reply to message #100121]

Tue, 30 July 2002 10:50

Grant
Messages: 578
Registered: January 2002

Senior Member

If your goal is to create a backup table then just go direct.

create table emp1 as select * from emp;

Report message to a moderator

Re: converting text file into oracle table [message #100883 is a reply to message #100121]

Wed, 04 February 2004 02:29

Dhanashri Gavai
Messages: 1
Registered: February 2004

Junior Member

I have same problem tha you arrise.

i.e. how can i take a text file data into oracle table.
and how can i take oracle data into text file.

for example:
i want to take emp table data into text file.and again i want to insert that data from text file to other table emp1. how can i do that?

Do you got the proper solution for this? If Yes then will you please send it to me, I need it as early as possible.
Thanking to you.

Regards,
Dhanashri.

Report message to a moderator

Re: converting text file into oracle table [message #101279 is a reply to message #100883]

Mon, 19 July 2004 03:14

Suresh Babu
Messages: 3
Registered: April 2003

Junior Member

use sqlloader :

on command prompt :

c:> sqlldr scott/tiger(username/password) control=(control file name) data=(datafile name)

Report message to a moderator

Previous Topic:	tnslsnr hanging
Next Topic:	I1i (11.5.9) Install Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 08:41:13 CST 2024