Re: Error using Import Utility

The option of users, roles and objects creation available for import entire database export file.
You can create the file of parameters and specify a log file you desire. Try imp help=y
Good luck!

<david_petit_at_yahoo.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: 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 - 18:57:09 CET