Error using Import Utility

From: <david_petit_at_yahoo.com>
Date: Thu, 24 Feb 2000 16:16:47 GMT
Message-ID: <893lhb$ta3$1_at_nnrp1.deja.com>

[Quoted] Hello all,

[Quoted]   A file is exported from the Oracle 7.3.3 database (A) on Solaris platform. (Full export). I want to import this file to another Oracle 7.3.4 database (B) on Windows NT platform. I choose yes in the import grants option. All the tables are created by user "ORA_DBA" in database (A). I created a user "ORA_DBA" in database (B). The default tablespace of user "ORA_DBA" in database (B) has enough space to import all the tables.

  However, during importing, the system generate the following errors:

  imp-00003: oracle error 1917 encountered
  ORA-01917: user or role 'GET_TABLE' does not exist
  IMP-00017: following statement failed with Oracle error 1917:

  "GRANT SELECT ON "EMPLOYEE" TO "GET_TABLE""   Why the role 'GET_TABLE' cannot created in database (B)? Is it possible to import the roles? (all the roles are created by the user "ORA_DBA" and all the rows in tables are imported successfully)

  (P.S. Is it possible to log all the messages generated by using the import utility?)

Thanks,
David

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 24 2000 - 17:16:47 CET