Skip to content

Installation

Unpack the archive, change into the new directory and run install.sql script as user with appropriated privileges with the following arguments:

unzip datagen-x.y.z.zip
cd datagen-x.y.z
sqlplus @install.sql <schema> <tablespace> <synonym>

Where

<schema> - name of the schema where Data Generator objects will be installed.

<tablespace> - name of the tablespace used by Data Generator

<synonym> - name of the public synonym for the Data Generator main package

Please note:

  • All arguments are not case sensitive, double-quoted identifiers are not supported.
  • The <schema> must not already exist. If the <schema> exists and you want to reuse it (f.e. if you install a new version of Data Generator), you must drop this schema first.
  • The <schema> user will get no CREATE SESSION privilege.
  • The package under the <synonym> will get PUBLIC execute privilege.

Example:

sqlplus system@database @install.sql datagen users dg

Note

Currently, many error messages can appear during the installation script running. They can be ignored as long as the script terminates successfully.

After that, you'll can use the Data Generator as follow (as any user):

DECLARE
    v_rec dg.GTYPE_RECORD;
BEGIN
    v_rec := dg.insert_record('my_table');
END;
/

Installing user privileges

The installing database user requires the following privileges.:

COMMENT ANY TABLE

CREATE ANY PROCEDURE

CREATE ANY TABLE

CREATE PUBLIC SYNONYM

CREATE SESSION

CREATE USER

DROP PUBLIC SYNONYM

DROP USER

GRANT ANY OBJECT PRIVILEGE

GRANT ANY PRIVILEGE WITH ADMIN OPTION