Home » RDBMS Server » Enterprise Manager » Resizing system tablespace
Resizing system tablespace [message #67841] Wed, 22 May 2002 11:45 Go to next message
Mark Savery
Messages: 12
Registered: May 2002
Junior Member
Somehow we ended up with a system tablespace sized at
4gb. However we are only using less than 2% of that. I was hoping to resize it, but when looking at the map of the storage space, found a few extends at the end of the data file, precluding resizing of the file. Is there any way I can move the objects associated with these extents so that I can regain the lost space?

Thanks
Re: Resizing system tablespace [message #67843 is a reply to message #67841] Fri, 24 May 2002 01:09 Go to previous messageGo to next message
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member
SIR,

WE CAN'T REDUCE THE FILE SIZE DIRECTLY.DO ONE THING.
EXPORT THE TABLES IN YOUR DATABASE.THEN CREATE A DATABASE OR REINSTALL THE OS,ORACLE.THEN IMPORT THE TABLES IN TO THE NEW DATABASE.

THAT'S ALL

K.SREENIVASAN
Re: Resizing system tablespace [message #67845 is a reply to message #67843] Fri, 24 May 2002 05:39 Go to previous message
Mark Savery
Messages: 12
Registered: May 2002
Junior Member
Thanks for the response. I thought that is what I
would have to do.
Previous Topic: Lock Manager?
Next Topic: couldn't find OracleManagementServer from control panel
Goto Forum:
  


Current Time: Sun May 22 12:24:44 CDT 2022