| Users unknown [message #389968] |
Wed, 04 March 2009 06:44  |
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
|
Senior Member |
|
|
I am in process of importing a dump file into my database.
For that i am checking the interschema dependancies.
I seen in below schemas there is interdependancy.
SELECT * FROM
(
SELECT c.owner childt,c.table_name,p.owner parentt,p.table_name ptable_name
FROM DBA_CONSTRAINTS c,DBA_CONSTRAINTS p
WHERE c.r_constraint_name=p.constraint_name
)
WHERE childt<> parentt
ORDER BY childt
*PERFOLD, PERFSTAT, RCAT1,RMAN, RMAN_GLB, HR, SH, OE, PM*
I think those are not user created users?
When those users are created?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
