Home » Other » Training & Certification » Schema Compilation
Schema Compilation [message #313475] Sat, 12 April 2008 16:08 Go to next message
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 #313481 is a reply to message #313475] Sat, 12 April 2008 18:59 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
balaji1482 wrote on Sat, 12 April 2008 17:08

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..???

Because that's what it is supposed to do.
Re: Schema Compilation [message #313488 is a reply to message #313475] Sun, 13 April 2008 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think I can summarize my reaction to OP post with:

Question Question Exclamation Question Laughing /forum/fa/449/0/ /forum/fa/917/0/

Regards
Michel

[Updated on: Sun, 13 April 2008 08:54]

Report message to a moderator

Re: Schema Compilation [message #313521 is a reply to message #313488] Sun, 13 April 2008 07:25 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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 #313638 is a reply to message #313521] Mon, 14 April 2008 00:45 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

no, that is not the answer for my question. the answer is it compiles all the procedures,funtions,triggers ie. it compiles the statistics of the schema in order to give best retrieval of data.

i found the answer of myself by reading the document.
Re: Schema Compilation [message #313642 is a reply to message #313638] Mon, 14 April 2008 00:49 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: PLS-00363: expression 'xxx' cannot be used as an assignment target (merged)
Next Topic: recovery faq
Goto Forum:
  


Current Time: Thu Mar 28 13:33:19 CDT 2024