Why do you think 700 extents is causing you a problem
?
Just about every read to these tables will always be
an indexed one (since the dictionary is rule-based),
so its not going to matter too much how 'fragmented'
things are.
hth
connor
- Ivo.Libal_at_knapp-systems.com wrote: > Hello All
> I found in our database, that some of the sys tables
> have many extents (up
> to 700). These are IDL_* tables and some other
> tables related to our heavy
> use of plsql packages (like sources$, dependency$
> etc). On metalink I found
> that it is possible to change the "next" parameter
> of the table, but I
> would like to ask you if you know about a way how to
> recreate the existing
> fragmented tables?
>
> What option would be possible? (sorted by
> preference)
>
> 1.rebuild the table online without need to do
> anything else
> 2.rebuild the table online with a need to disconnect
> users
> 3.drop all packages/functions ..., truncate the
> tables (idl_ub1$ etc.) and
> load all sources from export (+catalog etc.)
> 4.recreate database + change next extent on the
> tables + load everything
> from export
>
> Or is there other posibility?
> The database is 8.1.7 on Linux
> Kind regards
> Ivo Libal
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: Ivo.Libal_at_knapp-systems.com
>
> 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: ListGuru_at_fatcity.com (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).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music
Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Wed Nov 14 2001 - 11:50:05 CST
