Oracle

Development proposed the need to synchronize from Greenplum to Oracle solution, wrote a script for scheduled processing.#!/bin/sh#copy_gp_2_ora. ShIf [$#-ne 1]; Thenecho "Usage:sh $ tablename"Exit 1FiTablename=$1Psql-h u \timing offSet

Cat/etc/security/limits.conf Grid Soft Nproc 2047Grid hard Nproc 16384Grid Soft Nofile 1024Grid hard Nofile 65536Oracle Soft Nproc 2047Oracle Hard Nproc 16384Oracle Soft Nofile 1024Oracle Hard Nofile 65536Eofecho "Session required/lib64/security/pam_

In the production system, due to business needs, 56 tables are emptied of 54 table data, the other two table data retention, the amount of data about 10G:1. Most people think is EXPDP/IMPDP, it is true, haha2.rman3. The following method, moveThe

OS:Oracle Linux Server Release 5.7Db:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionDatabase open mode, non-archive mode, non-current log corruptionsql> archive log list;Database log mode No Archive modeAutomatic Archival

http://blog.csdn.net/yuzhic/article/details/1896878http://blog.csdn.net/macle2010/article/details/5980965This command uses a single statement to complete updating and inserting data from one or more data sources to the table. Oracle 9i, using this

One: The simple test job creation process case:1, first create a job_test table, the field is a date formatSql> CREATE TABLE Job_test (a date);Table createdSql> commit;Commit Complete2, create a stored procedure BB action is to insert data into the

Related posts thinking and trackingThis article turns from RongerMaterialized views are a special physical table, and the materialized view is relative to the normal view. The normal view is a virtual table, the limitations of the application are

Do the system management is so, inevitably will mistakenly delete files, one day if an Oracle data file deleted, then how to recover it? (Here the database is open and not closed) Create a test table space Create a test user

The locking mechanism of OracleThe main purpose of the blockade mechanism is to control the concurrency, to block the interference and to ensure the consistency and accuracy of the data. There are three ways to block Oracle databases: Shared

This article will start with user creation, specifically about an instance of Oracle granting user rights, and it is helpful to know that Oracle has been granted user rights.These two days in the test database synchronization software, the need to

1, the command is written in one line: for example, Sqlldr sh/&[email protected]&connect_string control=&ctl_file data=&dat_file log=& Log_file Direct=yes rows=100000.2, note the file newline character, if it is wind, it is cr/lf, if it is a Mac,

AdditionSelect Sysdate,add_months (sysdate,12) from dual; --plus 1 yearsSelect Sysdate,add_months (sysdate,1) from dual; --Add JanuarySelect Sysdate,to_char (sysdate+7, ' Yyyy-mm-dd HH24:MI:SS ') from dual; --plus 1 weeksSelect Sysdate,to_char

Before using the Oracle database, I was using a MySQL database, I know that the MySQL database implementation is updated, no update, there is a statement,But Oracle's ability to do this is a moment of frustration for me, but I'm sure the Oracle

A 32-bit multi-threaded application, with many functions, similar to SQL, including variable hints and parameter passing script display, can write and run the program, using very simple, fast, good interface.Golden32 is a good helper to operate

As a development/ tester , more or less have to deal with the database, and the operation of the database is ultimately SQL statements, all operations to the end are operational data, then the control of SQL performance has become a very important

function : Intercepts the specified part from a date (date) type or interval (time interval) type.Ii. Examples :Get System Current Timeselect sysdate from dual ;Sysdate-----------2016/1/3 18To get the corresponding month-day time and minutes

must state : This blog is reproduced in Oracle foreign KEY cascade DELETE and cascade update http://www.2cto.com/database/201507/417496.htmlIn view of the previous collection of wonderful blog has been deleted, it is very sad, so still want to

Today you need to write a oracle10g backup script on an old Windows2003.IP1 is a Windows2003 system with a 10G database installed (D:dbbackup is the database backup directory), IP2 to a normal Windows2003 system without installation (D:DBBACKUP2 is

Use scenario: Convert a column value to a comma-delimited string Example: For example, query all of the table space below, now to get all the table space with a comma-delimited string (such as the time of Rman duplicate skip tablespace) SQL>Select

Determine whether the table exists before Oracle deletes the table If you delete a non-existing TABLE in Oracle, such as "drop table tableName", the following message is displayed: ORA-00942: Table or view does not exist If you execute this