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

Report message to a moderator

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: 10707
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

Report message to a moderator

Previous Topic: Database Userid Getting locked
Next Topic: Can I resize data files on database online ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:23:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.