I am having issues with user clean on my Teradata systems due to drop user failing for any of the following reasons.
Does anyone else have is problem or have a solution to this issue?
Before dropping the user, all objects in the user Db have to be cleaned up, you may use following syntax(TD 14.10):
DELETE USER user_name ALL;
DROP USER user_name;
There may be dead locks, as there might be other operations going at the time on the dictionary tables, which are holding locks on the DBC tables, leading to contention,You may submit the queries during off business hours or when batch users are not active.