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
Kroe1000
Messages: 1
Registered: August 2006
Junior Member
Hello together,

i have an oracle 10.1.0.4 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
Thanks...

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: 10672
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
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#sthref1173
Previous Topic: Database Userid Getting locked
Next Topic: Can I resize data files on database online ?
Goto Forum:
  


Current Time: Sat Dec 03 03:40:18 CST 2016

Total time taken to generate the page: 0.13005 seconds