Thanks for a clear and illuminating article;
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November 18, 2002 7:08 PM
One thing my article did not cover was of course the
possibility that you end with up with a
Hi John,
If the TS contains just tables, and you have enough space, you could simply
create a new users LMT, and alter table move the tables to the new
tablespace.
You could also export all of the objects from the DMT, and import them in to
the newly created LMT (the old reorg method).
Mark
John,
Why would you *not* want to use the package provided by Oracle?
The answer to your question is to:
1). create a new USERS tablespace
2). issue ALTER TABLE table_name MOVE new_tablespace commands
3). issue ALTER INDEX index_name REBUILD commands.
4). issue ALTER USER username DEFAULT
roughly speaking
create new tablespace X
for each table
alter table move tablespace X
for each index
alter index rebuild tablespace X
hth
connor
--- John Dunn [EMAIL PROTECTED] wrote: If I
want to move my USERS tablespace to locally
managed(without using
dbms_admin.migrate_to_local),
Tom,
There are actually reasons not to use the package Oracle supplies to go
from DMT to LMT. For the full details, see Connor McDonald's paper on
http://www.oaktable.net/ .
-Mark
On Mon, 2002-11-18 at 08:08, Mercadante, Thomas F wrote:
John,
Why would you *not* want to use the package
Mark,
Thanks for the reference. But it seems to quibble with detail that may not
affect very many people. My conclusion after reading of what was found is
to go ahead and use the package. If you experience the error reported, then
the site gives an appropriate work-around.
It dopes not,
One thing my article did not cover was of course the
possibility that you end with up with a miniscule
extent size multiple in the bitmap because you have
to existing extent sizes that are close to being
relatively prime.
Will this hurt...dunno really. I haven't played with
deliberately