DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: upgrade

  1. #1
    Join Date
    Nov 2000
    Posts
    157
    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    select sum(object_name), status
    from dba_objects
    group by status;

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    orcl_dba@hotmail.com

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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-------------------------------------

  5. #5
    Join Date
    Nov 2000
    Posts
    157
    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

  6. #6
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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...

  7. #7
    Join Date
    Nov 2000
    Posts
    157
    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
  •  


Click Here to Expand Forum to Full Width