Hi Steffen, thank you very much - now it works. I didn't know, that a CATALOGEXTRACT/CATALOGLOAD is needed before executing a tableload. Maybe there should be given a hint in clear text in the documentation (at the time you can read that the source table has to exist in the db-instance, but not how to create it).
And as you mentioned - the dataload fails without using fully qualified table names. Best regards Georg "Schildberg, Steffen" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > 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
