Home » RDBMS Server » Server Utilities » Import million data from excel to Oracle 11g (oracle 11g in windows 7 profesional)
Import million data from excel to Oracle 11g [message #578972] Wed, 06 March 2013 13:18 Go to next message
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
Re: Import million data from excel to Oracle 11g [message #578973 is a reply to message #578972] Wed, 06 March 2013 13:20 Go to previous messageGo to next message
Littlefoot
Messages: 19600
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Not that difficult..
Re: Import million data from excel to Oracle 11g [message #578974 is a reply to message #578972] Wed, 06 March 2013 13:24 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 432
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 Go to previous messageGo to next message
BlackSwan
Messages: 22779
Registered: January 2009
Senior Member
http://www.orafaq.com/wiki/index.php?title=Special%3ASearch&search=excel&go=Go
Re: Import million data from excel to Oracle 11g [message #578976 is a reply to message #578974] Wed, 06 March 2013 13:32 Go to previous messageGo to next message
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
Re: Import million data from excel to Oracle 11g [message #578977 is a reply to message #578976] Wed, 06 March 2013 13:44 Go to previous messageGo to next message
Littlefoot
Messages: 19600
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?
Re: Import million data from excel to Oracle 11g [message #578987 is a reply to message #578977] Wed, 06 March 2013 22:40 Go to previous messageGo to next message
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?
Re: Import million data from excel to Oracle 11g [message #578990 is a reply to message #578987] Wed, 06 March 2013 23:16 Go to previous messageGo to next message
BlackSwan
Messages: 22779
Registered: January 2009
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/
Re: Import million data from excel to Oracle 11g [message #578997 is a reply to message #578990] Thu, 07 March 2013 00:09 Go to previous message
Littlefoot
Messages: 19600
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.
Previous Topic: Doubt in using export and import
Next Topic: EXP-00008: ORACLE error 904 encountered
Goto Forum:
  


Current Time: Mon Sep 15 20:40:16 CDT 2014

Total time taken to generate the page: 0.08593 seconds