I ran across an error when I configured the OWB.
This error caused me not to connect control center of OWB.
I decide to recompile a achema.
The way you can use even you do not know the password.
The solution is to use the dbms_utility package as a DBA user.
Example, if you want to recompile all procedures,functions, packages
and triggers belonging to scott
here is how to do it:
<!-- ccccccccccccccccccccccccccccccccccccccccccccccccc -->
SQL> exec dbms_utility.compile_schema(schema=>'SCOTT');
PL/SQL procedure successfully completed.
<!-- ccccccccccccccccccccccccccccccccccccccccccccccccc -->
If you only want to recompile all invalid options, execute it like this
:
<!-- ccccccccccccccccccccccccccccccccccccccccccccccccc -->
SQL> exec dbms_utility.compile_schema(schema=>'SCOTT',compile_all=>false);
PL/SQL procedure successfully completed.
<!-- ccccccccccccccccccccccccccccccccccccccccccccccccc -->
If you want to use each object's session settings instead of the calling
user's settings:
<!-- ccccccccccccccccccccccccccccccccccccccccccccccccc -->
SQL> exec dbms_utility.compile_schema(schema=>'SCOTT',compile_all=>false,
reuse_settings=>true);
PL/SQL procedure successfully completed.
<!-- ccccccccccccccccccccccccccccccccccccccccccccccccc -->
To see if any errors were generated
(you must run this command immediately after executing dbms_utility) :
<!-- ccccccccccccccccccccccccccccccccccccccccccccccccc -->
SQL> show errors
No errors.
<!-- ccccccccccccccccccccccccccccccccccccccccccccccccc -->
Another way to see if the compilations were successful :
<!-- ccccccccccccccccccccccccccccccccccccccccccccccccc -->
SQL> select object_name, object_type from dba_objects where owner = 'SCOTT'
and status = 'INVALID';
no rows selected
分享到:
相关推荐
is invoked, then you must make a good faith effort to ensure that, in the event an application does not supply such function or table, the facility still operates, and performs whatever part of ...
ISCmplr project is changed, you normally don t need to recompile Compil32 since it s essentially a text editor, and is not affected by internal changes to the compiler. Non Unicode Inno Setup note: ...
is invoked, then you must make a good faith effort to ensure that, in the event an application does not supply such function or table, the facility still operates, and performs whatever part of ...
By proceeding to use this tool, you agree not to hold it's author accountable for any damages that could potentially arise from it's use or misuse. --------------------------------------------------...
What's New in 12.0.0 beta 2 ** IMPORTANT - Please...- PDF export does not support unicode content. There has been many changes to the PDF rendering engine which should be released soon to fix these bugs.
When a new version of uClibc is released, you may or may not need to recompile all your binaries. 4) malloc(0) in glibc returns a valid pointer to something(!?!?) while in uClibc calling malloc(0)...
VCLZip Native Delphi Zip/UnZip Component!...Fixed a problem that was not allowing ZipComment's to be added correctly to spanned or blocked zip files. Not the same fix as in 2.22. Directories ...
SQL Server keeps track of which pages belong to a table or index by using IAM pages. If there is no clustered index, there is a sysindexes row for the table with an indid value of 0, and that row will...
The component allows you to embed paxScript.NET interpreter into your WinForms, Mobile or ASP.NET application so you can customize and extend the application without having to recompile it. ...
Recompile.exe_for_10.2_Tokyo_Downloadly.ir.rar
Use the -c option if you have a monochrome screen or if you want to make hardcopies of the screen. Currently HINTON.EXE only works with three layer feedforward networks. Data File Organization ...
If you want to recompile the library (to modify it, say), create a new Win32 Static Library project called Particle in Visual Studio and add all the .cpp and .h files to the project, except pspray....
If a file does not extend beyond any of the original limitations (filesizes of 4 gig or 65535 files) then no Zip64 format information is included in the archive.- property isZip64 - tells you when you...
JBOSS 7 热部署文件
ICS V8 is the current development release which is held in a public Version Control repository that is zipped each night for easy download. The download page above also includes the OpenSSL binaries ...
o TCC has a switch to specify which assembler to look for. By default, it will look for TASM.EXE. If you want to use a different assembler, use -E, as described in the Reference Guide. o When ...
• The Java developer does not need to recompile code when making flow changes. Command functionality can be added by extending ActionServlet. The ActionForm class ActionForm maintains the session ...
Scripts give you the possibility to change the behaviour of your C++ programs without any need to recompile your program. A real world example would be game programming: you only have to change the ...
o TCC has a switch to specify which assembler to look for. By default, it will look for TASM.EXE. If you want to use a different assembler, use -E, as described in the Reference Guide. o When ...
The furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property. Copyright laws and international copyright treaties, as well ...