| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Can't Reduce System Tablespace Datafile Size
Sam
I'm a little confused.. You say that the SYSTEM tablespace has 50 gig used space, yet you are trying to resize it to around a single gig! This kind of makes that error seem pretty reasonable huh? Why not try resizing it to a couple of gig over the 50 that you already have?
Also, is a 50 gig SYSTEM tablespace normal? Sorry if this is naive.. lol.. Here I am sat on my test system, with around a 240M SYSTEM tablespace, thinking it is a little large considering the actual database is around a 1/4 of that!
Regards
Mark
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Sam Bootsma
Sent: Wednesday, January 17, 2001 04:08
To: Multiple recipients of list ORACLE-L
Subject: Can't Reduce System Tablespace Datafile Size
Hello,
On one of my databases, the SYSTEM tablespace has about 2 GB free space, and just over 50 GB used space. I am trying to reduce the size of the datafile using "alter database datafile 'F:\oracle\oradata\TelusDB16bit\SYSTEM01.DBF' resize 1024M", but receive the error message ORA-03297: file contains used data beyond requested RESIZE value. I assume this happens becasue part of the used space is towards the end of the data file.
If this were a non-SYSTEM tablespace, I could reduce the size of the datafile by exporting the data, dropping users, resizing the datafile, then importing the data. However, this won't work for SYSTEM, because SYS objects cannot be exported. Only SYS, SYSTEM, and OUTLN own segments in the SYSTEM tablespace.
Does anybody know how I can reduce the size of the SYSTEM tablespace (short of recreating the database)? Thanks for any suggestions.
The database is Oracle 8.1.6 on Windows NT 4.0.
Sam Bootsma, OCP
Technical Support Analyst
CPAS Systems Inc.
416-422-0563 x237
samb_at_cpas.com
http://www.cpas.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sam Bootsma
INET: SamB_at_cpas.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 18 2001 - 04:13:36 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |