Home » RDBMS Server » Server Utilities » Conventional path in SQLLoader (oracle10g)
Conventional path in SQLLoader [message #399314] Tue, 21 April 2009 10:11 Go to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member
Hello,

When i was reading oracle document for Direct path versus conventional path in sqlloader, i see this...

Conventional path :

When loading data with SQL*Net across heterogeneous platforms. 

Direct path :

You cannot load data using a direct path load over Net8 unless both systems 
belong to the same family of computers, and both are using the same character set. 
Even then, load performance can be significantly impaired by network overhead. 



What is same family of computers... Are they talking about OS? We can load the data from one OS to another OS..
What is same characer set? When we load the data from client machine, are they talking about client machine
character set to server OS character set??


Re: Conventional path in SQLLoader [message #399431 is a reply to message #399314] Wed, 22 April 2009 03:09 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Where you read the above details.

Post the link.

Babu
Re: Conventional path in SQLLoader [message #399518 is a reply to message #399431] Wed, 22 April 2009 13:23 Go to previous messageGo to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member

Babu, please see this link.

http://web.urz.uni-heidelberg.de/UnixCluster/Hinweise/Hilfe/Anwendung/Db/oracle.doc.816/server.816/a76955/ch08.htm

Thanks
Re: Conventional path in SQLLoader [message #399533 is a reply to message #399518] Wed, 22 April 2009 15:44 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
You are aware that you have given a link to the 8i documentation and your question stated you are using 10g, right?

Here is the 10g documentation. No mention of it.

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_modes.htm

[Updated on: Wed, 22 April 2009 15:46]

Report message to a moderator

Re: Conventional path in SQLLoader [message #399681 is a reply to message #399533] Thu, 23 April 2009 08:16 Go to previous messageGo to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member
Thank you!!!. I got it.
Re: Conventional path in SQLLoader [message #399728 is a reply to message #399681] Thu, 23 April 2009 14:40 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Thanks for the feedback..

What you understand from document ??

Babu
Previous Topic: CONSISTENT versus OBJECT_CONSISTENT in EXP
Next Topic: Stopping a impdp job
Goto Forum:
  


Current Time: Fri Apr 19 23:56:54 CDT 2024