OraFAQ Forum: Server Utilities » How can I import data from a file?

Home » RDBMS Server » Server Utilities » How can I import data from a file?

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

How can I import data from a file? [message #71111]

Tue, 10 September 2002 16:16

Peter
Messages: 62
Registered: August 2000

Member

Hello,
I would like to know how I can import data to a table created in SQL PLUS, from a file ready to be exported. I am a beginner using Oracle as well as SQL PLUS. I work with Oracle 8i Personal Edtion installed in Windows 98.
Thanks so much for your help.

Report message to a moderator

Re: How can I import data from a file? [message #71115 is a reply to message #71111]

Wed, 11 September 2002 00:14

sunil bhola
Messages: 58
Registered: July 2002

Member

Yes

sunil==db
sunil==pwd
sunil==services

Type the command at command prompt

imp sunil/sunil@sunil buffer=1000000 file="your filename" ignore=y

Report message to a moderator

Re: How can I import data from a file? [message #71124 is a reply to message #71111]

Wed, 11 September 2002 09:58

Roy
Messages: 30
Registered: May 2002

Member

If the file to be imported is a text file (ascii) then use sql*loader to import the data into the table.
For documentation refer to oracle.com and search for sql*loader.

Report message to a moderator

Previous Topic:	Creating database...very urgent
Next Topic:	Creating database...Urgent

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 04 07:14:24 CDT 2024