Oracle

The SYS user logs in as a DBA under CMD: Run sqlplus/nolog in CMD. Then Conn/as sysdba // Create a temporary tablespace  Create temporary tablespace user_temp Tempfile 'd: \ oracle \ oradata \ Oracle9i \ user_temp.dbf' Size 50 m Autoextend on Next 50

Migrate the OCR and VOTEDISK environments in 11g Rac: OEL + oracle rac 11.2.0.3 migration Description: migrate ocr and votedisk from + DATE to + OCR_VOTE. The operation is as follows: [root@ora2 ~]$ /u01/app/11.2.0/grid/bin/ocrcheckStatus of Oracle

Oracle completely restores SYS @ orcl # shutdown abort from the backup control file; the ORACLE routine has been disabled. SYS @ orcl # oracle @ oracle :~ /Product/10.2/db_1/dbs> rman target/recovery Manager: Release 11.1.0.6.0-Production on

Oracle insert into syntax Basically, we have two ways to input data into the table. One is input at a time, and the other is input at a time. Let's take a look at the input method. Follow the Convention to introduce the syntax first. Syntax: Insert

Oracle Text (full-Text search) View database tutorial Information select * from nls_database_parameters1. Simple Application1.1 to use full-text search, the current ORACLE user must have the CTXAPP role -- Create a user-- Create user textsearch

This article briefly introduces the usage of oracle to_char () function. If you need to learn it, please refer to it. Oracle/plsql of the TO_CHAR function, which converts a number or date to a string. The syntax of the to_char function is:To_char

This article briefly introduces how to format SYS_GUID () in oracle to a standard format. If you need to learn more, you can see it. In Oracle, RAW (16) is used to save SYS_GUID () results, but the byte order is different from the standard GUID. As

This article analyzes the ORA-01031 error caused by SYS Local login or remote login, but also provides a ORA-01031 error solution, have encountered the same problem of friends can refer to the solution. if the database instance is installed on

This error is often in the database recovery, often encounter the following ORA-600 6002 error, which is a common, can be analyzed to eliminate one of the errors, Next let's look at the solution. The following are recent errors in user data recovery:

This article describes how to implement the ORACLE decimal and binary conversion functions. Decimal conversion binary The Code is as follows: Copy code Create or replace function NUMBER_TO_BIT (V_NUM NUMBER)Return varchar is

When installing oracle, If we installed oracle in English, there was no problem, but I wanted to install the Chinese language. As a result, the Chinese interface was garbled, later, I found the reason why I had to install a Chinese package. I will

This article will share with you an example about how to export and export oracle OID/LDAP users (groups). If you have any questions, please do not go to the reference page. OID users have some attributes that cannot be operated, such as

Date functions will be used in almost all databases. Next I will introduce some detailed instructions on the use of Sybase date functions. For more information, see. -- Date-related functions-- 1.day( date_time) returns an integer that represents

This article will introduce you to an oracle physical volume uard rename data file. I hope this method will be helpful to you. I will not introduce it here. We know that when STANDBY_FILE_MANAGEMENT is set to AUTO, if the primary database creates a

Requirement: the database contains two tables with different structures. Partial fields of the two tables need to be synchronized in real time. Implementation solution: Create a trigger for synchronization on the two tables respectively. However,

I. Definition Two bytes and one Chinese character, such as "of"; two full-width punctuation characters; one half-width punctuation character; one letter and one byteA character refers to a letter, a word, a punctuation mark, or a symbol. It may not

During the project deployment, the ORACLE client will encounter the "System. Exception: System. Data. OracleClient requires the Oracle client software 8.1.7 or later" issue multiple times. Solution ):   Note: The ORACLE_HOME directory does not

The project requires special handling of military ID card, as long as the digit. I wanted to use a regular expression, but oracle9i does not support regular expressions. Later, we found that translate can implement functions. Translate (string,

Today, I checked the alter _ . log of the ERP DB server and found an error. Sat Sep 14 14:49:42 CST 2013Error 2068 trapped in 2 PC on transaction 47.12.104933. Cleaning up.Error stack returned to user:ORA-02068ORA-03135 ERPSALES indicates that

Change the oracle user name Previously there was a need to organize a schema table, index, and so on into a tablespace, and use expdp/impdp to complete the remap, but the user name remap changed, if the application does not want to modify its