OraFAQ Forum: Server Utilities » Uploading excel file with 200MB+ size using SQL Loader

Home » RDBMS Server » Server Utilities » Uploading excel file with 200MB+ size using SQL Loader (SQL Loader)

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

Uploading excel file with 200MB+ size using SQL Loader [message #360115]

Wed, 19 November 2008 12:03

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.

Report message to a moderator

Re: Uploading excel file with 200MB+ size using SQL Loader [message #360119 is a reply to message #360115]

Wed, 19 November 2008 12:14

Mahesh Rajendran
Messages: 10707
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

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?

Report message to a moderator

Re: Uploading excel file with 200MB+ size using SQL Loader [message #360345 is a reply to message #360340]

Thu, 20 November 2008 09:42

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Previous Topic:	Export reduced database size.
Next Topic:	Incremental update.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 30 16:54:05 CDT 2024