Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: wrong tablespace
Editing an Oracle export file is NOT suggested at all !!! However, you could export all the tables(along with the indexes) present in the SYSTEM tablespace. Drop these tables. Alter your users default tablespace to a non-SYSTEM tablespace with required quota on this tablespace. Revoke the resource privilege for that user and then Import the previously exported Oracle dmp file.
Good Luck
Arun Kumar B
email: barunk_at_gto.net.om
Sunil Jayasinghe <sunil.jayasinghe_at_probanka.si> wrote in article
<5rmqt0$102_at_news.eunet.si>...
> 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 Mon Aug 04 1997 - 00:00:00 CDT