Oracle

I have been writing about 12.2 sharding database for a long time, and today I started the environment again, started the host, and then started the Listener and Shardcat databases and the Shard node database instance. When checking the status of

Summary: Oracle announced the porting of Oracle 8 and Oracle Application Server at the end of last yearTo Linux. This is a clear and unmistakable sign: the whole world should realize that Linux hasis a serious operating system, enough to take on

Oracle Create, delete database LINKCreate Dblink: Create database link [name] connect to [username] identified by [password] using ' (DESCRIPTION = (address_ LIST = (address = (PROTOCOL = TCP) (HOST = [IP]) (port = [port]))

If you have an ORACLE database installed under Windows, the Occi library and header files are under the directory%oracle_home%\oci. Tools used here: VS 2005 (i) Basic settings 1. Install Oracle Instant ClientSee Posts: 2. vs-> Tools->

Keywords: Oracle numeric function-type date conversion To_char automatic type conversion Date type numeric converter other function numeric functionABS: Find the absolute value function, such as: ABS (−5) 5SQRT: square root function, such as: sqrt (2

Seven Online Rman Database backup 7.1 Online Database backup To perform an online backup operation using Rman, the database must be placed in Archivelog mode. If you are not in archive mode, Rman generates an error when you attempt an online

System Environment: Oel6.5_x86Database version:Oracle 11g 11.2.0.3.0Client environment: Windows7 Ultimate Edition x86_64First, [failure phenomenon]"Oracle Client" is installed on clients, run "tnsping enmoedu" through CMD, detect connection to

Oracle database file deleted, restore Linux deleted data file via ExtundeleteThere's a friend's client in the group today. RM dropped the data file, and then discussed the use of extundelete to recover, salvage some of the data files are not

With Oracle 12c introducing the in memory component, the Oracle database has dual-mode data storage that enables support for mixed-type applications: traditional, row-saving data meets OLTP applications, and data stored in columns satisfies OLAP

To write a rule in Excel, you only need to write rules in the table and use the Oracle Policy Modeling style to identify the type of information in the cell.So that these rules can be compiled and used in Oracle determinations Engine. You can create

How to use database development tools such as navicat for efficient development will be the focus of future work. Navicat is beautiful enough to operate a fool, and its powerful features are comparable to PL SQL. Today's study is how to use data

1 table_exists_action parameter descriptionWhen importing data using IMP, if the table already exists, drop the table before importing.When using IMPDP to complete the database import, if the table already exists, there are four kinds of processing

The supply of materials by consignment is a way for manufacturing to achieve zero inventory management. Put things in my place, when not, things or suppliers, when used, press the "installed" quantity to pay. This business model, for the

1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL developer, and note that when you install the PL/SQL developer software, do not install in the program Files (x86) directory, or PL/SQL will not start

When a record is inserted by default in MyBatis, the return value is the number of bars inserted in the record.Now you want to get the primary key value of the record that is currently being inserted after inserting the record, add the following

I. Problem Description Install RAC of 11.2.0.1 on Oracle Linux 6.1 and run the root. Sh script when installing grid. The error is as follows:   [Root @ Rac1 bin] #/u01/APP/11.2.0/GRID/root. Sh Running Oracle 11g root. Sh script...   The following

PL/SQL is an extension of Oracle's standard database language. Oracle has integrated PL/SQL into ORACLE servers and other tools, in recent years, more developers and DBAs have started to use PL/SQL. This article describes basic PL/SQL syntax,

Comparison of common functions for SQL Server to Oracle 1. Absolute ValueS: Select ABS (-1) ValueO: Select ABS (-1) value from dual 2. INTEGER (large)S: Select ceiling (-1.001) ValueO: Select Ceil (-1.001) value from dual 3. Round (small)S: Select

  For more information about Oracle patch and PSU, see my blog: Introduction to Oracle patch system and opatch tools Http://blog.csdn.net/tianlesoftware/article/details/5809526   The latest version of Oracle 10g is 10.2.0.5.4. Among them, 5 is the

1. Symptom: The code is as follows:Copy code SQL> drop user test cascade;Drop user test cascade*ERROR at line 1:ORA-00604: error occurred at recursive SQL level 1ORA-00069: cannot acquire lock -- table locks disabled for T1  SQL> conn