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.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.