Oracle

Oracle database Chinese character ordering today needs to be sorted by one of the middle text segments of a table in the Oracle database, it would have been a simple thing, not an order by, but it was not right to find a shot, a time to feel

1. Copy standby control file from primary DB to standby DB and rename the file name and location in Stdby DB same as the P Rimary DB2. Copy password file from primary db to the standby db (keep both of them same)3. Use the Pfile to startup the

first, set the Oracle database to archive mode1) Sql>shutdown normal/immediate;2) Sql>startup Mount;3) Sql>alter database archivelog;4) Sql>alter database open;5) archive log list;Note: Show parameter log_archive_dest see where the archive logs are

ORACLE11G after you have spent a long time, you find that the disk space will be reduced, and the data is not imported, after a while you will find that there is no space for disk space, and then I find the reason is that Oracle 11G will

in theOracle Database, the Oracle system variable function is a commonly used function that shares the usage of the Oracle system variable function. There are a variety of Oracle functions, one of which is the system variable function, which

Testing for a long time, the online method is many, in fact, are wrong, the correct way of writing:Declare cursor Rowall is a select * from Tb_news where 1=1; Row1 Tb_news%rowtype; i int; Begin I: = 0; For row1 in Rowall

I. Identifying a DB instance when using database native connection databaseThat is, when you use Sqlplus to connect to the database, Oracle_sid is the one that connects to that DB instance. It has nothing to do with an instance of @Second,

Select Sys_guid () from dual;-->78ae331adb2b4ce7ab598b1317b39d58But the function has the following problem: 1 . The return type is raw 2 . No- (dash) delimiter 3 . Capitalization of letters returnedTo make the resulting UUID conform to the RFC

The SRVCTL command can control Instance,listener and services in the RAC database. Typically SRVCTL is executed under Oracle user. Let's introduce the SRVCTL command. 1, through the SRVCTL command to Start/stop/check all instances: $ srvctl

1. Parse tables and indexes (analyze does not rebuild the index )Analyze table TableName COMPUTE statisticsEquivalent to analyze table TableName compute statistics for table for all indexes for all columnsStatistics for table exist in views:

Upgrade rac10g10.2.0.1 to 10.2.0.5 Upgrade RAC 10.2.0.1 to 10.2.0.5 I. preparation: Patch package: p8202632_10205_LINUX.zip Number of nodes: 3 RAC1 RAC2 RAC3 Current node status Node 1: [Root @ rac1 bin] #./crs_stat-t Name Type Target State Host ----

Oracle left Outer Join tests For more in-depth left outer join, we did some tests. There are several forms of external join writing. We can track the final SQL conversion form through 10053. -- Initialize data Create table( Id number, Age

Oracle download and installation, oracle download and InstallationOracle download and Installation1. Official Address: Beijing. Win 32-bit operating system:

Start Oracle11g Service When running oracle, It is very resource-consuming and affects the speed of the machine. Therefore, I usually stop its services when I don't need oracle, but what services do we need to start and what do we do? The following

ORA-24247: Network Access denied access control list (ACL)Zookeeper ORA-24247: Network Access denied access control list (ACL)Note: The command must be used under the system user.You must first use DBMS_NETWORK_ACL_ADMIN.CREATE_ACL to create an

Clear the high watermark line of an Oracle tableWhen a new record is added, HWM moves up slowly, but HWM does not move down after the record is deleted. Therefore, when you use the delete from command to delete a large amount of data, the HWM may

How does Oraclecloudcontrol12c modify the sysman password? Oracle Cloud Control 12c was deployed on a virtual machine a few days ago, and the login password was forgotten. The main reason is that Oracle-related Software provides stronger security

Oracle: dump File Import error: only DBA can import files exported by other DBAs Export the dump file of a table from schepaa (DBA permission) and import it to scheab (non-DBA permission). An error is returned. Use the OB tool to set scheaa to DBA

How to update a patch (RollingPatch) in the OracleRAC Environment) The Oracle RAC database environment has many similarities and differences with the single-instance database environment. You can use opatch to update database patches. However,

From ORA-27300, ORA-27301 to ORA-00064Recently, due to the increase in the number of sessions, you need to adjust the session, that is, to adjust the process parameter. Look at is a relatively simple problem, but encountered a ORA-27300, ORA-27301.