It will be greatly appreciated if any one can come with a better way to do the following.(sorry about the lengthy thing..y but i think it is necessary to know abt it).
we have Oracle 8i and 9i installed . as we all know bulk loader doesn't work with 9i.here in this case it must be using only 8i. now my problem was that bulk loader was not working even with 8i. I tried to use OCI it worked. I tried the following and came with a conclusion and solution.
I tried to load the bulk loader with OCI
RESULT: The bulk loader worked .
conclusion: 1.The OCI stage was providing the bulk loader something which with out the OCI stage the bulk loader was not able to get.
conclusion 2. there was no problem with the plug in and no problem with Database. My only option left was to check the dsenv .I changed the dsenv to only point to 8i instead of a case statement.again it wasn't working.Then I changed the libpath and now bulk loader was working.Ok now i am still in a dilema so as to why the with the previous dsenv every thing except bulk loader was working and when i changed the libpath every thing including bulkloader was working,Oh its working but my mind has stopped working. Now did any one come accross similar situation and how did you handled it. I would greatly appreciate your sugessions for the best practices to be used here.
There is someone in this world for you worth loosing everything for
we have Oracle 8i and 9i installed . as we all know bulk loader doesn't work with 9i.here in this case it must be using only 8i. now my problem was that bulk loader was not working even with 8i. I tried to use OCI it worked. I tried the following and came with a conclusion and solution.
I tried to load the bulk loader with OCI
RESULT: The bulk loader worked .
conclusion: 1.The OCI stage was providing the bulk loader something which with out the OCI stage the bulk loader was not able to get.
conclusion 2. there was no problem with the plug in and no problem with Database. My only option left was to check the dsenv .I changed the dsenv to only point to 8i instead of a case statement.again it wasn't working.Then I changed the libpath and now bulk loader was working.Ok now i am still in a dilema so as to why the with the previous dsenv every thing except bulk loader was working and when i changed the libpath every thing including bulkloader was working,Oh its working but my mind has stopped working. Now did any one come accross similar situation and how did you handled it. I would greatly appreciate your sugessions for the best practices to be used here.
There is someone in this world for you worth loosing everything for