DSXchange

Does anyone know what the environment variable APT_ORACLE_NO_OPS does? I read an old post here about an Oracle error I was receiving and after I applied this to my project it worked. I was just wondering if anyone knows what it does.

Thanks,

Sean

From one of the previous posts.

There is an environment variable APT_ORACLE_NO_OPS that can be set to 1 which will tell Ascential not to check for the existence of the table SYS.GV_$INSTANCE. Once this was added to our Job, it ran fine.

So it would seem that it is used to disable any parallel server checks/optimizations for the stage.

I guess I should read better.
Sorry. Thanks for the reply!!

Ultramundane wrote:From one of the previous posts.

There is an environment variable APT_ORACLE_NO_OPS that can be set to 1 which will tell Ascential not to check for the existence of the table SYS.GV_$INSTANCE. Once this was added to our Job, it ran fine.

So it would seem that it is used to disable any parallel server checks/optimizations for the stage.

Thanks for thi Tip, it works correctly!!!
Eduardo.