Oracle

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,

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,

In database management, DBA may encounter insufficient disk space, which is common.-- 1. view the percentage of tablespaces in use. SQL codeSelect. tablespace_name,. bytes/1024/1024 "Sum MB", (. bytes-b.bytes)/1024/1024 "used MB", B. bytes/1024/1024

Rman is the most cost-effective oracle backup tool. Here we will make an overall learning of rman. Most of the scripts in this article are the syntax of rman commands. It is better to do experiments to be impressed. Because most databases are backed

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

Small editor in VMware Server 1.0.8 when installing Oracle RAC, encountered a PRKC-1002 error: WARNING: error while copying directory/u01/oracle/product/10.2.0/db_1 with exclude file list 'null' to nodes 'rac2 ′. [PRKC-1002: All the submitted

DECODE function: Compares the input value with the parameter list in the function and returns a corresponding value based on the input value. The parameter list of a function is a sequence of several numbers and their corresponding result values. Of

1. UPDATE nowait: query a piece of data and enable database transactions for it. If no lock is applied to the current data, the system returns the correct result and locks the current data. If the queried data is already in the transaction, the

Create temporary tablespace Create temporary tablespace test_temp TEMPFILE 'C: oracleproduct10.1.0oradataorcltest _ temp01.dbf' SIZE 32 M AUTOEXTEND ON NEXT 32 m maxsize 2048 M Extent management local; Create a tablespace CREATE TABLESPACE

When you log on to the scott user using PL/SQL Developer, enter the user name and password and report a solution error for ORA-28000: the account is locked. Solution Method 1 1. log in with an administrator ID 2. view the Users node in the tree

Recently, considering the usage of temporary tables in the writing and Storage Processes on the Database End, we still have no idea what the Database End is doing? Whether the processing method is the same as that of SQL Server, and whether there

1. InstallOracle10g r2 Software2. Install the latest oracle 10g patch. I used the patch to upgrade to 10.2.0.2.3. Run Pre-Upgrade Information Tool. It is used to analyze the operations you want to perform before upgrading to 10 Gb, such as the

ORA-01650: unable to extend rollback segmentname by NUM intablespace NAME Cause: the preceding Oracle error is caused by insufficient tablespace In the rollback segment, which is also the most common ORACLE error message of ORACLE Data Administrator.

When using sqlplus to connect to the oracle database, there are always ???? The main reason is that the language settings of the server and the client are different. In the Japanese environment, the server side is set to JA16SJIS, and the above

1. ORA-12541: TNS: No listenerCause: the listener is not started or damaged. If it is the former, run the net start OracleOraHome10gTNSListener command (the name may be different). If it is the latter, you can add a listener to the "Listener

The greatest difference between an SQL Server database and an Oracle database is the tablespace design. Oracle Database pioneered the design concept of tablespace, which makes an indelible contribution to the high performance of Oracle Database. In

DocumentIn a project, you may often encounter operations on several databases in a project. If the database type is the same, you can directly connect two databases or use the database synchronization function. If our project uses SQLServer2005 for