Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Fixing Fragmentation

Fixing Fragmentation

From: <amerar_at_ci.chi.il.us>
Date: Tue, 04 May 1999 15:02:29 GMT
Message-ID: <7gn262$anv$1@nnrp1.dejanews.com>

Hello,

We have all of our production database under one schema. In order to defrag the entire instance (all tables), I figure that I could do a full export, then drop user cascade, then import the user.......does this sound correct?

Please send replies to: amerar_at_ci.chi.il.us

Thanks for your help,

Arthur

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue May 04 1999 - 10:02:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US