From: "Howard J. Rogers" Newsgroups: comp.databases.oracle.server References: Subject: Re: Reorging a database Lines: 32 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Original-NNTP-Posting-Host: 203.134.7.56 Message-ID: <3aa15853@news.iprimus.com.au> X-Original-Trace: 4 Mar 2001 07:47:15 +1100, 203.134.7.56 Date: Sun, 4 Mar 2001 07:47:45 +1100 NNTP-Posting-Host: 203.134.64.67 X-Trace: news0.optus.net.au 983652435 203.134.64.67 (Sun, 04 Mar 2001 07:47:15 EST) NNTP-Posting-Date: Sun, 04 Mar 2001 07:47:15 EST Organization: CWO Customer - reports relating to abuse should be sent to abuse@cwo.net.au "Kirt Thomas" wrote in message news:di42at0i9c813p3ivmskc7216fbha0fo3k@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