OraFAQ Forum: Server Utilities » upload data using sql* loader

Home » RDBMS Server » Server Utilities » upload data using sql* loader

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

upload data using sql* loader [message #392508]

Wed, 18 March 2009 04:23

user71408
Messages: 585
Registered: November 2007
Location: NE

Senior Member

Hi ,

I have one mbit.txt file. I want to upload the data which is mbit.txt into BGD_CD table.SO please let me know the way to upload the data.

Thank you

Report message to a moderator

Re: upload data using sql* loader [message #392513 is a reply to message #392508]

Wed, 18 March 2009 04:37

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Please read the forum guidelines.

Quote:

Hi ,

I have one mbit.txt file. I want to upload the data which is mbit.txt into BGD_CD table.SO please let me know the way to upload the data.

Thank you

i not able to see any kind of txt files here. and bgd_cd table also.

Report message to a moderator

Re: upload data using sql* loader [message #392514 is a reply to message #392508]

Wed, 18 March 2009 04:39

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm

Regards
Michel

Report message to a moderator

Re: upload data using sql* loader [message #392531 is a reply to message #392513]

Wed, 18 March 2009 05:27

user71408
Messages: 585
Registered: November 2007
Location: NE

Senior Member

Hi I have the table as follows.

create table
(
cd     varchar2(20),
cyear  number(4,2) ,
asindt date,
refer  varchar2(30),
rc_type varchar2(20)
);

and find the attached .txt file.

I need to put code as per the text file and year as 2010 with to_char function.

please let me know the way to upload this txt file.

Attachment: bgdg.txt
(Size: 0.73KB, Downloaded 1339 times)

Report message to a moderator

Re: upload data using sql* loader [message #392534 is a reply to message #392531]

Wed, 18 March 2009 05:35

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm

Regards
Michel

i can`t able to download your attachment.so go through the link posted by Michel.

Report message to a moderator

Re: upload data using sql* loader [message #392578 is a reply to message #392534]

Wed, 18 March 2009 08:50

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Content of the textfile you have posted :

0270iy8i43kr050028xxukyvoc9nf402hi7if5apt8xe.....

You should DEFINITELY consider a career change. This Oracle thing will NEVER work out for you, since you lack the basic understanding on how computers work.

Report message to a moderator

Re: upload data using sql* loader [message #392621 is a reply to message #392578]

Wed, 18 March 2009 12:09

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Report message to a moderator

Previous Topic:	Sql Loader
Next Topic:	Trnasportable Tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 19:27:48 CST 2024