Re: Individual database backup/restore

In article <PdYg7CA+aKgzEwUm@osbit.demon.co.uk>, Kevin Page <kpage@osbit.demon.co.uk> writes >In article <337B5311.6602@netcomuk.co.uk>, Neil Truby ><ntruby@netcomuk.co.uk> writes >>Kevin Page wrote: >>........ >>> I have about 20 or 30 databases and splitting them up into there own >>> dbspaces is just not a practical option. >>> >>Why? >> >>Neil Truby >>Chase Manhattan Bank >>Bournemouth, UK > > >Each database has its own workload which will be running at different >times of the day. For performance reasons I need to split each database >over several disks, this means that each database will have several >chunks allocated to it so any one disk could have upto 30 different >chunks on it ! It make for a bit of an administration nightmare if one >of the tables in a chunk on the centre of the disks grows beyond its >predicted size as I would then have to allocate another chunk for it on >the outside edge of the disk. create one dbspace containing one chunk per disk and use create table (...) in <dbspace name> to spread the tables over disks or even fragment the table across several dbspaces i.e. disks... -- David Williams