Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: wrong tablespace
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
You may try the folowing, though it should work in principle I haven't tried this:
Export the user, revoke privileges for the user on 'system' tablespace, make the 'users' tablespace as the default tablespace of the user. And import.
By the how did you edit the export file. Received on Sun Aug 03 1997 - 00:00:00 CDT
![]() |
![]() |