Can one rename a database user (schema)?
摘自Orafaq
No, this is listed as Enhancement Request 158508. Workaround:
- Do a user-level export of user A
- create new user B
- import system/manager fromuser=A touser=B
- drop user A
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-979126/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How does one rename a database?Database
- SQL can execute in wrong SchemaSQL
- Rename Tablespace in Oracle database 10gOracleDatabase
- user和schema的區別
- Oracle User 和 Schema 的區別Oracle
- VMS: ALTER TABLESPACE/DATABASE TO RENAME FILES on VMS [ID 9560.1]Database
- malformed database schema (is_transient) - near "where"ORMDatabase
- for public synonym, only sys user can compile it?Compile
- Setup Standby Database on One PC(轉)Database
- How Python MongoDB Toolkit Ming Can Ease Schema MaintenancePythonMongoDBAINaN
- Oracle 11gR2 使用者重新命名(rename user)Oracle
- PARSING_USER_ID,PARSING_SCHEMA_ID,PARSING_SCHEMA_NAME in V$SQLSQL
- Oracle中User和Schema的區別和聯絡Oracle
- 11.2.0.2管理Oracle RAC One Node DatabaseOracleDatabase
- Can one execute an operating system command from PL/SQL?SQL
- Access denied for user 'default'@'%' to database 'shop'報錯Database
- user database的initial size和dbcc shrinkfileDatabase
- mysql can't connect error about privilege----not root userMySqlError
- ASM Diskgroup Can Not Be Shown When Creating Database With DBCAASMDatabase
- How to move ASM database files from one diskgroup to anotherASMDatabase
- "ScrollView can host only one direct child"問題解決View
- 11G can flush one SQL Cursor out of shared poolSQL
- Administrative User Accounts Provided by Oracle DatabaseIDEOracleDatabase
- 深入講解資料庫中User和Schema的關係資料庫
- Can Tapes Be Used For RMAN Convert Database (Doc ID 563816.1)Database
- 資料庫中Schema和Database有什麼區別資料庫Database
- 手工建立oracle示例資料庫schema (Database Examples 安裝)Oracle資料庫Database
- oracle database backup and recovery user's guide part IVOracleDatabaseGUIIDE
- oracle database backup and recovery user's guide part IIIOracleDatabaseGUIIDE
- 水煮oracle33---關於oracle中segment、schema和user區別Oracle
- oracle database backup and recovery user's guide part VII & VIIIOracleDatabaseGUIIDE
- oracle database backup and recovery user's guide part V & VIOracleDatabaseGUIIDE
- oracle database backup and recovery user's guide part I & IIOracleDatabaseGUIIDE
- AUTHID DEFINER\authid current_user與alter session set current_schemaSession
- ORACLE中的兩個概念:user和schema的區別和聯絡Oracle
- why this draw call can‘t be batched with the previous one for Unity2019.4+BATUnity
- Incorrect MEMORY_MAX_TARGET (> Available RAM) Can Lead To Database HangsAIDatabase
- can close the database Connection before the JTA transaction commit or rollDatabaseMIT