Re: wrong tablespace

From: Alton Ayers <altona_at_ditw.com>
Date: 1997/08/03
Message-ID: <33E533B8.4C69@ditw.com>#1/1

Take a look at http://www.oramag.com/code/cod10116.html

I believe that's what you need.

Sunil Jayasinghe wrote:
>
> How can I move some tables and indexes from system tablespace ( where they
> should't be) to some other (users) tablespace?
> I tried to export the user, then edit the export file and replace all the
> "create table .... tablespace 'SYSTEM' "
> with "tablespace 'USERS' " and then import the user. That works O.K. but
> I would like to find out a better way to deal with it.
> Thanx
> sunil.jayasinghe_at_probanka.si
Received on Sun Aug 03 1997 - 00:00:00 CDT