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...???
It's a live database and no down time
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 .
For rebuilding you system tables, run catalog.sql script which is available
Say No To Plastics
How did you come to conclude that the system tbs is corrupt?
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be
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
You have to log in as sys as user and then run the catalog scripts.
Just monitor whether these scripts are run properly.
got a hunch that probably your system kernel parameters are
not enough....chk the oracle alert.log for clues..
Check all the ORA error number
Pls post all the ORA errors related to this issue and search for errors in alert file also.
Click Here to Expand Forum to Full Width