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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
