2 Replies Latest reply: Dec 26, 2012 10:53 PM by dilipkumar10285 RSS

    what is package force compile

    981791
      can anybody differ between compile and force compile of a package or view
        • 1. Re: what is package force compile
          sb92075
          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
            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