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: [EMAIL PROTECTED]
>
> 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 [EMAIL PROTECTED]
> to subscribe send a blank email to [EMAIL PROTECTED]
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: andrey
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
