Requirements

The following list shows the requirements for using the database extension.

1. eZ Publish version 3.7 or 3.8.
2. Oracle 8 or 9 (client and server software, SQL*Plus command line tool). Note that Oracle 10 is not recommended for this version of the database extension.
3. PHP 4.4 (preferably the latest version of the 4.4 branch) with Oracle support.
4. Proper Oracle environment variables setup (please refer to the PHP Oracle functions documentation for more information).

5. A user that has the following system privileges on the Oracle database server:

   Privilege	Description
   CREATE SESSION	Connect to the database.
   CREATE TABLE	Create tables in own schema. Also allows the creation of indexes (including those for integrity constraints) on table in own schema.
   CREATE TRIGGER	Create a trigger in own schema.
   CREATE SEQUENCE	Create a sequence in own schema.
   CREATE PROCEDURE	Create stored procedures, functions, and packages in own schema.
   ALTER ANY TABLE	Alter any table in any schema and compile any view in any schema.
   ALTER ANY TRIGGER	Enable, disable, or compile any trigger in any schema.
   ALTER ANY SEQUENCE	Alter any sequence in any schema.
   ALTER ANY PROCEDURE	Compile any stored procedure, function, or package in any schema.
   DROP ANY TABLE	Drop or truncate any table in any schema.
   DROP ANY TRIGGER	Drop any trigger in any schema.
   DROP ANY SEQUENCE	Drop any sequence in any schema.
   DROP ANY PROCEDURE	Drop any stored procedure, function, or package in any schema.

   It is recommended that the user also has unlimited quota on the tablespace in which the user schema has been created. This is due to the fact that eZ Publish is a content management system, it needs to be able to store large amounts of data. The size of the site is usually proportional with the storage needs.