Etimemachine installation in Oracle 10g

It is not unusual I can’t stop frowning at what developer did. Looks what Etimemachine guys play with oracle database:
They can’t catch up with Oracle new features and break security rules obviously.

create tablespace ***_dat
datafile ‘??PATHNAME??**.dbf’ size 500M reuse
default storage (
 initial 100K next 100K
 minextents 1 maxextents 121
 pctincrease 0)
online;

create tablespace ***_ndx
datafile ‘??PATHNAME??***.dbf’ size 200M reuse
default storage (
 initial 100K next 100K
 minextents 1 maxextents 121
 pctincrease 0)
online;

create user TME***
grant dba to TME*** with admin option;

My suggestions:
=>create tablespace *** datafile size 500M;
=>create tablespace *** datafile size 200M;
=>comment out ‘grant dba to TME***’. Never do it if you only need to create/drop your things in database.

It recommends us (DBA) to be more proactive and let them (developers) to know how to deal with database efficiently and appropriately.

Advertisements

About Pang

Oracle DBA working in database, fusion middleware and identity management and cloud.
This entry was posted in Installation. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s