ERROR IN IMPORTING FULL DATABASE
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 :