RE: Reorganizing a database

Russ - Why don't you consider this:

• Create a new tablespaces LMT and uniform sizes (please read the documents to understand this concept clearly).
• Move tables into the new tablespaces using ALTER TABLE MOVE. This is MUCH faster than export/import.
• If you have space issues, just create the tablespaces you have room for, and then drop old tablespaces as you empty them.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>

-----Original  

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com> Message-----
From: Brooks, Russ [mailto:Russ.Brooks_at_dayzim.com] Sent: Tuesday, September 10, 2002 10:44 AM To: Multiple recipients of list ORACLE-L Subject: Reorganizing a database

Hi,
  We are creating a 45GB database from a restore of a current system. My boss has requested that I reorganize the entire new database. I have my doubts that this will provide as much benefit as he seems to expect, but they are adamant that this is what they want. One of the desired effects is to resize all the datafiles to uniform sizes and distribute some I/O. I'm thinking of using a full export as the base of this activity, splitting the export. This will be done on an HP L class with 2 500MHz processors and 3 GB of memory.
  What is the best way of accomplishing this as quickly and painlessly as possible? I've looked through Metalink and various books without finding a good general procedure for changing the location and sizes of the datafiles during the import.
  About how long should this take (ballpark)? Received on Tue Sep 10 2002 - 11:02:24 CDT