Oracle

Today, installing Oracle10.2.0.4 on the Dell server's Redhat 6.4 and logging into the database with Sqlplus, you will receive the following prompt:Map size mismatch; Abort:success, but the other functions are normal, just have this

1. Enter the menu file-reverse engineer-database ...2. Open the window, select the database version, click "OK"3. Open the window and select Usering a data source:4. If there is already a DCP file, click OK directly, if not, select the Select File

First, Oracle--Create TABLE test ( ID varchar2 (+) primary key not NULL, sort number, name varchar (200))--Field annotated comment on C Olumn test.id is ' id '; Comment on column test.sort is ' serial number ';--table plus comment comment on table

Build Oracle DataGuard (using Rman Backup)Operating system: Windows 2008Database: 11.1.0.6I. Information collection1. Configuration information CollectionDescription Host name IP address db_name SID db_unique_name Service_NameMain Library DG1 192.168

Directory (?) [-] Basic process Create an Order Pick Release Pick Confirm Ship Confirm Deliveries Interface Trip Stop-srs Workflow background Process AutoInvoice Closing the Order Ordershipping

SQL statement for querying and deleting duplicate records1, look for redundant records in the table, duplicate records are based on a single field (Peopleid) to determineSELECT * from Peoplewhere Peopleid in (select Peopleid from People GROUP by

Some simple command comparisons for Oracle and MySQL1) sql> Select To_char (sysdate, ' Yyyy-mm-dd ') from dual;Sql> Select To_char (sysdate, ' Hh24-mi-ss ') from dual;Mysql> Select Date_format (now (), '%y-%m-%d ');Mysql> Select Time_format (now (),

/DEV/SHM The Oracle instance should be set to start without reporting ORA-00845From: Ora-00845-which value FOR/DEV/SHM is needed to startup database without ORA-00845 (document ID 1399209.1)Suitable for:Oracle Database-standard edition-version 11.1.0

Oracle Data Access Component (ODAC) Full name: Oracle Database Access ComponentsPros: Because Microsoft will deprecated System.Data.OracleClient.dll in. NET Framework4, and in terms of access efficiency and speed, System.Data.OracleClient.dll

Basically, Oracle introduced dual as a syntax-compliant1. We start with the name, dual is not an abbreviation, itself is the complete word. Dual noun means logarithm, when doing adjectives refers to two heavy, two yuan.2. The dual table in Oracle is

Common analytic functions:1. First,last--Suppose A: = min (bonus) Keep (Dense_rank First Order by salary)--Assuming that the minimum wage is 1000,a for employees who are equal to 1000 of the wage, take the minimum bonus--Suppose B: = min (bonus)

The environment is as follows: #注意是SLES1 cat /etc/suse-2 (x86_64)341 5 6 7 Linux.x64_11gr2_database_1of2. Zip 8 Linux.x64_11gr2_database_2of2. ZipA systematic article1. When installing the system, select1 "Oracle Server Base" 2 "Compiler and

The SGA contains components: Component Name Description Parameters Buffer cache Storing copies of data read from a data file that can be shared among all users Db_cache_sizedb_keep_cache_sizedb_recycle_

Today there is a problem with the operation of XML format data in Oracle.Problem record: The requirement is clear that the field type is XmlType, to do is to resolve the field, but because of the database designer's problem, some tables in the field

Pl_sql: With branching and looping, process orientedAnonymous BLOCK:Declare (optional, where various variables and cursors are declared)Begin (necessary, start from here)Exception (executed after crawling to an exception)End[SQL] View plaincopySet

Use a. NET application to connect to the Oracle database. netoracle Recently, I was asked by my friends, "Why is there always an error in connecting the. NET application to the Oracle database ?", I think this is because we usually use Microsoft

Common commands and functions of Oracle SQL * plus, oracleplus Common commands and functions in Oracle are sorted out for future use for convenient reference.Common commands: Connect to sqlplusRun cmd in the command line to enter. For example, to

Tutorial on installing and starting or disabling Oracle databases in Linux, linuxoracle 1. preparation: df -H Check space remaining. Generally, prepare at least 5 GB 2. view the swap partition size du -sh /tmp/ Minimum 400 M 3. Create a

Optimize Big Data Table query and data table Optimization 1: Index, the first thing we think of first is creating an index. Creating an index can multiply the query efficiency and save time. However, if the data volume is too large, simply creating

When Oracle is not installed on the computer, C # Calls oracle database and Oracle customer tools, The installation packages of Oracle are usually relatively large and time-consuming. If errors occur during the installation process, the installation