Re: DBMS-space Package on AIX

aroesch wrote:

> Unfortunately the DBMS_space package is not functional on AIX. Anyone
> out there who experienced problems also and knows how to get the package
> running on AIX?

I have had no problem at all with the DBMS_SPACE package on any version of UNIX (inc. AIX) or even NT. Remember this is merely a PL/SQL package and is therefore totally platform independant.As far as I can remember the package first became available in 7.3 so is it possible that your version of oracle is too early?

To check this you can go to the $ORACLE_HOME/rdbms/admin directory and run;

grep -in dbms_space *

If this does not return anything your version of oracle is too early. If it returns lines refering to dbms_util.sql and prvtutil.sql these scripts should be run as SYS against your database, although I would be a tad suspicious about your overall installation as they are normally run automatically by catproc which should be run at database creation time.

Hope this helps,

Ian Received on Mon Dec 01 1997 - 00:00:00 CET