Quick'n'Dirty Oracle Installation - What Are the Minimum Tablespaces I Should Create?

Question

question

KillerDBA asked Feb 8, '10

Quick'n'Dirty Oracle Installation - What Are the Minimum Tablespaces I Should Create?

Over at:

Andrew Mobbs said, "A recent Oracle database consists of at least two tablespaces, SYS and SYSAUX. Older versions only required SYS. It's usual to have more tablespaces, as it is bad practice to store user objects in SYS, and it is common to have separate TEMP and UNDO tablespaces."

I'm going to set up an Oracle installation on a smallish PC. However, I'd like the structure to be representative of a "normal" Oracle installation, even if the installation isn't very powerful or even particularly well tuned (I've only got one disk).

What would be the minimum number, purpose and suggested names for tablespaces to get started? Or is is perfectly reasonable just to accept a couple of installation defaults and move on?

oracle administration installation

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-02-08T13:05:54Z

dmann answered Feb 8, '10

On top of the defaults I usually create:

USERS - Place to store User and Application related data

TOOLS - Place to store any utility related data (Statspack, etc)

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Andrew Mobbs commented · Feb 08, 2010 at 06:23 PM

I'd go with this. Don't forget to set any user's default tablespace to USERS. It might be worth practicing creating objects in a user's non-default tablespace to get used to setting the privileges required.

1 ·

KillerDBA commented · Feb 08, 2010 at 06:47 PM

OK. I'll work it as suggested. Thanks to you both.

0 ·

question