Another option:
1. Export the users table data.
2. alter user USERNAME default tablespace NEW_TABLESPACE temporary
tablespace TEMP_TABLESPACE;
3. duplicate the schema with temp table names - tablename_temp
4. import the data
5. drop the old tables from the SYSTEM tablespace
6. alter table
If you are on 8i you can move tables and indexes to different tablespaces
(very easy to do it with EZSQL for example) and then change default
tablespacefrom system to new one.
Alex Hillman
-Original Message-
Sent: Wednesday, April 18, 2001 8:55 AM
To: Multiple recipients of list
You can move tables on 8i , but not indexes, you have to rebuild indexes in
order to move them to other TS.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 18, 2001 4:20 PM
If you are on 8i you can move tables and indexes to
Hi All,
I need to move a user/schema away from the system
tablespace to a newly created user tablespace. Could
somebody point me to the references on how to do the
job? Since a production server is running off the
schema, is it possible to do the move without having
to shut down the server?
1. Export the user's schema ( exp help=y )
2. issue in sqlplus:
drop user_name cascade;
3. then remake the user with the new table space as the default tablespace (
all permissions there - none elsewhere ).
4. imp the user from the export dump with ignore=y
regards -
john f. lewis
Best way is to use export/import utilities. This can be done with server on
line and you will get all table data if done at quite time when table is not
being updated. See Oracle Backup and Recovery Guide for info on exp/imp.
PA
-Original Message-
Sent: Tuesday, April 17, 2001 3:50 PM
