In this blog post, you’ll learn more about the Sybase Error The Temp_Extract_Name1 option is set. The current operation will be rolled back. %1 and the reason for receiving this error
Sybase SQL Error Message
The Temp_Extract_Name1 option is set. The current operation will be rolled back. %1
Reason for this Error
Certain operations will not be allowed whenever the Temp_Extract_Name1 option is set. They are: INSERT…VALUES, LOAD, DELETE, and INSERT…LOCATION if the table being inserted, SYNCHRONIZE join index. (Which also may be executed as part of CREATE JOIN INDEX.) loaded or deleted from is the top table in a join. INSERT…SELECT. For example, ‘insert t1 select * from t2’.