OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » users in databse

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

users in databse [message #249231]

Tue, 03 July 2007 12:53

qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia

Member

Is anybody can share the script with me for this. I have two database. I need to find out how many users in db1 does not exists in db2.
Oracle version
9.2.6.0

thanks in advance

Report message to a moderator

Re: users in databse [message #249232 is a reply to message #249231]

Tue, 03 July 2007 13:01

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Connected users?? or total no of users?

select username from dba_users;

select username from dba_users@2nd_db;

Report message to a moderator

Re: users in databse [message #249233 is a reply to message #249231]

Tue, 03 July 2007 13:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

while logged into DB1

select username from dba_users
minus
select username from dba_users@db2
/

Report message to a moderator

Previous Topic:	"create" and "export schema" merged
Next Topic:	Tns service name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 27 20:17:53 CDT 2024