spool imp_vrfy.rslt 

set linesize 80;
set pagesize 1000;
set long 50;
set echo on;

break on "TYPE" on "OWNER";

/* ****************************************************** */
/*                                                        */
/*  - will validate whether or not an import objects match*/
/*    to that of the export                               */
/*                                                        */
/*         @c:\oracle\sql\imp_vrfy.sql                    */ 
/*                                                        */
/* ****************************************************** */

select 	object_type	"TYPE", 
	count(*)
from all_objects 
group by object_type
order by 1 asc, 2 asc;

select 	object_type	"TYPE", 
	owner		"OWNER",
	count(*)
from all_objects 
group by object_type, owner
order by 1 asc, 2 asc;

set echo off;
spool off;
set long 80;
commit;









