Re: Moving objects to a different tablespace using imp/exp

From: Peter Lang <peter.lang_at_jk.uni-linz.ac.at>
Date: Fri, 29 Jan 1999 08:26:21 +0100
Message-ID: <36B1629D.33EDF1F8@jk.uni-linz.ac.at>

Hi Steve!

1. Export the data of all objects you want to move to the new tablespace.
2. Drop SCOTT's objects located in the SYSTEM tablespace.
3. Recreate the objects in the new tablespace. If you don't have SQL-scripts for creating the objects you can use imp scott/tiger indexfile=filename.sql. This will create a SQL script which contains the create table statements. Simple modify this script and run it.
4. Import the data in the precreated objects. imp scott/tiger ignore=y

Hope that helps,
Peter

---

Peter Lang
mailto: peter.lang_at_jk.uni-linz.ac.at

---

Steve wrote:

> I am trying to move objects owned by SCOTT out of the SYSTEM tablespace to
> another tablespace (USER) using imp/exp but the objects keep geting created in
> the SYSTEM tablespace.
> I did a imp scott/tiger show=y and all the create table statements have
> "TABLESPACE SYSTEM" at the end.
> How do I move SCOTT's objects (and other non-SYSTEM objects put in there by
> inadvertently) out of the SYSTEM ?
> Thanks for your help
> Steve
Received on Fri Jan 29 1999 - 01:26:21 CST