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.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Message-----
Sent: Tuesday, September 10, 2002 10:44 AM
To: Multiple recipients of list ORACLE-L
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)?
Thanks,
Russ
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
