I've done something similar in the past (move a database to a new machine
and go to uniform extents). I didn't find any quick and easy methodology.
Basically you have to pre-create the tablespaces where you want them and
with the storage parameters that you want.
Then import the database to an
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 AMTo: Multiple recipients of list ORACLE-LSubject:
Reorg
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 c
Russ,
This is OT relative to your question
slightly, but… Be sure to take some good response time measurements (10046
level 8) before the rebuild so that you can make objective before/after comparisons.
If you’re right about your prediction that all this work won’t
provide much of a pe