Hi all,
firts of all i'am a newbie to sapdb, and have the following question.
I want to do the following SQL

create table
TEMP.T
INGNORE ROLLBACK
as
select * from a
union all 
select * from a
union all 
select * from a
union all 
select * from a
union all 
select * from a

And i always  get the error 904 (not enough space for temporary table 
available), but a only contains ~ 30.000 rows. What resources do i have 
to adopt to make such SQL's possible ? 

:) hejo


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to