| Direct Path Homogeneity Error [message #367999] |
Thu, 16 September 1999 08:56  |
Robert Northrop
Messages: 1
Registered: September 1999
|
Junior Member |
|
|
I am using Oracle Client 8.0 to remotely access and Oracle Server (also version 8.0) and attempting to do anupdate with SQL Loader. When I try to use the direct=true option I get this error message:
Error checking path homogeneity.
ORA-02352: Direct path connection must be homogenius.
The loading works fine without the direct option set to true, but I would like to use the direct option for improved performance. I would appreciate any help.
Thanks.
|
|
|
|
| Re: Direct Path Homogeneity Error [message #368000 is a reply to message #367999] |
Fri, 17 September 1999 11:06  |
Venu
Messages: 44
Registered: September 1999
|
Member |
|
|
Robert,
First, try the following :-
Try adding An additional parameter for the direct path parallel load, PARALLEL=TRUE and Global indexes should be dropped before engaging in the direct path parallel load.
If it still does not work, try the following :-
In the init.ora file, set the following,
mts_servers=0
mts_multiple_listener=FALSE
Basically negate all the parameters that start with MTS (Multi Threaded Server). Shutdown and restart the database then retry SQL*Loader.
Regards.
Venu
|
|
|
|
| Re: Direct Path Homogeneity Error [message #368005 is a reply to message #367999] |
Mon, 27 September 1999 11:01 |
m a sivan
Messages: 34
Registered: July 1999
|
Member |
|
|
Actually this error comes when u are using some different APIs etc. which Oracle server is not able to recognise or for that matter some O/S or hardware etc. which is not compatible for direct LOAD. try to use different ORACLE ODBC drivers etc.. and try to run the same thing from the SERVER if possible ( dont use any client run from soem node on UNIX server itself. ) I feel that u may not get that problem..
Do revert back...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
