New feature in 9i, default temporary tablespaces. Now you don't have to state what a users temporary tablespace is and have them end up in system. It covers sys and system at the same time since it's declared in the create database command.
Dick Goulet ____________________Reply Separator____________________ Author: [EMAIL PROTECTED] Date: 5/10/2002 1:00 PM That's CORRECT... no one other than SYS should have the SYSTEM tablespace as the default tablespace. No one should have SYSTEM as the temporary tablespace. for years oracle would say "change the default tablespace". Now they do it for you (and about bloodly time!) |--------+--------------------------> | | | | | | | | Bill.Magaliff@le| | | ndware.com | | | | | | 05/10/2002 03:48| | | PM | | | Please respond | | | to ORACLE-L | | | | |--------+--------------------------> >----------------------------------------------------| | | | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: why does DBCA (DB Create Assist)| | reassign default tablesepace for | >----------------------------------------------------| Anyone know why, when using DBCA, it configures user SYSTEM to have a default tablespace of TOOLS and not SYSTEM? This is a separate script it runs at the end, after the db and data dictionary are both created. thought system should have system tablespace as default, no? thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
