Relocate Extend Online

Malaiyappan

New Member
The extend are already exsit in the database location.
We need to distribute it to multiple drives as it was before.

d "Schema Area":6,32;1 /db/production/production.d1
#
d "Data Area 1":7,64;512 /db/production/production_7.d1 f 1048576
d "Data Area 1":7,64;512 /db/production/production_7.d2
#
d "Data Area 2":8,32;512 /db/production/production_8.d1 f 1048576
d "Data Area 2":8,32;512 /db/production/production_8.d2 f 2785280

to

d "Schema Area":6,32;1 /Progress/db1/prod/production.d1
#
d "Data Area 1":7,64;512 /Progress/db2/prod/production_7.d1 f 1048576
d "Data Area 1":7,64;512 /Progress/db2/prod/production_7.d2
#
d "Data Area 2":8,32;512 /Progress/db3/prod/production_8.d1 f 1048576
d "Data Area 2":8,32;512 /Progress/db3/prod/production_8.d2 f 2785280
 

TomBascom

Curmudgeon
You cannot, however, do this online (as suggested in the thread title). The database must be shutdown.
 
Top