let me explain this....
I had running 1 session of sqlldr while I run indexes into table for 6 fields... now the indexes are completed but the sqlldr running very slow it load one file after each 30 minute...
now when I do any alter to set the indexes off it won't let me do it and though an error of ( ORA-000054 and ORA-000604) even if I run another sqlldr....
any suggestion will be highly appreciate.... bellow is sample of my control files header...
into table name
FIELDS TERMINATED by '!'
OPTIONALLY ENCLOSED by '"'
When I run following query
select * from dba_dml_locks
ps: I update the question as I mixed up two question sorry guys