Database Utilities (MOSC)

MOSC Banner

After Impdp of an Infrastructure database (SSO,OID,Portal) : user (orasso) cannot view his own data

edited Feb 6, 2012 8:25AM in Database Utilities (MOSC) 10 comments
Hi,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center