| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Solved: System Tablespace > 1.5 GB
Proble is slved, I found 12 objects in system tablespace where each =
object
allocates 100M, but these objects were empty, cause someone plays with =
the
default storage parameter of system tablespace (intial=3D100M, =
next=3D100M).
Know I have to export database and recreate it. But this is no problem =
for
me, cause customer will pay for it.
Thanks to everyone who replied.
Regards
Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de
-----Urspr=FCngliche Nachricht-----
Von: Schoen Volker=20
Gesendet: 18. December 2000 16:57
An: 'Christopher Spence'; 'Oracle Lazy DBA list'
Betreff: AW: System Tablespace > 1.5 GB
I found the problem, someone created some objects in system tablespace.
Every object (only 12 ones) allocated 100 M of system tablespace, but =
the
tables were empty, so I dropped these objects and suddenly system =
tablespace
allocates only 50 M. But now a newly question:
Datafile of tablespace system is abeout 1.2 Gb, when I try to shrink
datafile, oracle says "file contains 984 blocks of data beyond =
requested
resize value". Is there a way, other then export and import full =
database,
to reorganize the system tablespace, so that I can shrink it?
TIA
Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de
-----Urspr=FCngliche Nachricht-----
Von: Christopher Spence [mailto:cspence_at_FuelSpot.com]
Gesendet: 18. December 2000 16:49
An: Schoen Volker; 'Oracle Lazy DBA list'
Betreff: RE: System Tablespace > 1.5 GB
OMG hehehe,=20
How much of that is actually used by segments?
"I want to die like my Grampa - in my sleep. Not yelling and screaming =
like
his passengers....."
Christopher R. Spence
OCP Raptor MCSE MCP A+ CNA
Database Administrator
Fuel Spot
73 Princeton Road
North Chelmsford, MA 01863
(978)-322-5744
-----Original Message-----
From: Schoen Volker [mailto:v.schoen_at_inplan.de]=20 Sent: Monday, December 18, 2000 7:37 AM To: 'Oracle Lazy DBA list'; 'Oracle List' Subject: System Tablespace > 1.5 GB
Hi list,
I have a costumer, which has a system tablespaces with 1.2 GB. Default
storage parameter fpr initial and next extent are 102400 KB. My =
question,
how can I minimize and reorganize system tablespace, Full DB export? Or =
is
there another easier method?
TIA
Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de
 |
 |