Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYS user
Yes!
Alter User system temporary tablespace TEMP;
Before doing that conect as system/manager
"Sid_James" <sid.james_at_virgin.net> wrote in message
news:397E0851.3BC3_at_virgin.net...
> I accidentally allocated the SYSTEM tablespace as its temporary
> tablespace. Is there anything I can do about the space it has used in
> the SYSTEM tablespace?
>
> Thanks.
>
> Ed.
Received on Wed Jul 26 2000 - 00:00:00 CDT