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