Hello all,
I'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of
the same error:
IMP-00017: following statement failed with ORACLE error 9275:
"GRANT SELECT ON "DOWNLOAD_SEQ" TO "INTERNAL""
IMP-00003: ORACLE error 9275 encountered
ORA-09275: CONNECT INTERNAL is not a valid DBA connection
I'm aware that connect internal does not exist in 9i, but 'internal' is a
role.
So as a test I dropped the role, recreated it and then manually tried to
grant it something - The same error occurred:
SQL> select * from dba_roles where role like 'INTER%';
ROLE PASSWORD
------------------------------ --------
INTERNAL NO
SQL>
SQL> drop role internal;
Role dropped.
SQL> create role internal;
Role created.
SQL> GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL;
GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL
*
ERROR at line 1:
ORA-09275: CONNECT INTERNAL is not a valid DBA connection
SQL>
This doesn't make any sense to me. Can anybody help to shed any light on
this??
TIA for any response, they're much appreciated.
Cheers,
Barry.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Barry Deevey
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
