Oracle

It is useful to look at the connection of the data, finish writing the program while testing the code side to see the release of database connections to help optimize the analysis of a robust system program.1. View the current number of database

Recently, the company is engaged in System server integration, I am responsible for the MES database to migrate from the original server to the new server, asked the hardware group of colleagues to the IP, account, password, began to install the

Dynamic registration: After the instance is started, Pmon automatically registers the service name into the listener per minute, or it can register the alter system register manually; The system has a listener by default ; You do not need a Listener.

First, the problem description:Wrote a stored procedure (only half, can explain the proposition can be)CREATE OR REPLACE PROCEDURE "Month_rpt_center_stu_data_proc" (Centerids in VARCHAR2) as Mlockdate date; begin/* Creator: Fengcl created: 2018.1.23

Tag: DDR Oracle command file recommended key load ISP cannotFirst, the basic conceptORACLE11GR2 RAC began to introduce the scan concept, usually through a DNS server or GNS server to resolve the scan, you can also use the/etc/hosts file to parse

One, table space 1.1 create TABLE space--Problem: Create a tablespace named HP, specifying a data file of hp.dbf, and a size of 10m.' C:\app\hp\hp.dbf ' size 10Mautoextend on next 5mmaxsize unlimited;1.2 Deleting a table spaceDrop tablespace hp;1.3

I. View employee employee Information (Query the department number ==10 and sort in ascending order by the entry time. The second is replaced by numbers)Second, sort by multiple fields (Dmpno,deptno,sal,ename,job)Third, according to the sub-string

When configuring a new database, you need to configure the listener to put some information in, find TNSNames when the changes, the file can not be saved, save the prompt to save as.Later on the Internet to find information, this phenomenon may be

First of all, of course, create the type in OracleCREATE OR REPLACE is OBJECT ( number, bid_price number, bid_publish_date DATE, bid_award_flag VARCHAR2(ten));Re-establish reference typeCREATE OR REPLACE is TABLE of

There is a feature in the project that needs to get data from an Oracle database, which was thought to be very simple, and changed the original SqlClient into a OracleClient call.The result is far less simple than you think. There are a lot of needs

[[Email protected] ~]$ DateTue Oct 14:20:56 CST 2017[Email protected] ~]$ Cat/etc/sysconfig/clock# The time zone of the system is defined by the contents of/etc/localtime.# This file was only for evaluation by System-config-date, does not rely in

--1) SQL statement for querying and locating database problems--oracle Common Performance Monitoring SQL statements. sql--1 Query Lock table informationSelect VP. SPID,Vs. P1,Vs. P1raw,Vs. P2,Vs. EVENT,Vsql. Sql_text,Vsql. Sql_fulltext,Vsql.

[Oracle] How to set event (eg:ora-00235) for a databaseWhen you use SPFILE,Setting procedure:1. Check The current event setting status:Sql> show parameter event;2. Add an event and set it up:If there is the no existing event, it is set as

In an Oracle database, you can merge fields using the wm_concat (column) functionThe Oracle Wm_concat (column) function allows us to use it frequently, and below teaches you how to use the Oracle Wm_concat (column) function to implement a field

SOURCE end: 12C RAC primay backup fileTarget side: 12C Single InstancePartial Summary:1 Pfile Modification2 Disable Redo Thread N3 Drop logfile Group N4 Rename LogFile5 Cancel Log Remote transferIf primary is in Maximum availablity mode, the control

Oracle Materialized View In actual work, multiple data sources are synchronized to a single database for data analysis. These data can not be synchronized in real time. Generally, we extract data from the statistical analysis database through

Oracle appears ora-12154 cannot resolve resolution for the specified connection identifier, oracleora-12154 I believe that people who have used Oracle databases must have encountered the "ORA-12154: TNS: unable to resolve the specified connection

Tutorial on importing and exporting oracle 11g tables with xmlType, 11 gxmltypeGeneral Export Error Toad-> database-> export-> Export Application Wizard EXP-00107: does not support features (binary xml) (belonging to column XML, table JS. TEST ).

Several examples of impd expd in ORACLE Database: impdexpd # Export by table [Oracle @ host2 ~] $ Expdp u1/tiger tables = family dumpfile = 'u1 _ family. dump 'directory = dump_dir job_name = family1 Export: Release 10.2.0.5.0-64bit Production on

Oracle dbca times: ORA-12547: TNS: lost contact error resolution, dbcaora-12547 Preface Recently encountered a problem in the work, the error is Oracle dbca reported error: ORA-12547: TNS: lost contact, by looking for relevant information finally