You could...

create a new tablespace, move everything in Users to it ,
drop Users and recreate it , then move everything back.

Chris Wright wrote:
> Hi
>
> I have inhertied a database that has a 40gb users tablespace
>
> I know that there is only 13gb used
>
> The tablespace is the default permanent tablespace
>
> Anybody know how I might go about shrinking it
>
> its a 10.2 oracle database
>
> Thanks in advance
>
> Chris Wright
>
> -----
> Chris Wright
> Managing Consultant
>
> 1Spatial Ltd
> Switchboard: +44 (0) 1223 420 414
> Blackberry: +44 (0) 7808 262 381
>
> Join us for the 1Spatial Conference 2008: '1 Source of Truth'
> 29th April - 1st May, Radisson SAS Hotel, Stansted, UK
> http://www.1spatial.com/conference
>
> 1Spatial Group Limited.
> Registered in England and Wales No. 4785688 VAT,
> Reg. No. 816329821 Registered Office:
> Cavendish House, 6 Cambridge Business Park,
> Cambridge,
> CB4 0WZ, UK
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>


Oracle LazyDBA home page