Step by Step move datafile in Oracle
来源:互联网 发布:淘宝网针织杉时腰 编辑:程序博客网 时间:2024/05/17 20:28
1. List all datafile for tablespace PSABTABD
2. shutdown DB
3. move datafile using brtools or copy using OS level
4. startup mount database (if using copy OS Level)
5. execute this command to change controlfile for new location of datafile
ALTER DATABASE RENAME FILE 'old_path' TO 'new_path';
6. startdatabase
Regards
2. shutdown DB
3. move datafile using brtools or copy using OS level
4. startup mount database (if using copy OS Level)
5. execute this command to change controlfile for new location of datafile
ALTER DATABASE RENAME FILE 'old_path' TO 'new_path';
6. startdatabase
Regards
- Step by Step move datafile in Oracle
- step by step,start oracle in linux
- Step by Step: Event handling in C#
- Create ActiveX in .NET Step by Step
- Create ActiveX in .NET Step by Step
- Oracle dataguard配置Step by Step
- Oracle高级复制Step by Step
- step by step DBCA创建Oracle数据库
- oracle 10g stream step by step
- Install Oracle on RHEL5 - step by step
- win nt 卸载oracle step by step
- Git Step By Step - Step 2: Go Back in Time
- NHibernate Step by Step
- OGRE step by step
- step by step
- MinGW Step by Step
- 大杂烩---Step by Step
- sphinx4 STEP BY STEP
- 漫谈Ajax在ASP.Net中的使用
- Program received signal SIGPIPE, Broken pipe
- How to Analyzing Authorization Checks for SAP User
- 动态调用WebService(C#)
- How to find the relation between role and user, t-code, profile
- Step by Step move datafile in Oracle
- 老的网易相册爬虫
- 如何在VB6中使用.NET开发的UserControl
- 【转帖】程序员过年—想想自己到底想干啥
- Password is deactivated in SAP R/3 4.6C
- 手机成语大词典java 手机词典
- ADO.NET常用操作
- Alternative RNA Splicing
- 倒 计 时 代 码