Re: I have problem with import

From: Karsten Farrell <kfarrell_at_medimpact.com>
Date: Mon, 28 Oct 2002 16:56:37 GMT
Message-ID: <9%dv9.1237$sm1.104916079@newssvr13.news.prodigy.com>

Daniel Morgan wrote:
> Witek Szewczyk wrote:
>
>

>>I am a new ORACLE user. I have done export database to dmp file and I would
>>like to recover (import) this dmp file to a new default database which I
>>have installed in another computer. Please advice what should I do next?
>>
>>Thanks in advance........

>
>
> Go to http://tahiti.oracle.com and search on IMPORT.
>
> Daniel Morgan
>

Before you do that, however, you have to do a couple of preliminary steps:

1. Obviously you have to get the dump file to the new computer:
2. Use ftp in binary mode
3. Use other copy method (hopefully not sneaker-net)
4. Create the tablespaces in the new database (import does not create them for you).
5. Now follow the above step (assuming it was a full export done from SYSTEM account).

Received on Mon Oct 28 2002 - 10:56:37 CST