wrong tablespace

From: Sunil Jayasinghe <sunil.jayasinghe_at_probanka.si>
Date: 1997/07/30
Message-ID: <5rmqt0$102@news.eunet.si>#1/1

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 that.

Thanx
sunil.jayasinghe_at_probanka.si Received on Wed Jul 30 1997 - 00:00:00 CDT