Oracle

Developed a solution that needed to be synchronized from Greenplum to Oracle, and wrote a script for timed dispatch processing.#!/bin/sh#copy_gp_2_ora. ShIf [$#-ne 1]; Thenecho "Usage:sh $ tablename"Exit 1FiTablename=$1Psql-h u \timing offSet

Whether the Operation BLOB field will produce a lot of redo, the answer is no , here is an experiment, the test database version is 11.2.0.1.0:--Create a table for testingCREATE TABLE Test_blob(ID number,Tupian blob);Import

Core tips:function is used to return specific data. When executing, we need to find the return value of a variable receiving function; The syntax is as follows: Create or Replace function function_name (argu1 [Mode1] datatype1, argu2 [Mode2]

1./*+all_rows*/indicates that a cost-based optimization method is selected for the statement block, and the best throughput is obtained, minimizing the resource consumption. For example: SELECT/*+all+_rows*/emp_no,emp_nam,dat_in from Bsempms WHERE

Tag: Oracle recompile user Invalid object Oracle sys User Invalid object Select owner,object_name, replace (object_type, '   ', ')  object_type,to_ char (created, ' Yyyy-mm-dd ')  as created,to_char (last_ddl_time, ' yyyy-mm-dd ')  as last_ddl_time

Content of this article Server environment Client environment Overview Start the database Close the database Add Resources This article describes the start-up and shutdown of Oracle databases, although

After successfully installing Oracle 11g, a total of 7 servicesThe meanings of these seven services are:1. Oracle ORCL VSS Writer Service:Oracle Volume Mapping copy write service, VSS (Volume Shadow Copy service) enables the creation of

There are three reasons why the Ora-12560:tns: Protocol adapter error is a problem:1. The monitoring service is not up. Windows platform: Start---program---management tools---services, open the Services panel,Start the Oraclehome92tnslistener

A certain day at noon, there are users to reflect the system problems, said the process sent abnormal, to do not disappear, to do not open and so on. Maintenance engineer began to analyze the problem, the background clearer phenomenon is the flow

Application: Known field name, querying all data tables in the database that contain the field nameAction: Specify the field name, database table user, execute the following query statement can--oracle Build query contains all data table record

1. Introduction of affairsTransactions in oracle11g are implicitly auto-initiated and do not require the user to display execution start transaction statements. However, for the end-of-transaction processing, the user is required to do the specified

ObjectiveEnvironment Description: In this experiment, the main implementation of the Rhel-based 6.5 64bit system successfully installed Oracle 11g R2 64bit, the experimental platform based on VMware VSphere. Media Download: VMware ESXi 5.5.0 (1331820

tearful his self -defined version or would you like to see that version of Sun compatible? If the former, the query view : Dba_registry, If the latter does not have to be checked, Oracle has made it very clear that: Oracle8i JVM compatible jdk1.2

CREATE TABLE mytest (name varchar), password varchar (30));Create or replace procedure Sp_pro2 isBeginINSERT into mytest values (' FC ', ' 123 ');EndViewing error messagesShow ErrorHow to call this procedure:1, EXEC procedure name (parameter,.. ）2.

Those who frequently write SQL statements should know that the main usage of Group by statements is to classify and summarize them. The following is the most common usage of Group by statements (statistics of performance by department and position ):

ORACLE Database, merge into statement, often encounter the ORA-30926: unable to get a stable set of rows in the source tables error, as shown in: After checking, this error is caused by repeated data in the data source table (that is, the table

Rediscovering Oracle's beautiful oraInst. locThe operating system version of the platform is amazing. Smart people will know it at a glance, and I will not have any code words!Oracle @ rh64 oraInventory] $ opatch lsinvOracle Interim Patch Installer

Recently, I have been studying Oracle PLSQL's series of XML operations. Combine the knowledge and references used in the work to sort out the following content: 1. How to generate an XML file:1. Use dbms_xmlquery and utl_file built-in packages

When Oracle Warehouse Builder 11.2 is installed on RHEL6.4 today, an error is reported in the last step. The following information is displayed in the log: Main. taskScheduler timer [5] 20140529 @ 12:27:55. 055: 00> oracle. wh. ui. install.

The previous blog introduced how to use the Navicat tool to back up Oracle. This blog introduced how to use the PL/SQL Developer tool to import and export Oracle databases. PL/SQL Developer is one of the main tools used by Oracle databases to import