I would like to copy an entire user to another instance and tried it this way:
@source database:
loadercli -n source_db -u dba,dba -d the_user
dbextract catalog outstream file 'C:\temp\20081011.catalog' records data outstream file 'C:\temp\20081011.data' records
and then:
loadercli -n destination -u dba,dba -d the_user
dbload catalog instream file 'C:\temp\20081011.catalog' records
dbload data instream file 'C:\temp\20081011.data' records
The import of the catalog went ok, but on importing the data I was given:
ERR -25364
Names of table to import (ORDERS) and currently processing table in data file (AKTENZEICHEN) do not match
FYI: source database is 7.5
destination database is 7.6
loadercli binary is 7.6
What's the problem? I can't guess the meaning of this message. Seems like loadercli expected a different order of the tables, but the file was produced by loadercli itself a few minutes before, so I don't think I could do anything about it.
Could you please give me a hint what may be wrong?
TIA,
Alex
BTW:
This is the written loader log file:
-
START Log File -
// M Starting protocol at 2008011100130941
// *
// M START 20080111 00130941
// *
SET
// *
// M START 20080111 00130941
// *
USE USER "DBA" * SCHEMA DBA SERVERDB "APORTAL" ON uny-int-sap
// *
// M USER: 'DBA' on DB: 'APORTAL' ISOLATION LEVEL: 3
// *
// M START 20080111 00130946
// *
drop user aportal
// *
// M START 20080111 00130949
// *
dbload catalog instream file 'C:\temp\aportal\aportal_aportal_ipms_20080110.catalog' records
// *
// M Execute PACKAGE to transform CATALOG
/ *
// M Import PACKAGE x'010000008DED97FDCC0E0000A47E0000AE47319E49FCD3F2'
// *
// M Number of TABLES transformed : 56
// *
// M Export PACKAGE x'010000008DED97FDCC0E0000A47E0000AE47319E49FCD3F2'
// *
// M START 20080111 00130955
// *
dbload data instream file 'C:\temp\aportal\aportal_aportal_ipms_20080110.data' records
// *
// M Import PACKAGE x'0200000093ED97FDCC0E0000A47E0000AE47319E49FCD3F2'
// *
// M Execute PACKAGE to transform DATA
// *
// M Number of TABLES to transform: 56
// *
// E -25364: Names of table to import (ORDERS) and currently processing table in data file (AKTENZEICHEN) do not match
-
END Log File -