upgrade

[cravi]

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

[pando]

select sum(object_name), status
from dba_objects
group by status;

[sreddy]

orcl_dba@hotmail.com

[sreddy]

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-------------------------------------

[cravi]

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

[sreddy]

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...

[cravi]

Ok

I will go through that reddy

Tahnks