Home » RDBMS Server » Server Utilities » sqlldr -direct path loading
icon6.gif  sqlldr -direct path loading [message #303961] Mon, 03 March 2008 07:55 Go to next message
venkat_sadineni
Messages: 3
Registered: March 2008
Location: hyderabad
Junior Member
i am using sqlldr directpath loading

sqlldr uname/psq@db control=contro.ctl log=logfile.log direct=true


table constraints wil be left in index unusable state.


how can i achieve bulkloading (direct path)
Re: sqlldr -direct path loading [message #303964 is a reply to message #303961] Mon, 03 March 2008 08:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i am using sqlldr directpath loading

Quote:
how can i achieve bulkloading (direct path)

This is what you did.

Regards
Michel
Re: sqlldr -direct path loading [message #304064 is a reply to message #303964] Mon, 03 March 2008 23:11 Go to previous messageGo to next message
venkat_sadineni
Messages: 3
Registered: March 2008
Location: hyderabad
Junior Member
When i run with direct=true
my indexes are become unusable.

Re: sqlldr -direct path loading [message #304066 is a reply to message #303961] Mon, 03 March 2008 23:19 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>When i run with direct=true my indexes are become unusable.
What you stated is correct.
Congratultions!


Re: sqlldr -direct path loading [message #304123 is a reply to message #304066] Tue, 04 March 2008 03:29 Go to previous messageGo to next message
venkat_sadineni
Messages: 3
Registered: March 2008
Location: hyderabad
Junior Member
i am sorry i have not given clear infomation,
i am new to this fourum,

i want to load my database with direct path loadning,

please guide me the Direct path loading,

i don't want to disable my indexes ,
is there any auto disable constraints (before loading )and enable constraints after loading option are there?

how do i achieve bulkloading with directpath loading,

i want to call sqlldr programatically,

please help me out.

Thanks

Aruna Roy..............
hyd
Re: sqlldr -direct path loading [message #304138 is a reply to message #304123] Tue, 04 March 2008 04:25 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i want to load my database with direct path loadning

You did it.

Quote:
i don't want to disable my indexes

From doc:
Quote:
SQL*Loader leaves indexes in an Index Unusable state when the data segment being loaded becomes more up-to-date than the index segments that index it. The following conditions cause a direct path load to leave an index or a partition of a partitioned index in an Index Unusable state:
* SQL*Loader runs out of space for the index and cannot update the index.
* The data is not in the order specified by the SORTED INDEXES clause.
* There is an instance failure, or the Oracle shadow process fails while building the index.
* There are duplicate keys in a unique index.
*Data savepoints are being used, and the load fails or is terminated by a keyboard interrupt after a data savepoint occurred.


Quote:
is there any auto disable constraints (before loading )and enable constraints after loading option are there?

From doc:
Quote:
During a direct path load, some integrity constraints are automatically disabled. Others are not.
The constraints that remain in force are:
* NOT NULL
* UNIQUE
* PRIMARY KEY (unique-constraints on not-null columns)
The following constraints are automatically disabled by default:
* CHECK constraints
* Referential constraints (FOREIGN KEY)


Quote:
how do i achieve bulkloading with directpath loading,

Once again you did it.

Quote:
i want to call sqlldr programatically,

Use external tables.

Regards
Michel
Previous Topic: Contents of the dump file
Next Topic: User Schema Migration
Goto Forum:
  


Current Time: Sat Dec 10 20:17:10 CST 2016

Total time taken to generate the page: 0.08568 seconds