摘要：ORACLE重设表空间的大小 You can enlarge a tablespace by: • Change the size of a data file: - Automatically during tablespace creation SQL> CREATE TABLESPACE userdata02 DATAFILE '/u01/oradata/userdata02.db... 阅读全文

摘要：--手动更改日志组 ALTER SYSTEM SWITCH LOGFILE; --增加日志组 ALTER DATABASE ADD LOGFILE GROUP 5 ('E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO04.LOG') SIZE 8M; --删除日志组 alter database drop logfile group 4 ; --添加日志组成员... 阅读全文

摘要：Sizing the Control File Keywords specified during the creation of the database affect the size of the control file. This is particularly significant when the parameters have large values. The size of ... 阅读全文