Sorry, i think i wrote nonsense. I added one data volume with a size of 1 000 000 pages. It's about 9gb on harddisk. Is this a rigth way to solve the '904 space for result tables exhausted' - errror-message? With the performance loss i am not so sure too. Its an external db-server and there is only internet-connection (ssh..). There seems to be general problems with our provider these days. At least the 904-error didn't occured since my chanches.
Regards Steffen
Schroeder, Alexander wrote:
Hello all,
at first, 1000 data volumes are many, and probably too many. A data volume is more
something like a hard disk drive (and it is really one, if you use a raw device instead of a file) - so how large did you dimension your data volumes?
Anyway, as the data is distributed among the volumes, there is no way of removing a data volume easily. I suggest making a complete data backup, and creating a new database instance for recovery (then, with proper size and count of volumes).
!!! Deleting the parameter file and plugging only some volumes on again can under no
circumstance be recommended, as this is the direct way to data loss. If it had worked
for someone this was pure luck, as then there was no data on the volume.
!!!
Regards
Alexander Schr�der
SAP DB, SAP Labs Berlin
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
