Home » RDBMS Server » Server Administration » Shrink Tablesspacesize (16383 MB)
Shrink Tablesspacesize (16383 MB) [message #189624] Fri, 25 August 2006 05:21 Go to next message
Messages: 1
Registered: August 2006
Junior Member
Hello together,

i have an oracle Database with a TEMP-Tablespacesize about 16383MB. The TBS is emtpy and i can't shrink it (ORA-03297: file contains used data beyond requested RESIZE value)
It is possible, to shrink it? Can somebody help me

best regards Daniel
Re: Shrink Tablesspacesize (16383 MB) [message #189629 is a reply to message #189624] Fri, 25 August 2006 05:39 Go to previous message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
create a new temporary tablespace of your desired size.
Make it default.
Drop the old one.
More details in Oracle documentation at
Previous Topic: Database Userid Getting locked
Next Topic: Can I resize data files on database online ?
Goto Forum:

Current Time: Tue Jul 25 13:53:49 CDT 2017

Total time taken to generate the page: 0.09324 seconds