Home » RDBMS Server » Server Utilities » upload data using sql* loader
upload data using sql* loader [message #392508] Wed, 18 March 2009 04:23 Go to next message
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
Re: upload data using sql* loader [message #392513 is a reply to message #392508] Wed, 18 March 2009 04:37 Go to previous messageGo to next message
ramoradba
Messages: 2454
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.
Re: upload data using sql* loader [message #392514 is a reply to message #392508] Wed, 18 March 2009 04:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm

Regards
Michel
Re: upload data using sql* loader [message #392531 is a reply to message #392513] Wed, 18 March 2009 05:27 Go to previous messageGo to next message
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 181 times)
Re: upload data using sql* loader [message #392534 is a reply to message #392531] Wed, 18 March 2009 05:35 Go to previous messageGo to next message
ramoradba
Messages: 2454
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.
Re: upload data using sql* loader [message #392578 is a reply to message #392534] Wed, 18 March 2009 08:50 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Content of the textfile you have posted :

0270iy8i43kr050028xxukyvoc9nf402hi7if5apt8xe.....


./fa/917/0/

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.
Re: upload data using sql* loader [message #392621 is a reply to message #392578] Wed, 18 March 2009 12:09 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Bored
Previous Topic: Sql Loader
Next Topic: Trnasportable Tablespace
Goto Forum:
  


Current Time: Sat Dec 10 09:02:18 CST 2016

Total time taken to generate the page: 0.09244 seconds