Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: alter system and alter database : not for advanced dbas

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

From: <exu_at_nnng.com>
Date: Fri, 5 Jan 2001 12:21:30 -0600
Message-Id: <10732.125861@fatcity.com> 





'Alter database' commands are used to change the physical settings(such as size,
location) of  your database(such as datafile, logfile) which are defined and
logged in your controlfile.


 'Alter system' commands are used to dynamicly change the parameters set in your
init<sid>.ora and cnfg<sid>.ora  files.


Correct me if I am wrong.


Eveleen
Received on Fri Jan 05 2001 - 12:21:30 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US