Re: Changing tablespaces on IMP?

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 01 Mar 2007 08:06:41 -0600
Message-ID: <45e6d167$0$16374$88260bb3@free.teranews.com>

dean wrote:

> On Feb 28, 4:29 pm, Pedro Lopes <pedro.lo..._at_netvisao.pt> wrote:

>> dean wrote:
>>> Is it possible to change the tablespaces of the tables during an
>>> import, from their original ones? Right now when we import a schema
>>> from our clients, to bring the data down to out test servers, we have
>>> to watch the error messages from the tablespace not existing, create
>>> the tablespaces, and then try again.
>>> Oracle 9.2i, 10g v 1 and 2. Windows, Sun, Linux.
>>> Thanks
>>> Dean
>> If you use expdp and impdp (Datapump) on 10g databases you can map the
>> source and destinations tablespaces :) and much faster :)
>>
>> regards,
>> pedro

> 
> What does 'map the tablespaces' mean? Please elaborate, sounds
> interesting.
> 

Have a look at the REMAP_TABLESPACE parameter for impdp:

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_import.htm#sthref342

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com

Received on Thu Mar 01 2007 - 08:06:41 CST