Hi, I met a error when I used LOADERCLI. This is the whole process:
dba.transformationmodel is empty. [EMAIL PROTECTED] sapdb]$ loadercli -d prod -u prod,prod Loader Server Protocol File: '/usr/local/sapdb/indep_data/wrk/loader.prt' User PROD connected to database PROD on local host. loadercli>catalogload user instream file 'prodcat' ERR -25392 '[SAP AG][LIBSQLOD SO][SAP DB]Syntax error or access violation;-5001 POS(19) Missing privilege:OWNER.' [EMAIL PROTECTED] wrk]$ tail -7 loader.prt catalogload user instream file 'prodcat' // * CREATE SEQUENCE "TEST"."TEST_PMCATEGORIES_SEQ" MINVALUE 1 NOMAXVALUE START WITH 1062 INCREMENT BY 1 NOCYCLE CACHE 20 ORDER // * // E -25392: '[SAP AG][LIBSQLOD SO][SAP DB]Syntax error or access violation;-5001 POS(19) Missing privilege:OWNER.' // M UNLOAD TRANSFORMATIONPACKAGE x'020000008B27F23F736B0000025AFC1D00017F0000000000' // * dba.transformationmodel is empty. I removed all "TEST". in file prodcat. [EMAIL PROTECTED] sapdb]$ loadercli -d prod -u prod,prod Loader Server Protocol File: '/usr/local/sapdb/indep_data/wrk/loader.prt' User PROD connected to database PROD on local host. loadercli>catalogload user instream file 'prodcat' OK --- So maybe LOADERCLI needn't unload the owner name of the sequences. Regards, Gu Lei
