Hello,
I am wanting to extract one user schema (i.e table
definitions and application data) and load it into a
2nd database with LOADERCLI in 7.4. I am extracting
the catalog and data from the source database and
loading into target database as below. Both are
UNICODE databases.
Source DB:
USE USER appl appl
//
CATALOGEXTRACT USER
OUTSTREAM FILE 'D:\extracts\cataloguser' FORMATTED
//
------
USE USER appl appl
//
TABLEEXTRACT USER
DATA OUTSTREAM FILE 'D:\extracts\tabdatauser'
FORMATTED
//
Target DB:
USE USER appl appl
//
CATALOGLOAD USER
INSTREAM FILE 'D:\extracts\cataloguser' FORMATTED
//
USE USER appl appl
//
TABLELOAD USER
DATA INSTREAM FILE 'D:\extracts\tabdatauser'
FORMATTED
//
Is this the right way to go about it? The catalog load
is OK, but the table load returns an error (see below)
What am I doing wrong here?
Thanks
Chidd
standard out:
User DBA connected to database TARGET on local host.
USE USER appl appl
Successfully executed
TABLELOAD USER
DATA INSTREAM FILE 'D:\extracts\tabdatauser'
FORMATTED
-25801
Internal error [vls28_TLoad.cpp, 2464, -25342];
contact technical support
Successfully executed
loader.prt:
TABLELOAD USER
DATA INSTREAM FILE 'D:\extracts\tabdatauser'
FORMATTED
// *
// M LOAD TRANSFORMATIONPACKAGE
x'01000000F8B3F7F4DC050000361E00009C9778A0BFC18283'
// *
// M Number of tables to transform: 1
// *
// M Number of views to transform: 0
// *
// M Number of synonyms to transform: 0
// *
// M CONFIGURE TRANSFORMATIONPACKAGE
// *
// M EXECUTE PACKAGE TO TRANSFORM DATA
// *
// E -25345: Schemes of source and target table
LOADIE_TEST do not match; default type of LT_KEY2:
target = no default, source = other default.
// E -25342: Error restoring table LOADIE_TEST; table
exists but source table schema and target table schema
are different
// E -25801: Internal error [vls28_TLoad.cpp, 2464,
-25342]; contact technical support
// M UNLOAD TRANSFORMATIONPACKAGE
x'01000000F8B3F7F4DC050000361E00009C9778A0BFC18283'
// *
// M Releasing user connection (USER: 'APPL').
// *
__________________________________________________________________
Gesendet von Yahoo! Mail - http://mail.yahoo.de
Logos und Klingelt�ne f�rs Handy bei http://sms.yahoo.de
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
