Hi ,
I have question of tradition import and IMP_FULL_DATABASE .
Example :-
Owner Of Schema : - SCOTT
User Exported : - SCOTT
Scott user has IMP_FULL_DATABASE
After export I have dropped all the objects in user SCOTT.
Imported the exported backup file with command as below
$imp scott/tiger file=<file_name>.dmp [ ENTER ]
Here import comes with an error stating that "Must specify FULL=Y or provide FROMUSER/TOUSER or TABLES arguments"
But If IMP_FULL_DATABASE is revoked from SCOTT Schema the above command is working fine .
What is the reason behind this ?
Thnaks