Hello,
i want to write a script which i could use for exporting / importing database tables from one db to another.
the script should export selected tables from the source db, delete the data in the selected tables in the destination db, and then import the selected data from the export files.
it could be that there are no records in the destination table, so the delete statement would fail:
aportal@server:~/install/dbscripts> /opt/sdb/programs/bin/loadercli -n localhost -u dbadmin,dbadmin -d ap_testu -b aportal-i.cmd
Loader protocol: '/home/aportal/sdb/server/loader/log/loader.log'
Loader packages: '/home/aportal/sdb/server/loader/packages'
User DBADMIN connected to database AP_TESTU schema DBADMIN on localhost.
use user aportal aportal
Successfully executed
SET MAXERRORCOUNT 3
Successfully executed
delete from aportal.tabelle
Error during execution
-->-25010
SQL error 100 = Row not found (error position: 1)
Defined maximum number of errors (1) reached
1 error(s) while processing command file 'aportal-i.cmd'.
---> See Loader log file for more information.
i thought to increase the maxerrorcount value, but this doesn't work. is there another possibility to delete empty tables?
thx