Problem with database area

J

Jupiter

Member
How can I move a table , mistakenly created in the Index Area to the Data Area, without dropping the table and dump and load activity?

Thanx in advance.
 
What version of Progress, what OS and and how big is the table?

Casper.
 
Both 9.1D & 10.0B,

OS: Windows 2000 Server & Windows 2003 server. Actually we have different deployments where Schema changes are done through incremental df loading.

Tables are newly created transaction tables. Less than 100000 records.
 
You could do a tablemove. Bi files grows approx 3 times the table size.

Code: 
proutil dbname -C tablemove [owner-name] table table-area

Casper.
 
If you intend to this online remember that all activity can be affected. It will work, but can be a nuisance.

tablemove uses an EXCLUSIVE lock while moving, and if an application uses a NO-LOCK it could still read records - and give bad results.

I generally use a selective binary D&L instead.
 
You must log in or register to reply here.
Back
Top