wrong tablespace

From: Sunil Jayasinghe <sunil.jayasinghe_at_probanka.si>
Date: 1997/07/31
Message-ID: <5rpot8$7n@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 it. Thanx
sunil.jayasinghe_at_probanka.si Received on Thu Jul 31 1997 - 00:00:00 CDT