-
编辑 删除
数据库OPEN下，丢失部分或所有control file 是否会导致 实例关闭。
93. Your database is having two control files, three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down? A) any control file B) any archive log file C) one of the redo log members D) loss of the initialization parameter file E) any data file belonging to the default permanent tablespace 1,修改control file 数量从默认的3个变为 题中描述的2个。 [oracle@test ~]$ sqlplus / as sysdba SQL> show parameter db_name; #看下是那
-
编辑 删除
删除一个表空间后，属于这个表空间的 datafile 不会删除。
SQL> drop tablespace BT including contents;Tablespace dropped.D:oracleproduct10.2.0oradatajdb 的目录2012-03-23 09:44 <DIR> .2012-03-23 09:44 <DIR> ..2012-03-27 11:24 19,933,437,952 BT1.DBFBT1.DBF 还在。需要手动删除。[@more@]删
-
编辑 删除
SQLPLUS 下输入命令的字符长度限制
SQL> create table a99 (a1 int,-- a500 int);SP2-0027: Input is too long (> 2499 characters) - line ignored [@more@]
-
编辑 删除
set unused 是否会释放存储空间
1，创建一个多列的体积较大的表；2，观察表的HWM2，set unused 部分列；3，观察表的HWM [@more@]
