Re: Attach & detach tablespace

On Jun 27, 11:42 am, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
> On Jun 27, 1:14 pm, sjosh..._at_yahoo.com wrote:
>
> > Hello
>
> > In SQLServer I detach from one server and then attach it to another
> > server. Is something like this possible with Oracle ?
>
> > thanks
> > Sunit
>
> Not really, but Oracle does provide transportable tablespaces, whereby
> you can, through exp/imp and ftp, take one or more tablespaces from
> one database to another.  Of course it isn't the 'point and click'
> operation you're so used to with SQL Server but it IS possible to
> transport tablespaces between databases.  This is precisely why the
> documentation, found at
>
> http://tahiti.oracle.com
>
> is so valuable and extensive.  Start here:
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tspace...
>
> to get a good overview of transportable tablespaces.
>
> David Fitzjarrell

I haven't tried it, but I do notice some links in EM that look like they might be point and click. Transport Tablespace under the Maintenance tab. Looks like it uses the exp/imp way of transporting, if a filename like EXPDAT_GENERATETTS000044.DMP means anything, though I admit I haven't looked at the RMAN way.

http://download.oracle.com/docs/cd/B19306_01/em.102/b31949/database_management.htm#sthref1302

jg

--
@home.com is bogus.
http://photos.signonsandiego.com/gallery1.5/sdfair08-sosd-ent/db_sdfair2008x287