.
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
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
-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
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
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
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
-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
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