Database Utilities (MOSC)

MOSC Banner

ERROR IN IMPORTING FULL DATABASE

edited Oct 27, 2009 4:18AM in Database Utilities (MOSC) 5 commentsAnswered
 Hi,

Scenario:

platform:windows

 i have a testing database on "Test Server"  which is clone of "Production Database".

 I have Current Dumpfile: full.dump

My Senior told me he want clone database with currect data.

For this i have taken the backup of clone database.

after this i have drop all users with this script: 

SQL> set head off
SQL> spool drop_all_users.lst
SQL>select 'drop user ' || username || ' cascade ; ' from   all_users where username not in('SYS','SYSTEM');
sql> spool off

I have excuted this script

SYS>@C:\drop_all_users.lst

default users are still available & i am getting error :

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center