Re: Oracle exp imp

From: Pedro Lopes <pedro.lopes_at_netvisao.pt>
Date: Tue, 21 Nov 2006 00:10:59 +0000
Message-ID: <newscache$di029j$tj6$1@newsfront4.netvisao.pt>

Since it's 10g I suggest you to look at expdp and impdp (Datapump). This way you can map tablespaces, different users, and a lot quicker.

pedro

fred wrote:

> hello, 
> could you give the parfiles or paramteres you user for both exp and imp. Do want to (re)create tables in t2 schema aor do they already exist ? 
> "hpuxrac" <johnbhurley_at_sbcglobal.net> hat geschrieben:

>> Piotr wrote:
>>> Hi
>>>
>>> I have problem with importing data to different tablespace
>>> Oracle 10g on red hat 4 es
>>> I've exported data from user t1 with full = y
>>> I have to import data to user t2 - his tablespaces are named differenlty
>>> than t1.
>>> Is it possible?
>> Have you tried fromuser with touser?
>>
>> What error messages are you receiving?
>>
>> Data pump should be able to do this easily.
>>
Received on Mon Nov 20 2006 - 18:10:59 CST