Rename table syntaxRename table Tbl_name to New_tbl_name [, tbl_name2 to New_tbl_name2] ... Use this statement to rename one or more tables.
The rename operation occurs automatically, which means that other threads cannot read any tables while
New Features of Oracle 11g: User rename
Oracle Data is constantly changing during project development. Therefore, we need to regularly import the development database to the test database. The common practice is "trilogy :"
1. Export data from exp
Oracle Data is constantly changing during project development. Therefore, we need to regularly import the development database to the test database. The general practice is ldquo; trilogy: rdqu
Oracle Data is constantly changing during project
Because server A cannot see the witness server W or the original mirror partner server B, you must enter the disconnected state and make the database unavailable.
Server B and Server w can compose quorum. Server B cannot see server A, so Server B
Sunday in order to save the main Library users table space temporarily expanded 20G tablespace, resulting in the DG Library's/bak/datafile/directory is insufficient. The log application to the extended-space archive crashes, and, more tragically,
Original link: http://www.cnblogs.com/Ryan_j/archive/2011/04/03/2004428.htmlRenaming a database is simple, select the database-right--Rename the databaseOr' olddb ',' newdb 'But if you create a new database with the same name, you will get an error
A case that requires renaming a database in multiuser mode has recently been encountered, because the database may be used by other users, so direct modification may fail. In this case, we can wait until all users have finished using the database,
ASM management-how to rename diskgroup
The new diskgroup rename function is added in ASM 11.2.0.1. You can use the renamedg command to rename the created diskgroup. Before renaming, you must first dismount diskgroup.
If the renamed diskgroup is
The first problem is renaming the database: You cannot rename the database directly in Enterprise Manager, you can only manipulate it in Query Analyzer
Copy Code code as follows:
Create proc killspid (@dbname varchar (20))
As
Begin
Two methods of Oracle rename data files2012-12-11 20:44 10925 People read comments (0) favorite reports Classification:Oracle (98)Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.First
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.