Re : imp-000017 oracle error 1917 encountered
Problem Description:
This scenario happens when an error occurs at import time. If any grant,
index, constraint, trigger, etc. for a particular table fails, then all
subsequent similar objects related to that table will fail as well.
Scenario:
- Say scott owns table emp and there are four users called usr1..usr4.
- scott grants select on emp to usr1..usr4.
- ! exp scott/tiger file=grantme.dmp grants=y
- DROP USER scott CASCADE; -- Because I want to rebuild scott's schema
- DROP USER usr2 CASCADE; -- This will trigger the unexpected behavior
- ! imp system/manager fromuser=scott file=scott.dmp
- Execute the following query:
SQL> select grantee, privilege from dba_tab_privs
2 where grantee like 'USR%';
GRANTEE PRIVILEGE
- ----------------------------------------
USR1 SELECT
Therefore, there are four GRANT statements associated with table scott.emp,
and since usr2 was dropped, the GRANT statement on behalf of usr2 fails with
an ORA-01917: "user or role 'USR2' does not exist".
However, what is *not* expected is that both usr3 and usr4 did not get the
SELECT privilege on scott.emp, which is not right. IMP should attempt to
execute as many SQL statements as possible, as there are no dependencies
among
these GRANT statements.
Possible Errors:
IMP-17 the following statement failed with ORACLE error 1917
IMP-3 ORACLE error 1917 encountered
ORA-1917 user or role '<name>' does not exist.
Received on Wed Nov 25 1998 - 08:14:39 CST