Arn't you going to make sure you actually have the disk space to resize that data file first?  Something
OEM does not do for you.  Must go out to the server and check.
-----Original Message-----
From: JOE TESTA [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 7:22 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: OT RE: 24 x 7 on NT?

Mike, i'm with you there.
 
alter database datafile '/fill/in/name/here' resize 200m;
 
or right click in OEM and change the size.  As long as you can do the previous then might as well use the latter :)
 
joe
 


>>> [EMAIL PROTECTED] 06/27/01 09:26AM >>>


More on the same vein. Sorry if this thread is developing a "me too" feel.

I'm happy to use GUI tools when they save me time. I know what they're doing and
how they achieve their results.
The availability of GUI tools is however a huge disincentive for new DBAs to
find out how the database actually works and leads to a lack of understanding of
the way the beast works as a whole.

If your goal is to be a knowledgeable and effective DBA then you can't beat
starting from the command line and working your way towards GUI when you find
your feet. That requires a long-term viewpoint though, and the world is
focussing increasingly on the short term.

If I sound like a Luddite then I've given the wrong impression; that;s just my 4
groats-worth.

Regards,

Mike




|--------+------------------------->
|        |          Peter McLarty  |
|        |          <peter.mclarty@|
|        |          incts.com>     |
|        |                         |
|        |          06/27/01 01:30 |
|        |          PM             |
|        |          Please respond |
|        |          to ORACLE-L    |
|        |                         |
|--------+------------------------->
  >-----------------------------------------------------------------|
  |                                                                 |
  |       To:     Multiple recipients of list ORACLE-L              |
  |       <[EMAIL PROTECTED]>                                    |
  |       cc:     (bcc: Mike Hately/ETECH)                          |
  |       Subject:     Re: OT RE: 24 x 7 on NT?                     |
  >-----------------------------------------------------------------|




Oh I agree
As a newbie to the Oracle fold I found it oh so easy to dive into
stuff  with the DBA Studio, I suppose the thing that stops me is some 7 or
more years hacking around Linux and Unix systems. Graphical tools are great
for some things but you just cant beat the capabilities of a good script
and Windows will be a lot better for it now it has a good scripting system.
What i found DBA studio for thogh was the show SQL button I could set up
some task to do and then have a look at the SQL that was going to happen so
I could better understand it.

I am sure when we start seeing more Oracle up on Win2K we will see a lot
more scripting on that side to do those mixed OS and SQLPlus tasks.


Peter McLarty
[EMAIL PROTECTED]
04 0209 4238
System Administrator
L plate Oracle DBA


At 03:56 AM 27/06/2001 -0800, you wrote:
>On June 27, 2001 07:55 am, Mark Leith wrote:
> > slapping developers - what's the problem with them?
>
>No problem slapping developers.... rather enjoy it actually ....
>
>The issue I have with point & click is the increasing number of
>database admins who can only use these tools. Put them in front of a
>command line and they will sit and stare blankly. GUI tools can be
>great (except when they're written in java :), but you should
>actually know what you are doing and the 'how & why' behind it before
>you start clicking a database to death.
>
>Just my cynical $.02.
>Cheers,
>GC
>--

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Peter McLarty
  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:
  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).

Reply via email to