Schema Compilation [message #313475] |
Sat, 12 April 2008 16:08  |
balaji1482
Messages: 312 Registered: July 2007 Location: INDIA
|
Senior Member |

|
|
During import we run this package to compile the schema
EXECUTE DBMS_UTILITY.COMPILE_SCHEMA(schema_name)
This package compiles all procedures, functions, packages, and triggers in the specified schema
my question is why does this package compiles all these packages, and triggers etc..???
please revert me with the answer??
[Updated on: Sat, 12 April 2008 16:09] Report message to a moderator
|
|
|
|
|
Re: Schema Compilation [message #313521 is a reply to message #313488] |
Sun, 13 April 2008 07:25   |
Frank Naude
Messages: 4590 Registered: April 1998
|
Senior Member |
|
|
It's a strange question. What type of answer did you expect?
For example:
Why is the earth round? Because that's how God made it.
Why does it compile all packages, procedures and triggers? Because that's how Oracle's programmers decided to implement this functionality.
|
|
|
|
Re: Schema Compilation [message #313642 is a reply to message #313638] |
Mon, 14 April 2008 00:49  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Quote: | i found the answer of myself by reading the document.
|
You didn't answer to YOUR question:
Quote: | why does this package compiles all these packages, and triggers etc..???
|
And next time, read BEFORE posting.
Regards
Michel
|
|
|