I can see it now create user athene identified by minerva default table tablespace table_data default index tablespace indx_data default cluster tablespace cluster_data default lob tablespace lob_data default mview tablespace mview_data default object tablespace object_data default spatial tablespace spatial_data temporary tablespace temp; I'm sure I've missed something. On 9/28/05, David Sharples <davidsharples@xxxxxxxxx> wrote: > > why would it want to do that? > > On 9/28/05, Lou Fangxin <anysql@xxxxxxxxx> wrote: > > > > Maybe Oracle will add a default index tablespacce to user. > > > > -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com