RE: What can free space in a TS?

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Fri, 5 Jan 2001 13:54:36 -0600
Message-Id: <10732.125885@fatcity.com>

Sorry, all, but it's not a TEMP space.

I knew I should have mentioned that in the message... <blush>

Rich Jesse                          System/Database Administrator
Rich.Jesse_at_qtiworld.com             Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Rachel Carmichael [mailto:carmichr_at_hotmail.com]
> Sent: Friday, January 05, 2001 13:38
> To: Multiple recipients of list ORACLE-L
> Subject: Re: What can free space in a TS?
>
>
>
> do a select from dba_users:
>
> select username from dba_users
> where temporary_tablespace='<TS in question>';
>
> If someone has that tablespace as their temporary tablespace, it will
> fragment it

This message has been scanned for viruses with Trend Micro's Interscan VirusWall. Received on Fri Jan 05 2001 - 13:54:36 CST