After Impdp of an Infrastructure database (SSO,OID,Portal) : user (orasso) cannot view his own data
i did an expdp (full) and after i did a impdp of the dump file. Everythings run petty well but when i did a check on the data i found something weird ! Here's an example :
from impdp log :
. . imported "ORASSO"."WWSEC_PERSON$" 89.43 KB 362 rows
After i did some select :
connect orasso :
SQL> select count(*) from orasso.wwsec_person$;
COUNT(*)
----------
0
connect system:
SQL> select count(*) from orasso.wwsec_person$;
COUNT(*)
----------
0
connect sys :
SQL> select count(*) from orasso.wwsec_person$;
COUNT(*)
----------
362
I don't understand !
Martin