SAS to Oracle DB connectivity issue

[Ganeshk]

Hi All,

I assigned library name for SQL DB as shown below:

Libname SQLDB ORACLE user=ABCD pass=1234 Path="SCHEMA_123" insertbuff=50000 dbcommit=50000 schema=1234

If i run any SQL part of code to create table in that library, connectivity is getting diconnected. so abnormal termination happens with limited observation.

so i removed insertbuff=50000 and processed,

Libname SQLDB ORACLE user=ABCD pass=1234 Path="SCHEMA_123" dbcommit=50000 schema=1234

now connectivity is good but computation time is more than a day its taking to create table.

Please suggest to compute efficiently. 

Thanks,

Ganesh K

[Patrick]

May be try a lower value for insertbuff to figure out the optimal value for your site.

From the documentation:

http://support.sas.com/documentation/cdl/en/acreldb/69039/HTML/default/viewer.htm#p06u7eb5ienq5in1wq...

[SASKiwi]

Please post the SQL code you are using to create the Oracle table and tell us how many rows of data you are loading. If your row count is large then you may want to consider bulk loading:

http://support.sas.com/documentation/cdl/en/acreldb/69039/HTML/default/viewer.htm#p0ewb0agff5a1vn1mq...