Re: How to import an Oracle-DB

From: Frank <fbortel_at_home.nl>
Date: Mon, 10 Nov 2003 22:18:00 +0100
Message-ID: <boour8$s2i$1@news1.tilbu1.nb.home.nl>

Gunter Ulsenheimer wrote:

>>It sounds that you need the option FROMUSER= and TOUSER=. You will
>>find the documentation on tahiti.oracle.com.
>>
>>Harald

>
>
> Thank you for your tip. I'll have a look at it. Probably this could
> solve my problem. Oh, I have another question. Is there any
> possibility of import, if the username/password of the exported DB is
> unknown/forgotten?
>
> Greets
> Gunter

Surely you know the passwords of the new, empty instance you just created?
imp system/manager file=... fromuser=scott touser=scott Scott has to exist, so you should have:
create user scott identified by tiger default tablespace users;

After the import, change scott back to tiger: connect / as sysdba
alter user scott identified by tiger;

Done

-- 
Regards, Frank van Bortel

Received on Mon Nov 10 2003 - 15:18:00 CST