Oracle 9i, undo and indexes

From: Laurent Rahuel <lrahuel.notgood_at_voila.fr>
Date: Thu, 05 Jan 2006 15:38:12 +0100
Message-ID: <43bd2f3b$0$6673$8fcfb975@news.wanadoo.fr>

Hi,

I'm working with an oracle 9i server and I already created :

A new role
A new tablespace for datas
A new tmp tablespace
A new undo tablespace
A new index tablespace

I managed adding the role to a new user (with my new data tablespace as default and my new tmp tablespace) but is there any way to affect the new undo as default for my new user ???

Is there any way to for my new index tablespace as the default one for my new user ??

Regards,

Laurent. Received on Thu Jan 05 2006 - 08:38:12 CST