Oracle

How Oracle databases collect execution plans for specified SQL and resolve ORA-00904 errors during the process (Copyright statement: If your original or translated articles need to be reprinted, or if they are used for personal learning, please

Tablespace Logically, the table space can be used to plan the database structure more flexibly. Create create tablespace test datafile ‘E:\’ size 20M autextend 5M; The size is 20 MB, which is automatically expanded. Modify the default

ORA-01455: converting column overflows integer datatype The error 1455 is reported on MOS. This problem may occur during exp export. 1087122.1 introduction: "When creating a sequence with an initial value greater than 10 bits, the following problems

Recently, one-click search is required for the entire site. Normally, Baidu or Google can be used for intra-site search on the Internet. Well ~ However, the search is inaccurate. But unfortunately, I am using a Business System on the Intranet. First,

1.1. ORA-16664, ORA-16625, TNS-12537 Master database: 16664,000 0, "unable to receive theresult from a database" // * Cause: During execution of a command, a databasein the Data Guard // Broker configuration failed to return a result. // * Action:

The recent customer email description failed to connect to the database from the client with the error code ORA-12537: TNS: connection closed, and the connection was closed. Directly through tnsping, there is no problem. The TNS-12518: TNS: listener

Copy codeThe Code is as follows:Create or replace function fn_no_make (v_prefix VARCHAR2,V_table_name VARCHAR2,V_number_col VARCHAR2)/** V_prefix: Two encoding prefixes* V_table_name: name of the table to which the encoding belongs* V_number_col:

When swingbench was used two months ago, the cc user created 17 GB of test data (ccdata. dbf). After the test is completed, Because it is a test machine with insufficient space, you can directly manually run the rm-rf/Data/oradata/ora11g/ccdata. dbf

This problem is always displayed during the tnsping test. Problem Discovery: Used parameter file: \ Oracle_Client \ product \ 11.2.0 \ client_1 \ network \ adminsqlnet. ora Connect to the Client, dizzy. Solution: Change the order of the DB and

This queston came up on the Oracle newsgroup a few days ago: This issue was raised in Oracle's press center for a period of time:   I have a table (call it policy) with three columns a, B and c. The table has two rows, with column c having value

Using Oracle PL/SQL code encryption to protect the business logic is very useful in some scenarios. The following is a simple arrangement: 1. Use the Wrap command to encrypt 2. Use the dbms_ddl package for encryption Iii. Oracle encryption

Today is. Due to the analysis of deadlock, writing RAC was delayed. Today, I will write an article about the disk management log voting in RAC. Record it here.Votedisk is created because of split-brain caused by network. The voting disk is stored in

1. Instance Configuration1.1 Configure your database to record checkpoints in the alert. log file. 1.2 Ensure all user trace files are placed in the USER_DUMP_DEST location.Instance configuration: 1. Configure the database record checkpoint in the

Zookeeper Oracle standalone 10201 upgrate to 10205 1. Shut down the database: For Oracle RAC: $ Srvctl stop database-d db_nameFor Single Instance: SQL> CONNECT SYS AS SYSOPEREnter password: SYS_passwordSQL> SHUTDOWN 2.Emctl stop dbconsoleLsnrctl

Indexes are common database objects. The purpose of creating indexes is to increase the record retrieval speed. Whether or not it is set properly affects the performance of Database applications and databases. Although there are a lot of materials

Generally, rownum, that is, pseudo columns, is used to specify multiple data entries to be displayed, For example Select linename from aced where rownum However, you should note that if the retrieved data contains duplicate data, rownum cannot

Adding virtual memory in linux solves the problem of insufficient swap space Add a SWAP file: 1. view the current virtual memory [Root @ ora11gr2 ~] # Free-mTotal used free shared buffers cached Mem: 2026 217 1809 0 11 126 -/+ Buffers/cache: 78 1947

Oracleinitialization Solve the Initialization error cocould not load problem. Another problem occurs when the login interface is complete with information for logon.ORA-12154:TNS: cocould not resolve the connect identifier specified, that isThe

An old test AIX server was ignored. Recently, Oracle was full. Cleaned up. Version: Oracle 10gR2 for AIX Symptom: ? 1 2 3 4 5 6 7 SQL> alter database open; alter database open * ERROR at line 1: ORA-16014: log 3 sequence #157 not

1 2 3 4 5 6 7 ABS (x) [function] returns the absolute value of x [parameter] x, numeric expression [Return] Number [Example] select abs (100), abs (-100) from dual; ? 1 Sign (x) [function] returns the positive and