Hi,
I want to load sas datasets into a Oracle database using a specific tablespace. Here is what I am trying:
proc dbload dbms=oracle data=sashelp.bweight(keep=weight black);
user=test_user;
orapw=test_pass;
path=test_db;
table='PROC_DBLOAD_TEST';
tablespace=test_tablespace;
load;
run;
My first problem is the following:
NOTE: Load ended due to limits. Examine statistics below.
NOTE: Limits - Insert (5000), Error (100), Commit (1000)
NOTE: Inserted (5000) rows into table (mk_prod_dbload_test)
NOTE: Rejected (0) insert attempts see the log for details.
I cannot find information on how to set these limits, I also do not understand why there are error's being reported.
Are there alternatives to using the dbload procedure where I can still define a tablespace?
Thanks,
Matt