| Script |
Description |
Update |
|
CompTrig |
This procedure compiles all
triggers in the specified schema. This process only takes place in the server and
therefore is usually is much faster then other spooling based scripts. |
27-JUN-2002 |
|
GenSynos |
This procedure generates public
synonyms for all objects in the given schema. This process only takes place in the server
and therefore is usually is much faster then other spooling based scripts. |
27-JUN-2002 |
|
GenGrants |
This procedure generates public
synonyms for all objects in the given schema. This process only takes place in the server
and therefore is usually is much faster then other spooling based scripts. |
27-JUN-2002 |
|
GenUsers |
This procedure generates a spool
file named "CreateUsers.SQL" that allows to regenerate all the existing users in the current
schema. The interesting in this script is that this script uses a undocumented
Oracle feature to automatically regenerating the existing passwords of the users. |
27-JUN-2002 |
|
CompileAllObjects |
This procedure compiles
all invalid objects in a given schema or a complete database
and is an alternative to the build-in dbms_utility.compile_schema proceduere. |
22-FEB-2004 |
|
CheckPassword |
This function allows to
check if a user/password combination is valid on a given server. This is
usually not possible from within PL/SQL and Oracle does not offer any
build-in mechanism or workaround to do so. |
22-FEB-2004 |
|
NumberToWords |
This package provides a
function NumberToWords converting numbers to their
English equivalent and returns it as a string. |
03-MAR-2004 |
