Problem with database area

[Jupiter]

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.

 

[Casper]

What version of Progress, what OS and and how big is the table?

Casper.

 

[Jupiter]

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.

 

[Casper]

You could do a tablemove. Bi files grows approx 3 times the table size.

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

Casper.

 

[comatt1]

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.

 

[Jupiter]

Thnax a lot..