Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help - large system table space
Christophe, I think your right.
I reclaimed all the unused space in all the tables and indexes in the system table space, then resize the datafile, no good. I even truncated all the empty tables in the large segment of the system data file, then resized, still no good. Recreate is next.
As a warning to all (mostly us somewhat lazier types), it's very easy to create large extents by using the OEM tools, better to use command line and think about what you're doing.
Mikel
Christophe Nicolas wrote in message <7321u6$fje$1_at_oceanite.cybercable.fr>...
>Sorry, but the tablespace SYSTEM is the only one that cannot be
>reorganized...
>The only good solution is to recreate the database...
>
>--
>
>Christophe Nicolas, expert Oracle
>www.capway.com/nicolas4/oracle/oracle.htm
>
>
>
>
>
Received on Sun Nov 22 1998 - 20:26:53 CST