undo表空间切换
来源:互联网 发布:图书借阅软件 编辑:程序博客网 时间:2024/04/25 13:27
C:\Documents and Settings\gqgai>sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.6.0 - Production on Fri Mar 4 20:55:59 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
20:55:59 SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
20:56:14 SQL> startup
ORACLE instance started.
Total System Global Area 59842188 bytes
Fixed Size 454284 bytes
Variable Size 33554432 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: 'D:\ORADATA\WWL\UNDOTBS01.DBF'
20:59:28 SQL> alter database datafile 'D:\ORADATA\WWL\UNDOTBS01.DBF' offline drop;
Database altered.
Elapsed: 00:00:00.00
20:59:34 SQL> alter database open;
Database altered.
Elapsed: 00:00:02.04
20:59:40 SQL> select name from v$datafile;
NAME
-------------------------------------------------------
D:\ORADATA\WWL\SYSTEM01.DBF
D:\ORADATA\WWL\UNDOTBS01.DBF
D:\ORADATA\WWL\PERFSTAT01.DBF
D:\ORADATA\WWL\WWL.DBF
21:00:55 SQL> create undo tablespace undotbs2
21:01:03 2 datafile 'd:\oradata\WWL\undotbs2.dbf' size 10M;
Tablespace created.
Elapsed: 00:00:02.02
21:06:29 SQL> ALTER SYSTEM SET undo_tablespace='UNDOTBS2' ;
System altered.
Elapsed: 00:00:00.01
- undo表空间切换
- 切换UNDO表空间
- undo表空间的切换
- undo表空间的切换
- oracle undo表空间切换
- Oracle 11g Undo 表空间切换
- 创建并切换UNDO表空间
- ORACLE在线切换undo表空间
- undo表空间的切换,常识
- Oracle切换undo表空间操作步骤
- ORACLE在线切换undo表空间
- ORACLE在线切换undo表空间
- oracle表空间---undo表空间切换
- 自动undo表空间模式下切换新的undo表空间
- 切换UNDO表空间--DDL使事务自动提交
- oracle 11g rac undo表空间切换
- oracle9i日常维护之undo表空间切换
- undo表空间的作用、收缩及切换
- C++代码优化[转摘]
- C++第13周报告(三)编制一个三角函数表
- js中appendChild()用法
- c# 基础加强--多态I
- 创业公司感悟录之十个提醒(摘自 李天平的博客)
- undo表空间切换
- Windows多显示器编程--VC
- strrchr()——查找字符串中最后出现某个字符的地方
- ISO
- Android中打包含有Activity以及资源文件的jar包在工程中调用
- cocos2d-x学习笔记(三)让精灵按照自己设定的运动轨迹行动(曲线移动)。(以椭圆轨迹为例)。
- android.content.res.Resources$NotFoundException: String resource ID #0x1
- C语言中实现数据与算法分离
- 数据库之【异常处理篇】