Re: Increasing size of dbspace

Tsui, Peggy wrote: > > }Question: > } > }I have a dbspace defined on a chunk that is 500MB. > }This chunk actually sits on a raw device that is 2 Gigabytes. > } > }Is there a way to increase the size of this chunk/dbspace without using > }offsets? > } > }What options do I have? Load/unload? What is the best way? > } > }Thanks in advance > } I think that you can either add another chunk to your dbspace, in which case using an offset is inevitable, or dropping the database(s) whose tables populate the dbspace, dropping the dbspace and re-creating it with a size of 2000MB. In this second situation you should dbexport/onunload the relevant database(s) first. Onunload would probably be quicker. What's your problem with offsets, BTW? Neil Truby Chase Manhattan Bank Bournemouth, UK