Use the ALTER SYSTEM statement to dynamically alter your Oracle Database instance. The settings stay in effect as long as the database is mounted. Modifies a database, or the files and filegroups associated with the database. Adds or removes files and filegroups from a database, changes the attributes of a database or its files and filegroups, changes the database collation, and sets database options. Database snapshots cannot be modified和硬盘文件相关的操作,比如增加删除文件等用alter database,其他的不直接牵涉到磁盘文件的操作的,其他则用alter systemalter DATABASE 用于改变一个数据库的属性.alter system 用于动态改变数据库例程的属性ALTER SYSTEM 改变的是逻辑上的,看不见的,而 ALTER DATABASE 改变的是物理上的,看得见的。
Modifies a database, or the files and filegroups associated with the database. Adds or removes files and filegroups from a database, changes the attributes of a database or its files and filegroups, changes the database collation, and sets database options. Database snapshots cannot be modified和硬盘文件相关的操作,比如增加删除文件等用alter database,其他的不直接牵涉到磁盘文件的操作的,其他则用alter systemalter DATABASE 用于改变一个数据库的属性.alter system 用于动态改变数据库例程的属性ALTER SYSTEM 改变的是逻辑上的,看不见的,而
ALTER DATABASE 改变的是物理上的,看得见的。