import from 8.05 to 9i, query regarding system tablespace size

From: Richard Stanton <richardpstanton_at_yahoo.com>
Date: 8 Oct 2004 08:37:10 -0700
Message-ID: <87bc8a5f.0410080737.2e351b38@posting.google.com>

Hello all

I have imported data from an 8.05 database into a brand new empty 9i database and have a question about the system tablespace.

In the original database the system tablespace was set at 80mb, and is half-full. All I did was to import one user's tables, about 500mb, and in the 9i database, system has autoextended up to 400mb, and is 99% full. Is this normal?

It may have not been the right thing to do, but in my ignorance I allowed the wizard to create it with default parameters.

Can anyone tell me whether I need to worry?! Should I tear it all down and start again?

thanks in advance

Richard Received on Fri Oct 08 2004 - 10:37:10 CDT