Manuel Daponte wrote:

> Hi everybody,
>
> We have a client with a 500GB IDS 7.3 DB. The client needs to move some
> dbspaces (about 40GB) to a new set of drives. Which options of the
> following do you prefer:
>
> 1- Can I create the new devices and then use "dd" with the DB off-line to
> copy the chunks to the new devices?
>
> 2- Can I create the new devices, perform a full backup, change the links
> of the chunks to the new devices and the restore ONLY the dbspaces that I
> want to move?
>
> 3-Or should I use the traditional method: perform a full backup, change
> the links of the chunks to the new devices and the restore the bull
> backup? (My last option, due to the size of the DB and the time required)

Create the new dbspaces.
Use ALTER FRAGMENT to move the data.
Drop the old dbspaces.
Or do you want to keep the same dbspace names?

--
Ciao,
The Obnoxious One

"Ogni uomo mi guarda come se fossi una testa di cazzo"