Hello, I need help with fastload. I want to remove lock on a table which was fastloaded and fastload fails (record were wrong). If the fastload fails, than the table is locked and you can't work with it. Error is: RDBMS error 2652: Operation not allowed: _db_._table_ is being Loaded.
I know, that one solution is to drop-create the table, but I don't find that nice to use it in the production. Do you have any idea, how to remove this locks?
I have one quick question. Do we need to run the empty fastload script with same user id through a different session or we can use any available userid? An example: User report a fastload failure and lock. Do we need to run the script under his id or our own id (DBA)?