Re: Moving TABLES to another TABLESPACE
From: Paul MJ Stone <100255.305_at_CompuServe.COM>
Date: 21 Jan 1995 00:37:25 GMT
Message-ID: <3fpl05$8af$1_at_mhadf.production.compuserve.com>
Date: 21 Jan 1995 00:37:25 GMT
Message-ID: <3fpl05$8af$1_at_mhadf.production.compuserve.com>
Basically you have to export the tables, drop them, take the tablespace offline, redefine the users default tablespace to be the target and then import the tables.
Alternatively export the tables, use IMPORT user/pwd INDEXFILE=filename.SQL to generate a set of CREATE TABLE statements in filename.SQL and then edit the files' TABLESPACE clauses and rebuild the tables before importing the data.
Paul
-- Paul MJ Stone 100255.305_at_compuserve or Paul.Stone_at_aea.orgn.uk for real work.Received on Sat Jan 21 1995 - 01:37:25 CET