Hi all,
I have export (exp) dump of a schema (9.2.0.1.0)
I am importing (imp) the dump into newly created database (11.1.0.6.0)
It successfully imports saying "import terminated successfully with warnings" (views & triggers with compilation errors...)
I have all the objects tables,functions,procedures etc but I dont have "grants"...
I verified from 9i database that the count of objects is same, roles is also same (select distinct role,owner from ROLE_TAB_PRIVS where owner='user1')
the grants part....(select granted_role from DBA_ROLE_PRIVS where grantee='user1')
the import command i use is
imp 'system/oracle as sysdba' file=dump.dmp log=test.log grants=y compile=y indexes=y fromuser=user1 touser=user1 ignore=y
I am connecting as sysdba & checking the count
export of the whole schema is taken without any warnings.
Please guide me if I am wrong at any step..
Thanks,
Mohib