Home » RDBMS Server » Server Administration » Users unknown (Oracle 10g)
Users unknown [message #389968] Wed, 04 March 2009 06:44 Go to next message
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?


Re: Users unknown [message #389972 is a reply to message #389968] Wed, 04 March 2009 06:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you search before posting?
Of course not!

Regards
Michel
Re: Users unknown [message #391046 is a reply to message #389968] Tue, 10 March 2009 15:40 Go to previous message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

The same post in OTN Smile
http://forums.oracle.com/forums/thread.jspa?threadID=867674&messageID=3313288
Previous Topic: Increase SGA dinamically
Next Topic: How to start/access additional database created from command line
Goto Forum:
  


Current Time: Sat Dec 10 20:55:15 CST 2016

Total time taken to generate the page: 0.14374 seconds