| Oracle Instance Reinstall [message #57526] |
Fri, 20 June 2003 06:26  |
Lorenzo
Messages: 1
Registered: June 2003
|
Junior Member |
|
|
Platform: Windows 2000 Server, Oracle 8.1.6.
Hi, I have two instances in one server. I had the System tablespace in 6GB, that is too big, and because all the objects in the System tablespace belong to System and SYS, the only choice I have to reduce the space of the system datafiles are: recreating the whole instance. I know i have to export all my data, but System. If you have any advice to complete these task the smoothness and fast as possible I would appreciate. Consider I have to maintain the same instance name, and do not affect the other instance installed.
Thank you very much
|
|
|
|
| Re: Oracle Instance Reinstall [message #57527 is a reply to message #57526] |
Fri, 20 June 2003 07:05  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
you can use the following
alter database datafile 'system_datafile_location' resize < new_size_in_Megs >;
But the issue is, u need to identified the latest allocated extent is not beyond this point.
so first find how much space is occupied in the system datafile(tablespace).
say it is around 900 MB.
add a considerable amount of overhead (30-40%) of 900 mb, say 360 Mb .
now you can downsize the file to 900+360 Megs.
note: Above calcs are just a an example...actual size is dependent on the database and its options / configurations.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
