| Transportable Tablespaces [message #74700] |
Mon, 07 February 2005 00:01  |
Milind Deshpande
Messages: 93
Registered: May 2004
|
Member |
|
|
Hi experts,
I am not clear on the transportable tablespaces option of Export/import utility of Oracle.
Can u give me information on that what is does and how to use this option through the command line.
I have read the docs but it is not clear to me what exactly this option.
Pls. clear my doubts on the same.
if you can provide me with some good link it will be helpful.
Thanks in advance.
Milind.
|
|
|
|
|
|
| Re: Transportable Tablespaces [message #74703 is a reply to message #74700] |
Mon, 07 February 2005 01:22  |
devika
Messages: 21
Registered: November 2004
|
Junior Member |
|
|
First of all make sure you bring the TS to readonly mode.
Then
Step1- make sure that the users associated with the Tablespace you want to transport exist in the destination database as well. Eg. if tomcat is a user in Source Databse who is associated with the tablespace A ,then he must also exist in the destination DB also.
Step 2. Execute dbms_tts.transport_set_check ('<TS name say- A>', TRUE);
This will check if the TS can be transported or not i.e no dependencies should exist.
Step 3. Select * from transport_set_violations;
This statement should not display any rows i.e, your TS is ready to be transported.
Step 4 (os command) $exp file='filename' transport_tablespace=y tablespaces=A
Step 5. copy all the datafiles in that TS to a backup location.
Step 6. Bring the TS back to read-write mode.
Step 7. Through ftp connect to destination machine
Step 8. mput the dump file and the datafiles to the destination path
Step 9. imp file=dumpfile name tablespaces=A transpport_tablespace=y datafiles=<specify your datafiles'
That's it!!!
Happy TRANSPORTING !!!
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
