Re: moving tables

Presume that you want to use links as your chunk devices rather than hard-coded device names. Since you cannot move system tables of your database, you will have to drop your database as part of the 'moving' process. Which, of course, means that you must copy your database first. Various alternatives exist 1. Copy your database to a different dbspace under another name (Use dbexport/dbimport or onunload/onload). Verify that the copy occurred successfully (matching row counts, at least). Drop the original database. Drop your dbspace. Link your device. Recreate your dbspace using the link. Copy your database to the newly create dbspace (if you still want to). 2. Export your database. Drop it. Drop the dbspace. Link device. Recreate your dbspace using link. Import your database into the newly created dbspace. Note : Backup your instance in the quiescent mode before starting the process. HTH Rudy In article <7ujqjh$muu$1@nnrp1.deja.com>, bsagonda@my-deja.com wrote: > Hie, i want to move tables which are located on a raw device dbspace to > one which points to the dbspace, then drop the dbspace and recreate it > using a linked path. The problem is that they are system tables located > on that dbspace and they are a lot of tables there. > So is they any other way to do this , without causing me a lot of > headaches. > > thanks in advance. > > -- > Blessing K. Sagonda > Networks > Ok Zimbabwe > > Sent via Deja.com http://www.deja.com/ > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.