From: cferring@my-deja.com
Subject: moving tables from the system tablespace to a new tablespace
Date: 2000/08/08
Message-ID: <8moa6l$dof$1@nnrp1.deja.com>#1/1
X-Http-Proxy: 1.1 x68.deja.com:80 (Squid/1.1.22) for client 63.194.90.246
Organization: Deja.com - Before you buy.
X-Article-Creation-Date: Tue Aug 08 06:43:33 2000 GMT
X-MyDeja-Info: XMYDJUIDcferring
Newsgroups: comp.databases.oracle.server
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)


Hi everyone,

due to poor design, some of our Production tables are in the System
tablespace.

I want to create a new tablespace or two, and move those Production
tables off the System tablespace.
What are my options?

I think about Exporting the System tablespace, create one or two new
tablespace, import the System one into one of those.
Would that work well (since it's the System Tablespace)?

Otherwise, should I rebuild the whole database (please don't say so)?
Any good advise?

thanks in advance,
C.


Sent via Deja.com http://www.deja.com/
Before you buy.