Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: declare SYS.DBMS_PIPE???
"Greg G" <ggershSNACK_at_CAKEctc.net> a écrit dans le message de news:p5-dnViroPPaLTeiRVn-vg_at_ctc.net...
>
>
> Daniel Morgan wrote:
>
> > Whoever is managing this little shop of horrors should go back to
> > basics. Bounce the
> > server. Does the GRANT still hang? If so I'd be running export to verify
> > logical integrity,
> > catalog.sql, catproc.sql, etc. Bounce the sever again. Does the GRANT
> > still hang? If so
> > I'd be opening an iTAR.
>
> In fact, the server was bounced about a week ago. Unfortunately, I
> can't do that whenever I want, as it's a production box and there's a
> boojum-load of processes that connect to the thing.
> Forgive my ignorance, but how will running export verify logical
> integrity? Or do you mean for me to export and then re-import
> everything. That's not really feasable as this database is gimungous.
>
> -Greg G
>
Export checks logical structure of each block. You don't have to import.
You can also use RMAN.
Or execute the following script as SYS:
Set verify off
Set space 0
Set heading off
Set feedback off
Spool t.lst
Select 'Analyze '||object_type||' '||object_name||' validate structure;'
from dba_objects
where owner='SYS' and object_type in ('INDEX','TABLE','CLUSTER')
order by object_name, object_type;
spool off
Set echo on
Set feedback on
spool AnalyzeDict.lst
@t.lst
spool off
Hope this helps
Michel Cadot
Received on Thu Nov 06 2003 - 15:58:51 CST