Re: Problems with moving data out of system tablespace in Oracle

michel.lalonde_at_sit.ulaval.ca writes:
: In article <3o1548$7uh_at_nms.telepost.no> jaahaug_at_telepost.no (Jon Anders Aas-Haug) writes:
: >From: jaahaug_at_telepost.no (Jon Anders Aas-Haug)
: >Subject: Problems with moving data out of system tablespace in Oracle
: >Date: 30 Apr 1995 23:05:44 GMT
 

: >We want to move data from systemtablespace to other tablespaces. We find
: >this difficult to do. Do anyone now the solution to this problem.
:
: If you want to move table SCOTT.T from tablespace SYSTEM to tablespace OTHER:
:
: export the table,
: drop the table,
: alter user scott default tablespace OTHER,
: alter user scott quota ... on OTHER,
: alter user scott quota 0 on SYSTEM,
: import the table.
:
: Michel Lalonde :-)
:

don't forget to
revoke unlimited tablespace from user;

--
regards,
Carl
+-----------------------------------------------------------------------------+
Carl Gohringer, Oracle European Development Centre, World Wide Education 
Oracle Park, Bittams Lane, Chertsey, Surrey, England, KT16 9RG
Internet   : cgohring_at_uk.oracle.com    
+-----------------------------------------------------------------------------+