RE: alter system and alter database : not for advanced dbas

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Fri, 5 Jan 2001 13:31:42 -0500
Message-Id: <10732.125863@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07745.C3210506

Content-Type: text/plain;

charset="iso-8859-1"

Alter system changes the instance (alter system switch logfile) Alter database changes the physical structure of the database (alter database datafile resize...)

That's my take, HTH

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849

http://www.qode.com

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

-----Original Message-----

From: Ajay Khandelwal [mailto:ajay_at_tems.com] Sent: Friday, January 05, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L Subject: alter system and alter database : not for advanced dbas

Hi All,
For some of you this may be a very basic question .But is there any rationale behind some command being "alter system" and other being "alter database" ,I mean sometime it becomes confusing if you don't remember 'em.

Thanks
-Ajay

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ajay Khandelwal
INET: ajay_at_tems.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).

------_=_NextPart_001_01C07745.C3210506

Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">
<TITLE>RE: alter system and alter database : not for advanced = dbas</TITLE>
</HEAD>
<BODY>

Alter system changes the instance (alter system = switch logfile)
 Alter database changes the physical structure of the = database (alter database datafile resize...)

That's my take, HTH

<P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT>
<BR><FONT SIZE=3D2>Oracle Database Administrator</FONT>
<BR><FONT SIZE=3D2>Qode.com</FONT>
<BR><FONT SIZE=3D2>4850 North State Road 7</FONT>
<BR><FONT SIZE=3D2>Suite G104</FONT>
<BR><FONT SIZE=3D2>Fort Lauderdale, FL&nbsp; 33319</FONT>
</P>

<P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT>
<BR><FONT SIZE=3D2>F: 954.484.2933 </FONT>

C: 954.658.5849 <A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A>

"The information contained herein does not = express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."

-----Original Message----- From: Ajay Khandelwal [<A = HREF=3D"mailto:ajay_at_tems.com">mailto:ajay_at_tems.com</A>]

<BR><FONT SIZE=3D2>Sent: Friday, January 05, 2001 12:46 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: alter system and alter database : not for =

advanced dbas

Hi All,
 For some of you this may be a very basic question = .But is there any
 rationale behind some command being "alter = system" and other being "alter database" ,I mean sometime it becomes confusing = if you don't remember 'em.

<P><FONT SIZE=3D2>Thanks</FONT>
<BR><FONT SIZE=3D2>-Ajay</FONT>
</P>

-- 
 Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Ajay Khandelwal</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: ajay_at_tems.com</FONT>
</P>

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051 San Diego, =
California        -- Public Internet = access / Mailing Lists
 <FONT =

SIZE=3D2>---------------------------------------------------------------=

-----

 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 = Received on Fri Jan 05 2001 - 12:31:42 CST