Re: Oracle DBA evolution path - please share your opinion

sorry - that should have included the following line:

       'ALTER USER '||username||' DEFAULT TABLESPACE traffic;'||chr(10)||

I'm not *that* evil.

Pd

Paul Drake wrote:
>
> How's this for starting down the path to the dark side?
>
> set pagesize 0 linesize 132
> set heading off verify off termout off feedback off
> REM give them their own sandbox
> CREATE TABLESPACE "TRAFFIC" NOLOGGING
> DATAFILE 'E:\ORACLE\ORADATA\DEV\TRAFFIC.DBF' SIZE 128M
> EXTENT MANAGEMENT LOCAL UNIFORM SIZE 160K
> /
> spool no_more_garbage_in_real_tablespaces.sql
> select 'set heading on verify on feedback on termout on'||chr(10)||
> 'set pagesize 9999 linesize 80'
> from dual
> /
> select 'spool bdbafh_gets_revenge.lst' from dual
> /
> select 'REM '||username||' go play in traffic'||chr(10)||
> 'REVOKE RESOURCE FROM '||username||';'||chr(10)||
> 'ALTER USER '||username||' QUOTA 0 ON USERS;'||chr(10)||
> 'ALTER USER '||username||' QUOTA 0 on INDX;'||chr(10)||
> 'ALTER USER '||username||' QUOTA 48M ON traffic;'
> from dba_users
> where username not in ('SYS','SYSTEM','CEO','OEM')
> /
> select 'spool off' from dual
> /
> spool off
> @no_more_garbage_in_real_tablespaces.sql;
>
> enjoy.
>
> Paul
>
> "Gogala, Mladen" wrote:
> >
> > Did anybody explain you the path of a BDBAFH (DBA version of BOFH)?
> >
> > -----Original Message-----
> > Sent: Wednesday, March 14, 2001 11:16 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > Thanks a lot to all who have responded !
> > U guys really give me inspiration and motivation to go ahead and learn
> > things .
> > I decided to learn everything i could about Oracle ( mainly from these
> > lists ) and simultaniously epand my Java experience .
> > I think it's a good path !
> > Thanks a lot again for your thoughts .
> > BTW , Gaurav , what is "apps dba" ?
> > How could i learn this ?
> >
> > Thanks a lot !
> >
> > -----Original Message-----
> > Behalf Of Gaurav Verma
> > Sent: Tue, February 27, 2001 7:18 AM
> > To: ORACLE-L_at_lists.sunysb.edu
> >
> > Andrey .. good question!
> >
> > > Some background : i've been around Oracle for
> > > several years , i'm DBAing for
> > > 2+ years now , i have written some java code (jdbc ,
> > > some XML etc) , perl ,
> > > PL/SQL , Tcl/Tk , a lot of UNIX scripting .
> > > .Where do i go to from here ?\
> >
> > Long way to go..
> >
> > >
> > > Many people say that the profession of Oracle DBA is
> > > going to be less
> > > demanded in future , because of :
> > > 1) either other DB ( like less-expensive MS SQL
> > > Server or free MySQL) will
> > > occupy the market , especially in small enterprises
> > > ;
> >
> > thats bullshit. If you are a good dba then you should
> > know where to sell your skills. Big organisations
> > still rely on Oracle and will. Oracle aint gonna die
> > so fast.
> >
> > > 1) either other DB ( like less-expensive MS SQL
> > > Server or free MySQL) will
> > > occupy the market , especially in small enterprises
> >
> > is an wayward extrapolation and not yet a reality. We
> > all know the limitations of Sqlserver etc. FOr
> > enterprise use, Oracle is still the best.
> >
> > > 2) or Oracle will "improve" the DB management and
> > > make it "point and click"
> > > , so you do not need a dedicated Oracle DBA at all
> > > or you need less Oracle
> > > DBAs .
> > >
> > thats true. Oracle will always improve the interface.
> > and it did. from SQl*dba to OEM, it has improved a lot
> > (point and click) but still you do need human
> > intervention a lot. Human decision is still human
> > decision and you should know it better. DBAs are
> > always going to be in demand. You could say.. people
> > might need lesser.. but then what do just have to do
> > is become one of the best. Keep updating your skills.
> >
> > > So , the bottom line is : what should i learn now ?
> > > how can i extend my
> > > expertise ? In which fields ?
> >
> > Hmm... guess you should try out the marketable skills.
> > working on production databases, high-availability
> > implementations, partitioning, datawarehousing,
> > replication, parallel server (now replaced with (9i
> > clusters) blah blah blah
> >
> > > Please share your thoughts !
> > > Thanks a lot in advance !
> >
> > So my friend, there is a lot to learn and work upon.
> > You could even consider becoming an apps dba rather
> > being an plain oracle dba. It pays a lot more and you
> > have to believe me there. 11i is HOTTTT man.
> >
> > just my 2 cents.
> >
> > cheers,
> >
> > Gaurav
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail.
> > http://personal.mail.yahoo.com/
> >
> > --------
> > Think you know someone who can answer the above question? Forward it to
> > them!
> > to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: andrey
> > INET: bronfin_at_visualtop.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Gogala, Mladen
> > INET: MGogala_at_oxhp.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: paled_at_home.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).