Installation Checklists

When you create an Oracle Database 10g instance, make it a point to create a default permanent tablespace along with it at the database level. Oracle will assign any nonsystem users and objects to this tablespace. Whenever the DBA creates a new user or object, it will use this default permanent tablespace unless the default tablespace is mentioned for the user/object. (Similarly the default temporary tablespace created along with the database will be used as the temporary tablespace for users without an assigned temporary tablespace.) The init.ora parameter compatible>=10.0 should be set to utilize this feature.

This default permanent tablespace as well as default temporary tablespaces can only be locally managed. If the ...

Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.