You
can drop/re-create users and tablespaces, and import users. Down time also
depend on i/o bus and disk system.
inka
-----Original Message-----
From: Brooks, Russ [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 11:44 AM
To: Multiple recipients of list ORACLE-L
Subject: Reorganizing a database
From: Brooks, Russ [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 11: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)?Thanks,Russ
