Re: how to import a unix dmp file within Oracle 9i, windows ?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Sat, 13 Jul 2002 12:15:46 +1000
Message-ID: <ago2fb$j1j$1@lust.ihug.co.nz>

ftp the dump file to the Windows box, making sure its a binary transfer, not an ASCII one.

On the Windows box, use Database Configuration Assistant to create you a new database with nothing much in it -really, you're just after a SYSTEM tablespace. Manually create your tablespaces -the same ones you had on the Unix machine. Keep the tablespace names exactly the same, but stick the datafiles wherever is appropriate on your Windows box.

It's also easier if you pre-create all the Users you had on the Unix database, too. Make sure you give them quotas on the appropriate tablespaces, but don't bother with permissions. Import will do that for you.

Now run import, specifying FULL=Y.

Bingo.

HJR "cel" <papouasied_at_yahoo.com> wrote in message news:3d2f5d67$0$548$626a54ce_at_news.free.fr...
> Let's say I made a full export (tables, tablespaces, stored procedures
etc)
> from a database, running with Unix.
> Now I want to create a database from scratch and import that dmf file in
it.
> I want to do it with Windows, Oracle 9i. Maybe with the Database
> Configuration
> Assistant ????
>
> I am looking for advices or nice links with tutorials.
> thanks in advance
>
>
Received on Fri Jul 12 2002 - 21:15:46 CDT