RE: RE: Permanent Tablespace for sorting.

2001-08-29 Thread Amar Kumar Padhi
Title: RE: RE: Permanent Tablespace for sorting. Thanks Cris and Conner, I was concerned about the performance implications between the two, even if minor. rgds amar -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 10:33 PM To

RE: RE: Permanent Tablespace for sorting.

2001-08-29 Thread Amar Kumar Padhi
Title: RE: RE: Permanent Tablespace for sorting. How do we check on the ST enqueue contention? rgds amar -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 10:33 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Permanent

RE: RE: Permanent Tablespace for sorting.

2001-08-28 Thread Amar Kumar Padhi
Thanks Christopher. Useful information. -Original Message- Sent: Tuesday, August 28, 2001 7:26 PM To: Multiple recipients of list ORACLE-L When it is perm, you need to recovery it like a normal tablespace if moving it or recovering, unless you offline it or rebuild the control file, wit

RE: RE: Permanent Tablespace for sorting.

2001-08-28 Thread Christopher Spence
When it is perm, you need to recovery it like a normal tablespace if moving it or recovering, unless you offline it or rebuild the control file, with a temporary tablespace it is just not "part of the database". It is a bit simplier, although you can get around it. Although both work perfectly f