How does one rename a database?
摘自Orafaq
Follow these steps to rename a database:
- Start by making a full database backup of your database (in case you need to restore if this procedure is not working).
- Execute this command from sqlplus while connected to 'SYS AS SYSDBA':
ALTER DATABASE BACKUP CONTROLFILE TO TRACE RESETLOGS;
- Locate the latest dump file in your USER_DUMP_DEST directory (show parameter USER_DUMP_DEST) - rename it to something like dbrename.sql.
- Edit dbrename.sql, remove all headers and comments, and change the database's name. Also change "CREATE CONTROLFILE REUSE ..." to "CREATE CONTROLFILE SET ...".
- Shutdown the database (use SHUTDOWN NORMAL or IMMEDIATE, don't ABORT!) and run dbrename.sql.
- Rename the database's global name:
ALTER DATABASE RENAME GLOBAL_NAME TO new_db_name;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-979127/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How does an Electric Motor work? (DC Motor)
- How does SAP freelancer find a project that is not tough?Project
- Source Code Reading for Vue 3: How does `hasChanged` work?Vue
- Setup Standby Database on One PC(轉)Database
- how to move a MediaWiki wiki from one server to anotherServer
- How to Collect Diagnostics for Database Hanging Issues (Doc ID 452358.1)Database
- How to get the exact duration of an audio file in js All In OneJS
- SAP Retail Listing – How does it work (中英文對照版)AI
- How to create the Gold gold using RGB color values All In OneGo
- [20221222]How to Enable and Disable Database Options in oracle 11g.txtDatabaseOracle
- How to use VS Code to debug Next.js applications All In OneJSAPP
- MySQL rename table方法大全MySql
- os.walk、os.rename
- tomcat one connection one thread one request one threadTomcatthread
- How to ssh
- Linux rename命令批量修改檔名Linux
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- What does -> do in clojure?
- does not support SSL connections
- ‘map’ does not name a type
- Linux常用基本命令(rename,basename,dirname)Linux
- [20231025]跟蹤rename操作2.txt
- oracle 線上rename資料檔案Oracle
- Redis原始碼系列之rename講解Redis原始碼
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- Error querying database. XXXXXXXXXXXXX, No database selected。ErrorDatabase
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- How to find dependency
- The label does not denote a loop in forEachOOP
- What does "xargs grep" do?
- error: 'cout' does not name a type|Error
- error: ‘xxx’ does not name a typeError
- HFR:在RBF上實現跨NameSpace Renamenamespace
- Database TimeoutDatabase
- Database OverallDatabase
- database no shardingDatabase
- [譯] WebAssembly: How and whyWeb
- How OpenStack integrates with Ceph?
- How to Build a Cybersecurity CareerUI