《move tablespace to another》.pdfVIP

Oracle Support Did this article help solve Would you recommend this your problem? : document to others? : Bookmark Fixed font Go to End Doc ID: Note:147356.1 Subject:How to Move Tables from One Tablespace to Content Type: TEXT/PLAIN Another. Creation Date: 27-MAY-2001 Type: FAQ Last Revision Date:22-APR-2004 Status: PUBLISHED ====== Title: ====== Script to move tables from one tablespace to another =========== Disclaimer: =========== This script is provided for educational purposes only. It is NOT supported by Oracle World Wide Technical Support. The script has been tested and appears to work as intended. However, you should always test any script before relying on it. PROOFREAD THIS SCRIPT PRIOR TO USING IT! Due to differences in the way text editors, email packages and operating systems handle text formatting (spaces, /metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=147356.1 (1 of 8) [2004-9-3 9:22:37] Oracle Support you first receive it. Check over the script to ensure that errors of this type are corrected. ========= Abstract: ========= This is intended for any DBA who wishes to move tables across tablespace. There are 2 methods we can use to do this. One is to use a combination of alter table X move tablespace Y and alter index X rebuild tablespace Y moveall.sql. ========= Script1: ========= cut cut cut set echo off /metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=147356.1 (2 of 8) [2004-9-3 9:22:37] Oracle Support column order_col1 noprint column order_col2 noprint set heading off set verify off set feedback off set echo off spool tmp.sql select decode( segment_type, TABLE,