Reorganizing the SYSTEM tablespace & Recreating the Database

Hello:

        I see 3 or 4 fragments in my SYSTEM Tablespace in one DB(7.2.3) on HP9000 and using two datafiles for SYSTEM Tablespace in another DB(7.2.3) on Sun platform. I want to reorganize both the SYSTEM tablespaces(in both the DBs). I know that the only way to reorg the SYSTEM tablespace is by recreating the entire DB.

        I would like to know the exact procedure, gotchas, etc. before I start doing
it. I would appreciate if you can share your experiences.

        Thank you for your knowledge and also for sharing it.

• H A V E A G R E A T T H A N K S G I V I N G ****

--Anand (ananda_at_mcs.com) Received on Wed Nov 27 1996 - 00:00:00 CET