O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required