Home » RDBMS Server » Server Utilities » Schemas missing in test database (Oracle 10.2.0.2.0 , Linux 5)
Schemas missing in test database [message #615508] Thu, 05 June 2014 00:11 Go to next message
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
Re: Schemas missing in test database [message #615511 is a reply to message #615508] Thu, 05 June 2014 00:15 Go to previous messageGo to next message
Littlefoot
Messages: 21805
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 Go to previous messageGo to next message
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.
Re: Schemas missing in test database [message #615516 is a reply to message #615515] Thu, 05 June 2014 01:17 Go to previous message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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


For instance, using "diff".

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


Current Time: Mon Mar 18 21:16:29 CDT 2024