I am loading the data from file to temptable using fastload after loading into main table using insert select. After temp table load complete Data got loaded into Main table using Insert select .This is automated process in our application.
one of my Script that running from Temp table to main table, I got below error.
Failure 2652 Operation not allowed: dbname.tablename is being Loaded.
Statement# 1, Info =0
I am unable to Unlock the above using release lock script (empty script)
For this I have run the below script..
fastload << EOD
BEGIN LOADING dbname.tablename;
While running the above script i got below error..
RDBMS error 3706: Syntax error: expected something
between the word 'tablename' and the 'WITH' keyword.
Please suggest me how to unlock my table..
Thanks in advance...
Thanks for you response.. The thing is , i got the error when i load the data from temp table to target using Insert select format.