Oracle

Oracle ASM Error--ora-15033System environment:Operating system: AIX 5.3.8Oracle:oracle 10GR2 Symptom: sql> create diskgroup datafile  2      normal  redundancy    failgroup fg1 disk  '/dev/rlv_data1 '   3     4    failgroup fg2 disk 

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

Oracle's BLOB field is special, and he performs much better than a long field, and can be used to save binary data such as a sample.Writing BLOB fields and writing to other types of fields is very different because the BLOB itself has a cursor, you

Database Storage Architecture The files that make up Oracle DB can be categorized into the following categories:?Control Files:Contains data related to the database itself, which is the physical database structure information. These files are

1. Process ArchitectureThe processes in the Oracle DB system are divided into two main groups:? Running the application or Oracle tool codeUser Process? Running the Oracle DB server codeOracle DB Process(includingserver processes and background

Http://blog.sina.com.cn/s/blog_44f8b6a40100ah97.html   Sqlnet. ora, tnsnames. ora, and listener. ora files used for Oracle Network ConfigurationNote:ArticleThe content is organized by the Internet and related books, so it is only for sharing

After reading the manuscript "Oracle DBA manual" sent by eygle, I felt that the writing idea of this book was quite new. With the improvement of Database Technology automation, DBA's work value has begun to expand to a greater level. Therefore,

OracleDate type and related functions in OracleProvides many built-in date types, including the following:DateTimestampTimestamp with Time ZoneTimestamp with local time zoneInterval year to monthInterval day to second The date type is used to store

Document directory PL/SQL syntax % Type of Custom Data Type Record of composite data type % Rowtype of composite data type Summary of Oracle Extended Data Types PL/SQL syntax The PL/SQL program consists of three parts: Declaration, execution,

Use the mygeneration Automatic Generation Code tool to obtain the Database Name and data table name of all Oracle databases. The procedure is as follows:1. Set the database link string provider = oraoledb. oracle.1; Password = mypassword; persist

For stress testing, the middleware uses WebLogic 816The database version is 11.1.0.6 RAC.The stress testing tool is LoadRunner 8.0. Test a single instance and RacThe load of each node in the environment.     In WebLogicA multi-pool is configured on,

Oracle trim, ltrim, rtrim function usageThis function has two functions:First, remove spaces that everyone is familiar.Example:-- Trim removes leading and trailing spaces of a specified characterSQL> select trim ('dd df') from dual;Trim ('dddf ')----

  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

In fact, the actual import and export of Oracle Data imp/exp operations are similar to the actual Oracle data restoration and backup operations. We all know that the exp command can export relevant data from the remote Oracle database server to the

Oracle C #ImplementationOracle Text full-Text searchThe simple example is what we will introduce in this article ,. A simple example of using C # to implement full-Text retrieval of Oracle Text in. NET is designed to get a preliminary understanding

Copy a table to another table, view, and temporary table. create a new_table table with the same structure as an old_table table without the old_table record. create table new_table as select * from old_table where 1 = 0; create a table new_table

Error: ORA-16501: the Data Guard broker operation failed ORA-16625: cannot reach database solution Create configuration file DGMGRL> create configuration 'sharkdbbork' as primary database is 'sharkdb' connect identifier is sharkdb; Error: ORA-16501:

The problem occurred when installing Oracle 10g. Later, I asked my roommates to re-send an Oralce 10g Client installation package and install it. It was possible to use PL/SQL at the beginning. Later, due to work needs, an Oracle database backup was

When two concurrent transactions access the same row in the database table at the same time, there may be three problems: 1,Fantasy read: Transaction T1 reads a statement that specifies the where condition and returns the result set. At this time,