-
Hi SREDDY
Thanks Alot for your info regarding the update of oracle database from 734 to 805.I need some scripts for objects count/status.If i need this u asked me to mail you.But i didn't find your mail id.Could you please give me your mail id.I want to write more about my database and my doubts.
Thanks
Ravi
ravi
-
select sum(object_name), status
from dba_objects
group by status;
-
-
This gives schema wise total object count, valid object count and invalid object count ...
------------------------cut here-------------------------------------
set linesize 80
set pagesize 80
spool repobjcount.lst
ttitle ' ' skip 2 -
center 'ORACLE RDBMS' skip 1 -
center 'Object Count Report' right 'Page:' format 99 sql.pno skip 2
col owner format a16 heading 'Object Owner'
col object_type format a20 heading 'Object Type'
col count(*) format 9999 heading 'Object|Count'
break on owner
compute sum of count(*) on owner skip 1
select owner,object_type, count(*)
from dba_objects
group by owner,object_type;
ttitle ' ' skip 2 -
center 'ORACLE RDBMS' skip 1 -
center 'Valid Object Count Report' right 'Page:' format 99 sql.pno skip 2
break on owner
compute sum of count(*) on owner skip 1
select owner,object_type, count(*)
from dba_objects
where status = 'VALID'
-- where status = 'INVALID'
group by owner,object_type;
ttitle ' ' skip 2 -
center 'ORACLE RDBMS' skip 1 -
center 'Invalid Object Count Report' right 'Page:' format 99 sql.pno skip 2
break on owner
compute sum of count(*) on owner skip 1
select owner,object_type, count(*)
from dba_objects
where status = 'INVALID'
group by owner,object_type;
spool off
clear columns
clear breaks
--set feedback on
set verify on
------------------------cut here-------------------------------------
-
Hi Sreddy
Thank you verymuch.
I will be in touch with you through ur mail orcl_dba@hotmail.com.
Please give reply for my doubts.I will write a detail mail to u about my database and upgradation.
Thanks
Ravi
ravi
-
Read 'pwoneil' thread 'create database from full exp dump' started couple of weeks ago. It has lots of information on how to control your export/imort with various options...
-
Ok
I will go through that reddy
Tahnks
ravi
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|