Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: Re[2]: why does DBCA (DB Create Assist) reassign defa
See, they do listen. Now if we could only get them to move faster than Molasses
going up hill in the middle of an Alaskan winter!!
Dick Goulet
____________________Reply Separator____________________ Author: Rachel_Carmichael_at_Sonymusic.com Date: 5/10/2002 4:22 PM
yeah it's sweet. they finally got around to doing some of the things DBAs have been begging for for years.. like you can now do a TABLESPACE export!!!
|--------+----------------------->
| | |
| | |
| | dgoulet_at_vicr.|
| | com |
| | |
| | 05/10/2002 |
| | 04:17 PM |
| | |
|--------+-----------------------> >----------------------------------------------------| | | | To: Rachel Carmichael_at_Sony_Music, | | ORACLE-L_at_fatcity.com | | cc: | | Subject: Re[2]: why does DBCA (DB Create | | Assist) reassign default tab | >----------------------------------------------------|
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: Rachel_Carmichael_at_Sonymusic.com 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_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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet_at_vicr.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:48:20 CDT
![]() |
![]() |