Re: Attach & detach tablespace
Date: Fri, 27 Jun 2008 11:42:37 -0700 (PDT)
On Jun 27, 1:14 pm, sjosh..._at_yahoo.com wrote:
> In SQLServer I detach from one server and then attach it to another
> server. Is something like this possible with Oracle ?
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 Received on Fri Jun 27 2008 - 13:42:37 CDT