Hi,

I'm facing the transportable tablespace problem and i don't know whether the following coding is right or not. Pls help

1) alter tablespace testing read only;

2) exp transport_tablespace=y tablespaces=testing file=export.dmp

3) Copy Files to New Location and Import Data Dictionary

4) imp TRANSPORT_TABLESPACE=y
DATAFILES='/oradata/aaa/testing.ora' TABLESPACES=testing
FILE=export.dmp

My question here:
1) whether the datafile here (step 4) refers to source or target database.
2) when i create the tablespace, the extension i get is "testing.ora" but not "testing.dbf". Is
that anything wrong or i just uses it ?
3) the step 3 mention copy files to new location.
(is that correct if i just copy file to the
target database with the
path "c:\oracle\oradata\aaa\testing.ora" and
copy "export.dmp" to the same path.
4) do i need to write down the ownership for
example FROMUSER, TOUSER?