Hello,
we are trying to install TrialDB and here is what I've got from our DBA:
I can't open the compressed HTML file TrialDB.chm. But I tried to run
trialdb_tables.sql. The developers have bad practice in creating this script:
1. Some system-generated constraint names and LOB names have hardcoded numbers
in them, e.g. "LOB(CORRESPONDENCE_TEMPLATE) STORE AS SYS_LOB0000035187C00002$$",
or "ADD CONSTRAINT SYS_C002307". On one occasion, when I ran the script, the
constraint name already exists in my database used by another schema so there
was a name collision.
2. "USING INDEX TABLESPACE SYSTEM" should be changed to "USING INDEX TABLESPACE
ACT_PROD".
I can't find create user script. But reading the DDL script, I know the username
should be act_prod. There's no create sequence script. But I can extract them
out from trialdb_tables.sql script based on the trigger code. It would be nice
if the script is explicitly provided.
There's no list of minimum required privileges. But I think the following will
do:
create user act_prod identified by <password> default tablespace ACT_PROD
temporary tablespace temp quota unlimited on ACT_PROD;
grant create session, create table, create view, create sequence, create trigger
to act_prod;
create user repuser identified by <password> default tablespace ACT_PROD
temporary tablespace temp;
grant create session to repuser;
Could you please help us in resolving these problems.
Thank you,
Dragan