10G Transportable Tablespace
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