Table move

[Mokash]

Hello Everyone,

I want to move the table from one area to another, can anyone please help me to do so? I want the correct steps to be followed when moving table from one area to another.
Also do we need to run mvsch command after table move completes? can i move the table from non "Schema Area" to another non "Schema Area" and after this should i run mvsch command??


progress version:9.1e
Plateform:Windows XP

Thanks in advance.

 

[cj_brandt]

The online progress kb has a lot of info on this.

proutil <dbname> -C tablemove <table data area> <index data area>

The bi will grow 3 - 6 times the size of the table you are moving.
This process is SLOW.
I don't move any tables online which are larger than 1gb in size.

I do use the index move often though.

often mvsch is used after you move a large amount of user data out of the schema area and you want to recover the unused space in the schema area. backup your db before using this command.

 

[Mokash]

Thank you very much for your input...

 

[RealHeavyDude]

Some background:

The schema area of the Progress database is the only area which you can't delete and reduce in it's sice. Therefore, if you move user tables out of the schema area, in order to recover the used disk space, you might want to move the schema to another area which will then become the schema area. Then you can trunate and delete the old schema area.

Regards, RealHeavyDude.

 

[TomBascom]

Table move is much more practical if the table is in a type 2 storage area.