Re: why use exp transport tablespace use

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 8 Jun 2006 20:17:17 -0700
Message-ID: <1149823037.227006.23760@h76g2000cwa.googlegroups.com>

peter wrote:
> Hello DBAs,
>
> if in my database I have one tablespace "XYZdata" only for one user
> "XYZ". Then which is better to exp "transport tablespace" or "owner"
> and why. As One of you advise me to read manual, if there is any manual
> for that then please inform. Because in manual I find how to do this
> things, when to do them and why to do them also. But still I was not
> able to find solution for this problem.
>
> thank you all

Hi Peter,

What have you already read? The two export types you are referencing are for totally different purposes. One is used to copy one users data to be reloaded later (maybe some data will be reloaded, maybe all). The other is for transferring complete physical datafiles between databases.

This is explained indepth the DBA and Concepts guide at tahiti.oracle.com. I found the following link describing transportable tablespaces at tahiti using the search functionality...

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14220/bus_intl.htm#sthref2467

Learn to use tahiti, as it is your friend :)

Regards,

Steve Received on Thu Jun 08 2006 - 22:17:17 CDT