Multiple tablepaces

Hi,

I am an Oracle newbie and I am trying to teach myself by doing some exercises. For this one project I am supposed to create three table spaces that contains:

1. Tables, views and procedures.
2. Indexes
3. Sequences

How would I go about to do this and what is actually the primary advantages not putting everything in the same tablespace?

Very grateful for some hints,

/Carl Received on Tue Aug 05 2003 - 12:03:06 CDT