Hi Danny,

Danny Tramnitzke [mailto:[EMAIL PROTECTED]] wrote:
> 
> --->FASTLOAD sets the table processed to state 'Read only'. That
>       can be reset by backing up the db.
> 
> So, when I fill a Table with FASTLOAD, the table is following 
> 'Read only' ??
> 
Yep.

> What, if I drop the Table, create it again and execute the 
> commandfile again ?
> 
You can drop the table, create it and execute the command file
again. After that the table is 'Read only' if FASTLOADed.

> Then I get the message "SQL error -5001 = Missing privilege" 
> (repmcli) , but I guess it's the same error...
> 
Nope, that's different. Missing privilege rather points to the
fact that you're not allowed to create the table as the user
you logged on. Depends on the statement executed.

> Is it possible to use a command and inputfile without setting 
> the table to 'read only' and without backup the database ?
> 
Yes, use DATALOAD instead. Same syntax but different processing
of the data internally.

Regards,
 Steffen
-- 
Steffen Schildberg
SAP DB Team
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to