Hi, your statement produces a lot of temporary pages and the number of temp pages exceeds the number of addressable pages of your data base instance.
Note that each data page (temp and perm) has an unique id and the amount of page id's is limited by the data base size in particular the size of the converter. If you realy want to execute this command you should add a data devspace to your data base. Regards, Torsten SAP DB, SAP Labs Berlin -----Original Message----- From: Henry [mailto:[EMAIL PROTECTED]] Sent: Dienstag, 21. Januar 2003 12:29 To: [EMAIL PROTECTED] Subject: Error 904 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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
