Re: Moving rootdbs and database catalog.

Art S. Kagel wrote: 17 Aug 99, 10:24: > > The only way is to shutdown the engine, dd the original chunk to the new > chunk (the offset if any MUST be the same BTW) and then drop the link to > the old chunk's disk (you DID use soft links didn't you?) and relink the > original link name to the new drive/device. Now you can bring the engine > back online and it will never know the difference. If you did not use > links you will have to rename the original device file and replace it with > a link to the new device file and you will probably have to do so every > time you reboot as many UNIX's create device files at boot time so the > links will be replaced with the original device name after reboot, but > check out how your system does it. > Thanks Art. When i create de database i use: "create database database_name in dbspace_name with log" and i don't know whow change the sys* tables witout recreating the data base (the dbspace_name isn't rootdbs :-(( ) Ps Sorry for abuse of your Knowledge --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes de Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------