>Thanks for your reply Mark.
>
>I created a new tablespace. Now I will create an application user that uses the new tablespace.
>
>What is the purpose of a temporary tablespace? I noticed that when you create an user your have to tell oracle the 'default' tablespace and also the 'temporary' tablespace.
>
>Thanks,
>Sergio
Oracle also creates and deletes temp files. So this is the tablespace it uses for those files.
Mark McCasland
Midlothian, TX USA