While running an insert statement in sql assistant, I am getting spool space error.
Insert into table a
select * from table b;
But while running only "select * from table b" it gives me result. As per my understanding if "Insert" giving spool space error then "select" should also give the same result.
Can you please explain and provide the solution?
This is usually caused by a bad Primary Index of the target table, e.g. no PI in Create Table, which defaults to 1st column.