Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SYS and SYSTEM users

SYS and SYSTEM users

From: <raman.yagna_at_db.com>
Date: Wed, 4 Oct 2000 10:47:23 +0800
Message-Id: <10638.118422@fatcity.com>


Hi all,

What is the impact in doing the following.

alter user system default tablespace DATA_00
                temporary tablespace TEMP_00;
alter user system quota unlimited on DATA_00;
alter user sys temporary tablespace TEMP_00;

These commands are in our database creation scripts. Don't know for what they did this. Like to know the ups and downs. Can gurus comment about this.

Thanks and regards, Received on Tue Oct 03 2000 - 21:47:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US