OraFAQ Forum: Server Utilities » Schemas missing in test database

Home » RDBMS Server » Server Utilities » Schemas missing in test database (Oracle 10.2.0.2.0 , Linux 5)

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

Schemas missing in test database [message #615508]

Thu, 05 June 2014 00:11

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

There are some schemas missing in test database when compared to production database.
Schema count in production is 50 but in test it is only 30.It is difficult to find out those
missing schemas in test database.
Could you give an alternate method to find out those missing schemas in test database
instead of cross checking one by one in database manually.

Thanks,
Jack

Report message to a moderator

Re: Schemas missing in test database [message #615511 is a reply to message #615508]

Thu, 05 June 2014 00:15

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't know about you, but I'm quite sure I'd manually find differences in a matter of a couple of minutes (which would, probably, be faster than coding the same thing, which might include creating a database link & writing a query (don't forget debugging)).

What, 50 vs. 30? Print two pieces of paper, sorted alphabetically, and you're done instantly.

[EDIT] If you insist, use MINUS set operator for two

select username from all_users

[Updated on: Thu, 05 June 2014 00:18]

Report message to a moderator

Re: Schemas missing in test database [message #615515 is a reply to message #615508]

Thu, 05 June 2014 00:59

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

@Jack14, if you are wondering how to get the list of all users, use SPOOL in SQL*Plus to get the result of the query LF suggested. You will get to see the difference of 20 users right away.

Report message to a moderator

Re: Schemas missing in test database [message #615516 is a reply to message #615515]

Thu, 05 June 2014 01:17

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

You will get to see the difference of 20 users right away.

For instance, using "diff".

Report message to a moderator

Previous Topic:	Schema export with less space on windows
Next Topic:	How to estimate the size of dump file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 03:08:16 CST 2024