Re: Attach & detach tablespace
Date: Fri, 27 Jun 2008 17:22:08 -0700 (PDT)
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
> is so valuable and extensive. Start here:
> 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.
-- @home.com is bogus. http://photos.signonsandiego.com/gallery1.5/sdfair08-sosd-ent/db_sdfair2008x287Received on Fri Jun 27 2008 - 19:22:08 CDT