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

Thread: System tables corrupted ????

  1. #1
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    when ever fire any query on DBA_segments,

    I got the meeasge not connected to oracle or end of coomunication to oracle.
    How can you rebuild system tables or views , how can you repair system tablespace...???

    Please help
    It's a live database and no down time


  2. #2
    Join Date
    Feb 2001
    Posts
    32
    You don't have connection to the DB. Check, the DB must be down. Or you are probably disconnected from SQLPLUS if you are using client/server connection .

  3. #3
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    For rebuilding you system tables, run catalog.sql script which is available
    in ORACLE_HOME/rdbms/admin.

    Vijay.
    Say No To Plastics

  4. #4
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    How did you come to conclude that the system tbs is corrupt?
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  5. #5
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    can we rebuild using catproc in production database.

    I am connected properly but as soon as fired query on dba_segment tablespace it get disconneted

  6. #6
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    You have to log in as sys as user and then run the catalog scripts.
    Just monitor whether these scripts are run properly.



  7. #7
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    got a hunch that probably your system kernel parameters are
    not enough....chk the oracle alert.log for clues..

  8. #8
    Join Date
    Sep 2001
    Posts
    9

    Lightbulb Check all the ORA error number

    Hi,
    Pls post all the ORA errors related to this issue and search for errors in alert file also.

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