RE: Quickest way to export and import data

Hi David,

[email protected] [mailto:[email protected]] wrote:
> Subject: RE: Quickest way to export and import data
> 
> At this point we just want the quickest way to do it, and 
> don't mind it being unreadable.
> 
> So, I switched to the DBExtract and DBLoad - this works fine, 
> until I try
> and use the database and I discovered that it is now readonly 
> until I do a
> backup!  Doesn't this defeat the purpose?!  I believe this is 
> true for the fastload, too.
> 
No, it doesnt defeat the purpose at all. What if the newly imported db
crashes and the exported does not longer exist. Yes it's a kind
of artificial case but who knows.

BUT there exist a way out: if you don't mind loosing your data
you could do a DBLOAD and then running a 'SET NOLOG OFF' command
in a utility session.
Using dbmcli that would be:
dbmcli -u <dbm user name>,<pw> -d <db name>
util_connect
util_execute set nolog off
util_release

That switches the 'read only' flag for all tables off. The same
applies for FASTLOAD, too. But again
in case of a crash you can't restore that db to it's initial state
if not doing a backup.
Regards,
 Steffen
-- 
Steffen Schildberg
SAP DB Team
SAP Labs Berlin