Re: Error using Import Utility

roles are owned by SYS, not by the creator. Just manually create the role, re-import the file without importing data and all will be resolved.
For a log of the messages, use the log= parameter. Note: in this case you will need to use the non-interactive mode of imp, so you are going to specify ALL parameters on the command line. Refer to imp help=y for syntax

Hth,

Sybrand Bakker, Oracle DBA

<david_petit_at_yahoo.com> wrote in message news:893lhb$ta3$1_at_nnrp1.deja.com...
> Hello all,
>
> 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:43:59 CET