Re: Running tablespace creation script

Peter wrote:
>
> Normally, I placed my tablespace creation scripts in
> \oracle\admin\<SID>\create
> I am not sure if this the suitable folder to put it.
>
> But anyway, when I ran it, it complained that the script needs to
> include user tablespace, index tablespace, and tools tablespace.
> Instead, it didn't complained about temp tablespace, and undo
> tablespace.
>
> I thought TEMP and UNDO tablespaces are mandatory.
> Which tablespaces are mandatory and which are optional?

You can run with just SYSTEM, but of course, that's not highly recommended. Generally you're up for (at least):

• SYSTEM
• 1 or more tspaces for temporary data
• 1 or more tspaces for undo data
• others depending on what Oracle features you're using

then of course your own...

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"