Re: Reorging a database

"Kirt Thomas" <kremovethisspamthingthomas_at_gfsiinc.com> wrote in message news:di42at0i9c813p3ivmskc7216fbha0fo3k_at_4ax.com...
> I have a db with very few tablespaces (7), and a mininimal number of
> user tables (300) - the db is prettly small (2gb). I inheritied this
> db, it's at v8.0.5.1 on an AIX box. Now the goomba that created this
> created everything with a pctincrease of 50!!! (and maxextents of
> 249, doh). I'd like to fix all this _without_ exporting the entire
> db. So, before I take any rash steps :) I thought I'd ask around
> here to get any opinions on the bestest and easiest way to fix this.
> All things being equal, access to the is db is no more than 8
> concurrent users and a nightly batch process - I don't have any
> performance issues at this time, but I hate the messiness of it all :)
> I am going to upgrade this db to 8.0.6 so that it will work with the
> latest RMAN, but it cannot be upgraded to 8i. Thanks :)

Bang goes my suggestion (followed by a lot of 'move tablespace' commands!).

Why are you so reluctant to do a complete export and import? 2Gb will produce a fairly small dump file, and import won't take forever. Fix up all your storage clauses before the export, truncate everything in site, and import with ignore=y -I honestly think it's probably the easiest way forward.

Particularly if you construct the 'alter table' and truncate statements by a decent query on dba_tables.

Regards
HJR Received on Sat Mar 03 2001 - 14:47:45 CST