I am trying to compile a Pro*C program. I am using embedded SQLPlus so
I am forced to set SQLCHECK=SEMANT IC which is OK.
Now, I have 2 databases: one is a development and the other is
production. They should be the same. Tables, indexes etc. are the same
in the two databases.
If I compile against the production the precompile is very fast.
But if I point the Pro*C to the development database the
precompilation becomes extremely slow. It takes several hours - but it
eventually gets through!?!
Does anyone have any idea what I should look for?
Any help appreciated
/Thomas
I am forced to set SQLCHECK=SEMANT IC which is OK.
Now, I have 2 databases: one is a development and the other is
production. They should be the same. Tables, indexes etc. are the same
in the two databases.
If I compile against the production the precompile is very fast.
But if I point the Pro*C to the development database the
precompilation becomes extremely slow. It takes several hours - but it
eventually gets through!?!
Does anyone have any idea what I should look for?
Any help appreciated
/Thomas