Windows 2003/oracle 10G standard edition

1. Do you recomend using seperate tablespaces for each (prominent) user - 1 for objects and 1 for indexes. What are the main benefits.

2. What is 'set of tablespaces is self-contained'.
execute dbms_tts.transport_set_check('ts1,ts2', TRUE)
Can't I do it just with one (ts1, ts2 ?) tablespace xx as explained below.

3. I need to restore ( transportable tablespace) old image of xx tablespace (contains both objects and indexes) on same server and same db.

So if I do

Make tablespace xx readonly. Save dbf file for this tablespace.

EXP TRANSPORT_TABLESPACE=y TABLESPACES=xx CONSISTENT=y FILE=expdat.dmp

Make tablespace readwrite -- not sure??

restore the saved dbf file (above)

drop the tablespace xx users and xx tablespace itself
recreate the users.

IMP TRANSPORT_TABLESPACE=y DATAFILES='/db/xx.dbf' TABLESPACES=xx
FILE=expdat.dmp

(I can ignore TTS_OWNERS, FROMUSER and TOUSER)

Make tablespace xx readwrite (after IMP)

DO I have to tackle self contained ts issue:
execute dbms_tts.transport_set_check('xx', TRUE) - I get error ORA-25153: Temporary Tablespace is Empty
and table transport_set_violations; does not exist.

Do you think I can get TS restore to old image done this way.

Please advice.

Thanks
-Daljit Singh