Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: why does DBCA (DB Create Assist) reassign default tablesepace
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_at_le|
| | ndware.com |
| | |
| | 05/10/2002 03:48|
| | PM |
| | Please respond |
| | to ORACLE-L |
| | |
|--------+--------------------------> >----------------------------------------------------| | | | To: ORACLE-L_at_fatcity.com | | 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: Bill.Magaliff_at_lendware.com 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: ListGuru_at_fatcity.com (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: Rachel_Carmichael_at_Sonymusic.com 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: ListGuru_at_fatcity.com (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).Received on Fri May 10 2002 - 16:01:00 CDT
![]() |
![]() |