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?