fas load/Deadlock issue


fas load/Deadlock issue


We use one of the ETL tool to load data in Warehouse. A simple process is as follow
A---------->flat file-------->C$_A---------Target A
(Oracle) (T.Database) (TD)

Now problem is we use fastload to load table C$ from a flat file. This is for sure that C$_A is access by only one user at a time.

ETL jobs are failing coz of deadlock on table C$ when fastload try to access this table.
I can ensure that none of the other user was accessing the C$ table during loading

Any clue will be highly appreciated.