Home » RDBMS Server » Server Utilities » Loading Big files through SQL Loader
Loading Big files through SQL Loader [message #73019] Thu, 15 January 2004 23:38
Sikha
Messages: 1
Registered: January 2004
Junior Member
 

Hi,

I have to upload huge files(flat files) into a table using sqlloader. The file size is to the tune of 10 GB.

I do not have any sample file now and I will have to directly do it in production environment. Is there anything I should be cautious about? (apart from enough space in the tablespace).

Also, if there are no indexes and primary key in the table being loaded, will Direct path loading still help?

 

Thanks in advance,

Sikha

Report message to a moderator

Previous Topic: Using SQL Loader for Migration
Next Topic: Submitting an Oracle 8i stored procedure from asn MS DOS batch file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 27 22:04:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.