Oracle

Does Oracle support symbolic links under the RDBMS HOME (symbolic links)?Reference text:Does Oracle support Symbolic Links in the RDBMS home? (Doc ID 813116.1)Suitable for:Oracle server-enterprise edition-version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 1

Two days ago a friend in QQ Group asked a question, the background is as follows:After continuing to ask, there are the following replies:1, the other side of the server connection no problem.2, from the client can telnet server 1521 port. 3,

Oracle ERP System Loan Relationship TableSummary of accounting information of costingAccording to the source type of the transaction is summarized.First, the procurement received warehousing and return:1. Receive: Borrow: Material purchase (order

When we want to see the DDL of a table or table space, we can use the DBMS_METADATA.GET_DDL package to view it.Detailed parameters of the GET_DDL function in the Dbms_metadata packageThe GET_DDL function returns the DDL statement that created the

The World Cup is the world each country in the football field the most coveted sacred glory, which national football team can get the champion, is the world first of the justified, and the whole worlds will be crazy boiling. The player who plays

Oracle Easy Interface ToolBackground: I work on a remote machine, I need to call data to the Oracle 11g server, the Oracle client is already installed on the remote machine, but neither SQL Plus nor SQL developer and PL SQL developer are available

9.8. Data Type Formatting Function PostgreSQLThe Formatting Function provides a set of effective tools for various data types (date/time, integer, floating point, numeric) convert to a formatted string and, in turn, convert from a formatted

Reprinted: http://www.cnblogs.com/gkl0818/archive/2009/02/25/1397769.htmlOracle collectionsI. Types of Collections1. associative arrays ArrayIt is a one-dimensional, borderless sparse set of the same type and can only be used for PL/SQL.DeclareType

How to install fedora 15: Day 1 Method 1: Use ultraiso to directly write ISO to the hard disk image .. The result cannot be started. Method 2 Use liveusb-creator The 64-bit live CD cursor of Fedora remains in the upper left corner forever. Unable

  How to quickly find the lock wait in the Oracle database In a large database system, to ensure data consistency, the system locks data when operating the data in the database. These locks include read-only locks, exclusive locks, shared exclusive

Oracle DBA manual-database diagnosis cases and performance optimization practices (planned by guobiao) Pricing: ￥59.80 Member price: ￥44.85 (off) Example of this book free trial: http://www.china-pub.com/196286 [Basic Information]Author: Editorial

Oracle Advanced Training Course 1st learning notes revised the page number in this course notes corresponds to Oracle9i Database Management Basics II ed 1.1 vol.1.pdf Guide: http://blog.csdn.net/magus_yang/archive/2006/10/10/1328283.aspx Author:

  ORACLE 10 Gb installation in LINUX: First, two images are shown:         DBA is the direction of hard work. ORACLE DBAs are all-embracing. Even LINUX/UNIX cannot be used. It also makes p oracle.   Two parts: 1. red hat enterprise linux 5

In Oracle databases, user permissions are divided into two types (here we do not discuss the permissions of dba or role, but only the permissions of common users ), system Privilege System permission and User Table Privilege User data Table

Configuration process of maximum performance mode of physical volume uard Master Database Host edbjr2p1 Slave Database Host edbjr2p2 1. Create a master database [Root @ edbjr2p1 ~] # Xhost + Access control disabled, clients can connect from any host

There are many ways to connect to the Oracle database. The following describes how to connect to the Oracle database through the OCI8 interface. It is helpful for you to learn how to connect to the Oracle database. If you have the PL/SQL program,

The Blob field in Oracle is special. It has much better performance than the long field and can be used to save binary data such as sample slices.Writing Blob fields is very different from writing other types of fields. Because Blob itself has a

Oracle databases perform detailed operations on date data. The expression of date data involves the system time zone and time format. Oracle system functions such as to_date ('string', 'format') and to_char (Date, 'format') are often used. Therefore,

Fine-grained auditing (FGA) is introduced in Oracle 9i. It can record SCN numbers and row-level changes to recreate old data, but they can only be used for select statements, not DML, such as update, insert, and delete statements. therefore, for

Problem description: when creating a view under the scott user, an error is reported: the permission is insufficient.(Other users and so on)Solution:Log On As A dba user[SQL]Copy codeThe Code is as follows:Sqlplus/as sysdba Grant scott the