Oracle 10g database exp and imp question

[Quoted] Hi, I am reading document B10825-01.pdf Oracle Database Utilities, chapter [Quoted] 20 "Original Export and Import". I am an aspiring DBA but not a DBA.

My understanding from B10825-01.pdf is that to export all the tables, stored [Quoted] procedures etc for SCOTT, I would use this:

exp system/password_at_db10gtest rows=y owner=scott

I have tried this it creates a file EXPDAT.DMP

I then do this:

SQLPLUS system/password_at_db10gtest
DROP USER SCOTT CASCADE; and SCOTT is deleted.

To test the import, I now want to put SCOTT and all his data, stored procedures etc back as they were before I deleted them. I am attempting to [Quoted] do this with "imp".

I have typed this

imp system/password_at_db10gtest full=y

and I get a few errors including this

ORA-01435: user does not exist

When I create user SCOTT using CREATE USER SCOTT IDENTIFIED BY PASSWORD and [Quoted] then do the imp again everything is imported. But I don't want to create him [Quoted] beforehand, I want the user to be created if it does not exist during the [Quoted] import. According to B10825-01.pdf (page 20-19), user definitions are only imported in "FULL DATABASE MODE". This is why I have added "full=y" in the [Quoted] imp line above. But it still doesn't import the user if it don't exist in the first place.

Please help me with how to create user if it doesn't exist during an imp. In this example I know the user is SCOTT. In a real system I might not know the user name and there maybe more than one. I am sorry if this is too simple. I am using Oracle 10g on Windows.

Thank you
Fred Received on Sun Mar 20 2005 - 11:47:07 CET