Re: move USERS tablespace to locally managed

2002-11-19 Thread Yechiel Adar
. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, November 18, 2002 7:03 AM To: Multiple recipients of list ORACLE-L If I want to move my USERS tablespace to locally managed(without using

move USERS tablespace to locally managed

2002-11-18 Thread John Dunn
If I want to move my USERS tablespace to locally managed(without using dbms_admin.migrate_to_local), what are the steps I need to take? John John Dunn Sefas Innovation Ltd 0117 9154267 www.sefas.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET

RE: move USERS tablespace to locally managed

2002-11-18 Thread Mark Leith
-Original Message- Sent: 18 November 2002 12:03 To: Multiple recipients of list ORACLE-L If I want to move my USERS tablespace to locally managed(without using dbms_admin.migrate_to_local), what are the steps I need to take? John John Dunn Sefas Innovation Ltd 0117 9154267 www.sefas.com

RE: move USERS tablespace to locally managed

2002-11-18 Thread Mercadante, Thomas F
TABLESPACE new_tablespace; 5). drop the old tablespace. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, November 18, 2002 7:03 AM To: Multiple recipients of list ORACLE-L If I want to move my USERS tablespace to locally managed(without using

Re: move USERS tablespace to locally managed

2002-11-18 Thread Connor McDonald
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

RE: move USERS tablespace to locally managed

2002-11-18 Thread Mark J. Bobak
tablespace. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, November 18, 2002 7:03 AM To: Multiple recipients of list ORACLE-L If I want to move my USERS tablespace to locally managed(without using dbms_admin.migrate_to_local), what

RE: move USERS tablespace to locally managed

2002-11-18 Thread Mercadante, Thomas F
-Original Message- Sent: Monday, November 18, 2002 7:03 AM To: Multiple recipients of list ORACLE-L If I want to move my USERS tablespace to locally managed(without using dbms_admin.migrate_to_local), what are the steps I need to take? John John Dunn Sefas Innovation Ltd 0117

RE: move USERS tablespace to locally managed

2002-11-18 Thread Connor McDonald
TABLESPACE new_tablespace; 5). drop the old tablespace. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, November 18, 2002 7:03 AM To: Multiple recipients of list ORACLE-L If I want to move my USERS tablespace