Home » RDBMS Server » Server Utilities » Uploading excel file with 200MB+ size using SQL Loader (SQL Loader)
Uploading excel file with 200MB+ size using SQL Loader [message #360115] Wed, 19 November 2008 12:03 Go to next message
anup_rtp
Messages: 2
Registered: November 2008
Junior Member
We have requirment to upload some reports (in excel format) in the Oracle database. In some cases the report size is 200MB+.

Will it be possible with SQL Loader to upload this size of file in oracle database?

Your help is appreciated.


Re: Uploading excel file with 200MB+ size using SQL Loader [message #360119 is a reply to message #360115] Wed, 19 November 2008 12:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Thats minuscule.
We regularly load anywhere between 1gb to 5gb files.

Edit:
Reading your post again,
are you loading the "files" or the just the content of the files?

[Updated on: Wed, 19 November 2008 12:15]

Report message to a moderator

Re: Uploading excel file with 200MB+ size using SQL Loader [message #360340 is a reply to message #360119] Thu, 20 November 2008 09:14 Go to previous messageGo to next message
anup_rtp
Messages: 2
Registered: November 2008
Junior Member
Thx for your reply
We are uploading the content of the file.

Approximately how much time will it take to upload a file size upto 200MB in oracle?
Re: Uploading excel file with 200MB+ size using SQL Loader [message #360345 is a reply to message #360340] Thu, 20 November 2008 09:42 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No way to tell.
It is your environment, your database, your server and load on that particular time that would determine that.
If you can afford, use direct load options.
Previous Topic: Export reduced database size.
Next Topic: Incremental update.
Goto Forum:
  


Current Time: Sat Dec 10 15:01:40 CST 2016

Total time taken to generate the page: 0.25590 seconds