Hi Georg, Georg Schoepe [mailto:[EMAIL PROTECTED] wrote: > > I have problems when trying to import a table with the loadercli-tool. > I exported a table and tried to import it in another > db-instance, where the table doesn't exist. > > The table-export seemed to be successful. > I used following statements: > > cmdline: loadercli -d gs -u test,test -b temp_books_ex.dat > > the content of the commandfile temp_books_ex.dat: > TABLEEXTRACT > TABLE temp_books > DATA OUTSTREAM FILE > 'c:\programme\sapdb\export\temp_books_ex.data' PAGES > > cmdline: TABLEEXTRACT > TABLE temp_books > DATA OUTSTREAM FILE > 'c:\programme\sapdb\export\temp_books_ex.data' PAGES > successfully executed > > Afterwards I tried to import this table in another > db-instance, where the > table doesn't exist yet. > > the content of the command-file temp_books_ex.dat: > > TABLELOAD > TABLE temp_books > DATA INSTREAM FILE > 'c:\programme\sapdb\export\temp_books_ex.data' PAGES > [snipped cmd line output and log infos: loadercli crashed while trying to import]
> SAPDB-download-version 7.4.03 > > Use full qualified table names for export and import when using TABLEEXTRACT/TABLELOAD like this: TABLEEXTRACT TABLE <user name>.temp_books DATA OUTSTREAM FILE 'c:\programme\sapdb\export\temp_books_ex.data' PAGES and TABLELOAD TABLE <user name>.temp_books DATA INSTREAM FILE 'c:\programme\sapdb\export\temp_books_ex.data' PAGES and it'll work. But be aware that you need to CATALOGEXTRACT/ CATALOGLOAD the table before TABLELOADing it. Otherwise you get an error message like this: ERR -25601 Error restoring table <table name>; table does not exist - table must be created before loading > Question Nr. 2: > In SAPDB-download-version 7.3.0.29 no loadercli seems to be > available. Is it possible to use the loadercli in this version? > You can use repmcli - which is a different name for the same tool. We've renamed it to better reflect it's functionality. But the Loader in general is downwards compatible. So you also can use a 74.03 version for processing 73.XX databases. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
