Hello, I am trying to copy the data from a database instance to another. The source instance (7.3.0.8) is running on HP/UX 11 and target instance (7.3.0.15) is running on RedHat Linux 7.0.
I tried two ways to extract the data: TABLEEXTRACT TABLE table1 OUTFILE '/home/sapdb/extract/data/table1.exp'; TABLEEXTRACT TABLE table2 OUTFILE '/home/sapdb/extract/data/table2.exp'; .... TABLEEXTRACT TABLE table<n> OUTFILE '/home/sapdb/extract/data/table<n>.exp The data is extracted from the database without any errors when I say: repmcli -u user,passwd -d SHIFT -b /home/sapdb/extract/extract.script If I then try to load the data in Linux side, I get following error: User test connected to database SC_REP on local host. TABLELOAD TABLE table1 INFILE '/home/shiftctrl/table_extract/data/table1.exp' OUTFILE '/home/shiftctrl/table_extract/data/table1_restart.dat'; Error during execution -->-25329 The given data file '/home/shiftctrl/table_extract/data/table1.exp' was not generated using TABLEEXTRACT (manipulated primary data header page). Then I tried to extract the data using: TABLEEXTRACT USER OUTFILE '/home/sapdb/extract/user_data/shift_db.'; The following error is generated when I try to extract data: User sc_user connected to database SHIFT on local host. TABLEEXTRACT USER OUTFILE '/home/sapdb/extract/user_data/shift_db.'; Replication server error (-4 : 'received a garbled packet') However, it extracts some data since I get shift_db.0000 and shift_db.0001. A same error as in previous case is generated if I try to load these at Linux using: TABLELOAD USER INFILE '/home/shiftctrl/table_extract/user_data/shift_db.' OUTFILE '/home/shiftctrl/table_extract/user_data/shift_db_restart.dat'; Could the problem be that the sapdb versions are not exactly the same in these platforms? The HP/UX is running version 7.3.0.8 and Linux running version 7.3.0.15? Or do I need to use different data format when replicating data between different architectures? Many thanks! -- Joni [EMAIL PROTECTED] http://www.shiftcontrol.com _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
