List:MaxDB« Previous MessageNext Message »
From:frank_hischke Date:February 2 2004 4:30pm
Subject:Problems with DBEXTRACT and DBLOAD
View as plain text  
Hi,

I'm a new user of the MaxDB 7.5.0.5 and have a question referring to the SAP DB LOADER.

I want to make a full unload of a large database instance "DEMO" (nearly 5GB) using the
statement:
     LOADERCLI -d DEMO -u dba,dba -b DBExtract.txt -E 20
where DBExtract.txt has the folowing contents:
     DBEXTRACT CATALOG OUTSTREAM 'catalog.out' DATA OUTSTREAM 'data.out' 

The result is one file 'catalog.out' with the catalog information and seven splitted files
'data.out0001' to 'data.out0007' with the application data.

Now i want to load this data into another database instance "DEMO_2" using the
corresponding DBLOAD-Command.
But this command accepts only a single file as DATA INSTREAM.
Also, sequential calls of DBLOAD with all the different 'data.out*"-Files will result in a
"Duplicate Table Name"-Error due to the multiple catalog definitions.


Does anybody have an idea what i'm doing wrong???
Or, which other possibilities exist for unloading and reloading a complete database
instance? 

Thanks in advance,
Frank






Thread
Problems with DBEXTRACT and DBLOADfrank_hischke2 Feb
  • Re: Problems with DBEXTRACT and DBLOADJean-Michel OLTRA2 Feb
    • Re: Problems with DBEXTRACT and DBLOADJean-Michel OLTRA3 Feb
  • Re: Problems with DBEXTRACT and DBLOADJean-Michel OLTRA3 Feb
Re: Problems with DBEXTRACT and DBLOAD'Jean-Michel OLTRA'3 Feb
RE: Problems with DBEXTRACT and DBLOADSteffen Schildberg3 Feb