Thanks Ben,
It went well. I checked the database and there are no errors and as usual
did a backup.
I also ran some of the applications and the performance is great. I saw
Razzak's cmd file and am going to add that to the administrative
application.
Thanks to all,
Phil Nolette
See ya'll at the "glorious" conference
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 21, 2001 3:09 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Pack in place
>
> Hi Phil,
>
> Here are the basic steps.
>
> 1. Disconnect
> 2. Set Multi off
> 3. connect
> 4. pack
> 5. disconnect
> 6. set multi on
> 7. connect.
>
> I do not recommend pack, do a reload to a sub directory (ie back), then if
> reload is good, copy from back
>
> reload steps.
>
> 1. md back
> 2. Disconnect
> 3. Set Multi off
> 4. connect
> 5. reload back\dbname
> 6. disconnect
> 7. copy back
> 8. set multi on
> 9. connect.
>
>
> Ben Johansen - www.pcforge.com
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 21, 2001 11:47 AM
> To: Rbase-L
> Subject: Pack in place
>
> I know that it is written someplace but I need to do it fast.
> I just deleted 1500 rows of test incident reports from a T_TIR
> table. I checked the database and there are no errors. I did a backup
> and am now ready to optimize the table by doing a pack in place - all.
> When I try it, it says that I must be in a single user mode. I looked at
> settings and it is grayed out. How do you put the database in a single
> user mode and then after I do the pack in place, set it back to
> multi-user.
> Thanks,
> Phil Nolette
winmail.dat
