Re: a heated discussion between Development Team & "a" DBA: reorg or not to reog

> That's why recreating the database works, you are essentially
> defragmenting those tables (and probably why your #5 blowups happened,
i don't think export/import defrags the tables; it just combines thes extents next to each other defragmenting the tablespace not the tables.if you have a 2G table, 1500M free and the rest is used, you'll still get 1500M free space in the table after export/import. That's why i did alter table move before the export/import to defrags the tables.

i just want to know what is the advantage of export/drop db/create db/import against export/drop users/create users/import...

> extent size - you still have crap extent info in your system tables
i don't get this..how can i still have crap after i drop the users.. there was no user table after i drop all the users that have any object

> 2. Listen to Sybrand. (Except

i know i'm a big fan of LMTs but it is out of question at this point.

> There are unsupported methods of not having to do the database
> recreation, but if terms like FET$ don't mean anything to you, I
> wouldn't recommend them.

i know fet$, uet$..that is why i will not mess with them..

i.d. Received on Thu Jun 23 2005 - 20:24:09 CDT