OraFAQ Forum: Server Utilities » Import million data from excel to Oracle 11g

Home » RDBMS Server » Server Utilities » Import million data from excel to Oracle 11g (oracle 11g in windows 7 profesional)

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

Import million data from excel to Oracle 11g [message #578972]

Wed, 06 March 2013 13:18

mei tambunan
Messages: 37
Registered: February 2013
Location: Medan

Member

Hi,

how to import millions of data from excel to oracle?
please give me explanation

thanks before

Report message to a moderator

Re: Import million data from excel to Oracle 11g [message #578973 is a reply to message #578972]

Wed, 06 March 2013 13:20

Littlefoot
Messages: 21760
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Not that difficult..

Report message to a moderator

Re: Import million data from excel to Oracle 11g [message #578974 is a reply to message #578972]

Wed, 06 March 2013 13:24

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

mei tambunan wrote on Wed, 06 March 2013 14:18

. . . E t c . . .how to import millions of data from excel to oracle?

Millions of data? In Excel?
Highly improbable or even believable.
Follow Littlefoot's provided links.

[Updated on: Wed, 06 March 2013 13:56] by Moderator

Report message to a moderator

Re: Import million data from excel to Oracle 11g [message #578975 is a reply to message #578974]

Wed, 06 March 2013 13:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/wiki/index.php?title=Special%3ASearch&search=excel&go=Go

Report message to a moderator

Re: Import million data from excel to Oracle 11g [message #578976 is a reply to message #578974]

Wed, 06 March 2013 13:32

mei tambunan
Messages: 37
Registered: February 2013
Location: Medan

Member

I mean from the dozens file of excel that we want to import it into oracle

when i am using sql * loader to import data from excel into oracle. it only can be imported is only 50 rows only.
how many rows that sql*loader can import excel to oracle sir?
thanks before

Report message to a moderator

Re: Import million data from excel to Oracle 11g [message #578977 is a reply to message #578976]

Wed, 06 March 2013 13:44

Littlefoot
Messages: 21760
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

50 rows? I'm afraid that you did something wrong. SQL*Loader is capable of loading "millions" (as you put it) rows, not only 50.

Could you post sample data file (CSV?), control file, statement you used to run the loading process as well as log file?

Report message to a moderator

Re: Import million data from excel to Oracle 11g [message #578987 is a reply to message #578977]

Wed, 06 March 2013 22:40

mei tambunan
Messages: 37
Registered: February 2013
Location: Medan

Member

i use sql*loader version 4.1

this in few data in .csv

IssueId,Book_ID,Member_ID,Data_of_Issue,Data_of_Return,Status
Issue_00000001048561,B00000002,IF00000002,2-Jan-01,8-Jan-01,Tersedia
Issue_00000001048562,B00000003,IF00000003,3-Jan-01,9-Jan-01,Tersedia
Issue_00000001048563,B00000004,IF00000004,4-Jan-01,10-Jan-01,Tersedia
Issue_00000001048564,B00000005,IF00000005,5-Jan-01,11-Jan-01,Tersedia
Issue_00000001048565,B00000006,IF00000006,6-Jan-01,12-Jan-01,Tersedia
Issue_00000001048566,B00000007,IF00000007,7-Jan-01,13-Jan-01,Tersedia
Issue_00000001048567,B00000008,IF00000008,8-Jan-01,14-Jan-01,Tersedia
Issue_00000001048568,B00000009,IF00000009,9-Jan-01,15-Jan-01,Tersedia
Issue_00000001048569,B00000010,IF00000010,10-Jan-01,16-Jan-01,Tersedia
Issue_00000001048570,B00000011,IF00000011,11-Jan-01,17-Jan-01,Tersedia

i imported data in .csv but it can not be inserted
when i imported in .xls, it can import but only 50 row sir
have it related to its version sir?

Report message to a moderator

Re: Import million data from excel to Oracle 11g [message #578990 is a reply to message #578987]

Wed, 06 March 2013 23:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

we can not say what you are doing wrong, since you have repeatedly NOT shown us exactly what you do.
we don't know if you do error of commission or error of omission.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Import million data from excel to Oracle 11g [message #578997 is a reply to message #578990]

Thu, 07 March 2013 00:09

Littlefoot
Messages: 21760
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

mei tambunan

i use sql*loader version 4.1

4.1? Are you sure? Do you really use Oracle 4? Did Oracle 4 exist, ever? (Apparently, yes, in 1984. Did it contain SQL*Loader? Can't tell.)

I expected something newer, such as 11.2

M:\>sqlldr

SQL*Loader: Release 11.2.0.2.0 - Production on Čet Ožu 7 07:04:28 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Report message to a moderator

Previous Topic:	Doubt in using export and import
Next Topic:	EXP-00008: ORACLE error 904 encountered

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 29 21:48:08 CDT 2023