Oracle

Although there are a lot of Oracle Dataguard configuration tutorials on the web, it's not hard to see that many of them are using Rman duplicate, although this approach is simpler. But in a way, but also misled the beginner, although also can be

Oracle typically uses sequences (Sequence) to process primary key fields, while MySQL provides a increment for similar purposes; But in the actual use of the process found that MySQL's self growth has a lot of drawbacks: can not control the step,

#!/bin/bash # Desc: This script is used to export all table structures for a primary User: indication, field name, field type # # DECLARE variables Sid_profile= "/home/oracle/xxxprofile" table_owner= "XXX" Table_list_file=

The advantages and disadvantages of a large community, more than one m area meaningful? Table Space management technology Management is the district, the Local management table space LMT in each data file header added bitmap area management is

1.1 Nbu Backup Oracle NBU Backup Oracle Steps 1, install the NBU client on the server where the Oracle database resides. 2. Modify Oracle Backup Database script 9.1.1 Modify Backup Scripts Default script path generated after the client is

1. Settings for parameter files (1) View the dynamic parameter file SELECT * from sys.props$ wherename= ' Nls_characterset '; Dynamic parameter file: SPFile: Dynamic parameter modification in which can take effect immediately (2) Modify dynamic

In the daily database maintenance process, we will find some objects in the database (package package, stored procedure procedure, function functions, view views, synonyms ...). ) is invalidated and renders an invalid state (INVALID). Sometimes it

1. SQL Server, Access database This is all Microsoft's database, is a family, the basic operation is similar, often using the following paging statement: PAGESIZE: Number of records displayed per page CurrentPage: Current page number The name of

(1) View library information SELECT * FROM V$version (2) View character set SELECT * from sys.props$ wherename= ' Nls_characterset '; 1. Process View L Database Write process: Oracle 2438 1 0 01:39? 00:00:00 ORA_DBW0_EDWPRD L Log Write process:

Description of the phenomenon: Oracle Clusterware, Oracle cluster software introduced in Oracle 10G/11G version, if you need to reinstall Oracle Clusterware (CRS) on a server, you must first send Oracle Clusterware (CRS) Remove clean. Alarm

1. View the top 10 SQL statements with the most total consumed timeSELECT * FROM (select v.sql_id, V.child_number, V.sql_text, V.elapsed_time, V.cpu_time, V.disk_reads, Rank () Over (o Rder by v.elapsed_time Desc) Elapsed_rank from V$sql v) a where

Some points to note about Oracle compatibility with MySQL: To_char: Convert to String type :to_char (1234.5, ' $9999.9 '), result :$1234.5   To_date: Convert to date type :to_date (' 1980-01-01 ', ' yyyy-mm-dd '), result :01-1 month

Cursor (cursor) Concept Introductionis a result set (used when a query or other operation returns multiple results)Define a cursorCursor C1 is a select ename from EMP;To take a value from the cursorOpen cursor:--open C1; (Open cursor execution query)

Function 1, numeric function (1) ceil (n)Returns the smallest integer greater than or equal to n(2) Power (m,n)Returns the n-th side of M(3) Trunc (M[,n])For the M intercept operation, when n is greater than 0 o'clock, the nth bit is intercepted to

1. preusers.sh Script#!/bin/bash#purpose:create 6 groups named  ' Oinstall ', ' dba ', ' asmadmin ', ' asmdba ', ' asmoper ', ' Oper ', plus 2 users named  ' Oracle ', ' grid '. #Also  setting the  Environment#variable for oracle user. #variable

Oracle's reverse engineering refers to importing databases in Oracle, or, of course, databases in SQL Server into PD, which requires a link to a database and then reverse-engineered operations.First step: Establish a link to the

Oracle sqlplus Export Query ResultsThe results of exporting a query under Sqlplus are saved to a local SQL file, which can be used in the following ways:1. Connect database : sqlplus xmq/[email protected]:1521/DB2, Export SQL Script : set Feedback

One, configure the Oracle port on the serverEnter the NETCA command on the command line to open the related configuration default port number is 1521Second, after configuring the port, use the Telnet tool to debug the port.Enter the Telnet server IP

Syntax for adding a field: ALTER TABLE tablename Add (column datatype [default value][null/not null],....);Modify the syntax of the field: ALTER TABLE tablename modify (column datatype [default value][null/not null],....);Syntax for deleting a field:

Another space caused by the murder was also I met: in the TNSNames. Ora file in a new configuration, the configuration is estimated to be the copy of others directly pasted up, and then found that with PL/SQL connection has been an error, after the