--dba 권한자의 전체 스키마 invalid 오브젝트 컴파일
select 'ALTER '||object_type||' '||owner||'.'||object_name||' COMPILE;'
from dba_objects
where owner not in ('SYS','PUBLIC','SYSTEM')
and status <> 'VALID'
and object_type IN ('VIEW','PROCEDURE','FUNCTION','PACKAGE','TRIGGER')
order by owner;
출처 : 옆자리사람
검색결과를 보고 찾아오셔서 질문덧글을 다시는 분들께 죄송하게 되었습니다.
IT종사자이다보니 필요한 내용을 인터넷에서 찾았을 때 바로바로 저장할 공간이 필요했거든요.
자주 들르며 관리할 계획이 없는 블로그입니다.
부정확한 정보도 있을 수 있고 하니 너무 추궁하지는 말아주세요.
As of right now I know that these "No such supported" errors are caused by a dll issue. Which dll I am unaware of at this time. So to resolve the issue I re-registered every dll on my system. To do this follow the below steps.
Register all dll files within registry
1) First go Start/Run, and type in 'cmd' to bring up the Command Prompt.
2) Type 'CD \' and hit enter.
3) Type 'DIR *.dll /s /b > regdll.bat' and hit enter.
4) Type 'Notepad regdll.bat' and hit enter.
Now Notepad is going to bring up a list of your .dll files, never mind that for a moment.
5) Now type 'Path' and hit enter to see your current path. It will bring up something like: Path=c:\Windows;c:\windows\Command
6) (supplement your Windows Version, ex: C:\WINNT, or C:\Windows) Now type: 'Path=c:\windows;c:\windows\Command;c:\Windows\Pro g
ram~\Accessories' and hit enter.
7) Verify again by typing 'Path' and hitting enter, and then type: 'C:\WINNT\System32\Regsvr32.exe /s C:\' and hit enter again.
Now, go back to Notepad and if you have Win98 use the replace feature in Wordpad (CTRL + H) or notepad to search for 'C:\' and replace it with this: 'C:\Windows\System\Regsvr32.exe /s C:\'
If you have Win2000, etc. use the replace command in note pad to search for 'C:\' and replace it with this: 'C:\WINNT\System32\Regsvr32.exe /s C:\'
*Be sure to type the replace string exactly like above or it won't work*
9) Use "Replace All" to make the changes to the entire file.
10) When it finishes, save it, exit notepad or wordpad, and return to the Command Prompt.
11) Type 'regdll' and press enter. If you followed the above steps correctly it will now go through and re-register all your .dll files.
An example of a line from my bat is below
"C:\Windows\System32\regsvr32.exe /s C:\Program Files\Common Files\Microsoft Shared\ink\IPSEventLogMsg.dll"
You may receive numerous errors during this mass registration, simply clear them by clicking OK or whatever you need to to clear the error and the bat file should continue to run. The process may also seen to hang and become unresponsive. Be patient, go get a cup of coffee, a bawlz or smoke a cigarette. I am confident this will resolve your issue. It solved three for me, one involving media player, one involving the right click screen resolution option in the context menu and one involving the personalize context menu option.
최근 덧글