Thaks for your clarification. I knew that, but I was confused bcoz I was getting error in Oracle 8i while starting up my database.

I feel the difference is HOW I HAVE created those tablespaces. In 8i I created a Temp tablespace with a data file. I did not create a temp file. While in 9i I created with Tempfile clause.

Will you agree with me? Or rectify me.

Thanks