This discussion is archived
2 Replies Latest reply: Dec 26, 2012 8:53 PM by dilipkumar10285 RSS

what is package force compile

981791 Newbie
Currently Being Moderated
can anybody differ between compile and force compile of a package or view
  • 1. Re: what is package force compile
    sb92075 Guru
    Currently Being Moderated
    978788 wrote:
    can anybody differ between compile and force compile of a package or view
    post URL where "force compile" is documented.
  • 2. Re: what is package force compile
    dilipkumar10285 Explorer
    Currently Being Moderated
    Hi,

    First of all you can forcefully compile only view not package.
    Package cannot compile forcefully but view can because view may refer to table which is yet not defined or not exists. So in this case you are creating view forcefully but its status will be INVALID.
    But after defining the referred the table we can recompile the view again to make it in to VALID stat.
    This feature is useful in parallel development environment where multiple developer can work on same table while table is still in developing phase (ie yet not created).

    Hope this helps!

    Cheers!!
    Dilipkumar Vishwakarma

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points