Rogers thanks for the mail, I am trying to resize the datafile associated to SYSTEM and getting the ORA-03297 error , can , what should I do to resize the datafile, I do not want to see SYSTEM tablespace taking that much space
Thanks, Madhu -----Original Message----- Sent: Thursday, August 15, 2002 3:21 PM To: [EMAIL PROTECTED] Madhu, From all that I understand about the system tablespace, There is no easy way to defragment the system tablespace. An Export, rebuild, Import ( under the direction of Oracle Support according to the metalink notes) is a way to defragment the system tablespace. #What was the initial size of the system tablespace when created? Can you explain the increase in size? Is your performance suffering and the users complaining? Be sure that you do a backup of everything before you attempt to work on defraging the system tablespace. Good luck, Ron ROR m���m >>> "Reddy, Madhusudana" <[EMAIL PROTECTED]> 08/15/02 03:22PM >>> Rogers , If you mean to say Writing is Creating the segments , I did not see any other user except SYS and SYSTEM users in the SYSTEM tablespace. But some user IDs which were created for replication purpose have the Default_tablespace as SYSTEM , but they do not have any segments in SYSTEM tablespace . And there wont be any chance of creating a new object/segment under those users. I believe the SYSTEM tablespace was fragmented and now I would like to resize it , would like to know best and fastest way Thanks Madhu -----Original Message----- Sent: Thursday, August 15, 2002 1:51 PM To: Multiple recipients of list ORACLE-L Madhu some one or something is writing into your system tablespace. I would check to see if anyone has the system tablespace as their default tablespace. SELECT username from dba_users where default_tablespace ='SYSTEM'; or SELECT username from dba_users where temporary_tablespace ='SYSTEM'; Ron ROR m���m >>> [EMAIL PROTECTED] 08/15/02 02:06PM >>> Hello Listers, We have a database for which the SYSTEM tablespace size is nearly 10 gig , Now I have a plan to reduce the size of it . And database is running on 8.1.7.2. What would be the best and faster way to do it. Your ideas will be very much appreciated !! Thank in advance, Madhu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
