Oracle

 How to create an oracle db Link   Known: database 1: test1; database 2: Test2Requirement: Create a DB link from database 1 to database 2 Solution 1: 1. on the computer where database 1 is located, create the service name to database 2:

Yesterday, we received guests from Beijing and showed us our new system. Unfortunately, our normal system cannot be started at this critical moment. After searching the event logs, confirm that the problem lies in Oracle, and then configure the net

10g RAC has many installation steps and takes a long time. It takes two days to install it.The following are the problems encountered during installation two days ago:1. The installation of ocfs2 is delayed for a long time. After installation,

OracleDatabase Data File Transfer Method Due to insufficient space caused by video data restoration, some data files need to be transferred to other hard disks. Based on some network materials and their own practicesOracleData File Transfer Method.

Recently, Oracle was used in a project. Due to the large database, each backup and recovery time was relatively long. In the past few days, I have successfully cloned the database by referring to a large amount of data, i'm delighted to share this

Batch Oracle operations: Syntax begin end UpperCode: Update_is_defluat 1Public Static StringUpdate_is_defluat ="Update neorule set isdefault =: isdefault {0} Where id =: Id {0}"; Front-end code 1 Dictionary String , String > Dict =

Insert into sammy_test_clobSelect to_lob (report_xml)From qm_s_reportWhere report_name = 'sammy '; To_lobFunctions andLongThere are many restrictions on the same type. To put it simply,To_lobGenerallyCreate TableOrInsert tableSubquery after

Oracle's system is too huge. For Beginners, it is inevitable that they will not start to feel like they want to learn anything, and the results will not be good. So share their learning experience, we hope that the beginners will have a general

 In Oracle, an error is often reported: the account is locked. Almost all beginners will encounter this error. In fact, the solution is very simple. Enter the User Name: System Enter the password: Admin(Note: This password is set in the first

Execution environment: it can be executed in sqlplus. EXE or DoS (command line, When dos can be executed, the \ ora81 \ bin installation directory in Oracle 8i is set to a global path, The exp. EXE and imp. EXE files in this directory are used for

Developers and DBAs have two different roles. In actual work, the two roles can help each other, communicate with each other, and jointly complete the project. But in fact, developers need some basic Oracle knowledge to make better and more

No nonsense, just like the question. View Current Database ModeConnect to the database and enter the following command: Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->SQL>

Syntax Rules: Create [or replace] trigger [mode.] trigger name Before | after insert | Delete | (update of column name) On Table Name [For each row] When Condition PL/SQL Block Note: The meaning of for each row is that in a statement

Source: http://www.askmaclean.com/archives/password-symbol.html Purpose: To supplement the http://www.cnblogs.com/AlbertCQY/archive/2013/03/29/2989764.html When managing Oracle user password security, we always use various tools to generate

In this article, the date obtained by getdate () is composed of two parts: today's date and then time: Select getdate () Use datename () to obtain the corresponding year, month, and day, and then connect them: Select datename (year, getdate () + '-'

Export text data from Oracle tables (xls or TXT) Two methods have been tested today. The record is as follows: 1. Method 1: Use the utl_file package You can export data from a table as follows: Create or replace procedure p_tabletoxls is V_file utl_

Oracle JDBC connection: OCI and thin OCI and thin are two sets of Java access methods provided by Oracle to access the Oracle database. Thin is a thin client connection method. In this connection mode, you do not need to install the Oracle client.

Faster Oracle running-Oracle 10 Gb Performance Analysis and Optimization Basic Information Author: Tan HuaiyuanSeries name: itpub Technology seriesPress: Electronic Industry PressISBN: 9787121113253Mounting time:Published on: February 1, August 201

Gains, more than OracleAuthor of basic information: Liang jingbin Liang jinhong Press: Electronic Industry Press ISBN: 9787121200700 mounting Date: April 2013 publication date: 16 open pages: 480 versions: 1-1 category: more about computers, more

       I believe that many system administrators are doing the same job every day-backing up data. Once the system fails and data recovery is required, the system is powerless. It would be nice to set a fixed time every