【PL/SQL 学习】PLS-00201

aliim@im1 ALTER PACKAGE IM_UTL COMPILE BODY;
Warning: Package Body altered with compilation errors.
aliim@im1 SHOW ERROR
Errors for PACKAGE BODY IM_UTL:
LINE/COL ERROR
-------- -----------------------------------------------------------------
356/15   PLS-00201: identifier AREA_LIST must be declared
356/15   PL/SQL: Item ignored
357/17   PLS-00201: identifier AREA_LIST must be declared
357/17   PL/SQL: Item ignored
363/5    PL/SQL: SQL Statement ignored
363/95   PL/SQL: ORA-00942: table or view does not exist
365/5    PL/SQL: Statement ignored
365/9    PLS-00320: the declaration of the type of this expression is
         incomplete or malformed

370/5    PL/SQL: Statement ignored
370/9    PLS-00320: the declaration of the type of this expression is
         incomplete or malformed
aliim@im1 alter view viewname  compile;
Enter value for viewname: alter view viewname  compile;
old   1: alter view viewname  compile
new   1: alter view alter view viewname  compile;  compile
alter view alter view viewname  compile;  compile
           *
ERROR at line 1:
ORA-00999: invalid view name
aliim@im1 /
Enter value for viewname: V_AREA_LIST
old   1: alter view viewname  compile
new   1: alter view V_AREA_LIST  compile
Warning: View altered with compilation errors.
aliim@im1 show error
No errors.
aliim@im1

解决办法重新赋予 aliim select any table 权限，这里查出 aliim对AREA_LIST没有访问权限，导致报错。
SQL server 2008 最小化安装(学习专用) 之后下载这两个安装包,根据电脑实际情况下载，这里我选择x64版本的两个轻量级安装包，其他版本比较大，学习的话这两个版本就够了