alter database rename

The oracle documents are not completely translated. If needed, I will add them one after another. Understand the initialization parameter file of oracle10gWhen an oracle instance is started, it reads the initialization parameters from an

1. delete a tablespace Drop tablespace TableSpaceName [including contents [and datafiles]2. delete a user Drop user User_Name CASCADE3. Notes for deleting a table When deleting all data in a TABLE, the truncate table name must be used. Because when

When you perform a Sun Cluster dual-host switchover, unexpected power failure, or other situations, the shared disk may sometimes fail to be mounted. You need to use fsck to repair the shared disk. After the restoration is completed, the database

Oracle11 tablespace dbf File migration, oracle11dbf When the disk space of the oracle data file is insufficient or the dbf file needs to be migrated to another location in other cases, the procedure is as follows: 1. sqlplus sys/sys as sysdba 2.

I did not know much about the remote restoration of the RMAN backup database. When I went to Shangguan technology to attend lectures last Saturday, teacher Zhang lie is talking about RMAN backup, so he has recovered a lot of memories and understood

Oracle redo log file (Code instance), oracle Log File 1. query information about the redo log file group. select group#,sequence#,members,status,archived from v$log; 2. query the information of the redo log file select group#,type,member from

1. Configure the database to run in ARCHIVELOG Mode Before ORACLE 10 Gb, you must start the arch process after placing the database in Archivelog mode. Set LOG_ARCHIVE_START to true, or start the arch process. In This method is not required after 10

-- ==================================== -- Backup and recovery of read-only tablespace -- ==================================== I. Features of read-only tablespacesUse read-only tablespace to avoid frequent backup of static dataWhen alter tablespace

  ① ASM file conversionTake the created asmtest tablespace as an example.(I) convert OS files to ASM files sys@ORCL> create tablespace asmtest datafile size 10m;Tablespace created.sys@ORCL> alter tablespace asmtest offline;Tablespace altered.[oracle@

Once all the datafiles were on one disk, resulting in a dramatic increase in Io. Now we divide datafile into three hard disks (due to the large data size, we only consider dividing the data equally without moving the index ). 1. First view the

This article is well written. I have made it very clear about the Oracle background principles. The 10 Gb I have installed on a virtual machine is the most common problem that clients cannot connect to the server, I have benefited a lot from this

It is inevitable that dbname and dbid need to be modified during work, such as restoring the database to the same machine. However, dbname and dbid are one of the important symbols used to identify the database, especially dbid, which is unique.

ArticleDirectory I/O busy High CPU load Query Plan Analysis Optimization Method: Sqlplus settings: Query plan settings Online Performance Optimization System performance I/O busy I/o hotspot files and SQL analysis and

Confusing terms:Db_name:The unique identifier of a database (Oracle database), which is the Oracle database described in Chapter 1. This expression is sufficient for a single database, but with the popularization of distributed databases composed of

Oracle Database transfer from server A to server B Sometimes we encounter such a situation where the existing database needs to be transferred from one machine to another. Generally, we use export and import. However, if the database contains a

Oracle 11g tablespace dbf File migration When the disk space of the Oracle data file is insufficient or the dbf file needs to be migrated to another location in other cases, the procedure is as follows: 1. sqlplus sys/sys as sysdba 2. shutdown

Global_name and db domain in Oracle 1. YouConnect ToSALES.US.EXAMPLE.COMAndQuery the GLOBAL_NAMEDataDictionaryView ToDetermineCurrent DatabaseGlobal name: CONNECTSYSTEM@Sales.Us.Example.Com SELECT * FROMGLOBAL_NAME; GLOBAL_NAME ------------

Command for viewing logs:1. view log member informationSQL> select group #, member, status from v $ logfile order by group #;2. view the log group information and the currently used log GroupSQL> select * from v $ log;3. Add a log GroupSQL> alter

1. What is bad database blocks? First, let's take a rough look at the format and structure of the database block-The database data block has a fixed format and structure, divided into three layers of cache layer, transaction layer, data layer. When

Databasename: refers to the name of the oracle database, which uniquely identifies a database in a domain. The database name is specified by the db_name initialization parameter. Database name: refers to the name of the oracle database, which