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).