Oracle

Today, the second configuration of PL/SQL developer, said that the egg hurts, yesterday because moved a thing and then inexplicably can not connect the database, always show a variety ofError, I moved the thing is because the Chinese will show

Oracle Database Expert Combat training courseRecommend a set of 0 Basics video Tutorials to start learning Oracle database expert Combat trainingThe course covers four versions of ORACLE9I/10G/11G/12C.The course is 0 basics, starting with the most

Continue on the article to build a DB node, DB node construction and build a common RAC no difference, it is necessary to note that the following two points:1. Create a related directory and add two files[Email protected] ~]#

1. View all users in the current database: Select username from dba_users;2. View the user logged in for the current session: Show users or select username from user_users;3. View all tables for a user: SELECT * from Dba_tables where owner= '

Cont.: http://blog.csdn.net/bisal/article/details/392253734.10046 EventsThe execution plan for the target SQL can also be viewed through the 10046 event. Events like 10046, which are not available in Oracle's official documentation, are typically

The Oracle Database Restore IMPDP command is relative to the EXPDP command, and the direction is reversed. That is, the restore operation for the database backup.I. Knowledge of the IMPDP order　　 C:\>impdp -help Import: Release 11.1.0.7.

*********************************************** Declaration **********************************************original works, from the "Deep Blue Blog" blog, Welcome Reprint, please be sure to indicate the source when reproduced , otherwise be held

When we need to install the Oracle database on the server, we always want to maximize the performance utilization of the Linux server. Install as few other complex software as possible and install only the necessary Oracle software. In fact, however,

1. Download Oracle 11gHttp://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html2. System environmentFree-hFile mode to add swap handover partitionDD If=/dev/zero of=/swapfile bs=1m count=2048 &&mkswap/swapfile

It is divided into 5 main steps: Create an instance directory, create a password file, create a parameter file, create a library script and build a library, and create a data dictionary .Of these, special attention needs to be paid to 2 points:

Export a table dump file from Schemaa (DBA authority), Import to schemab (non-DBA authority), error.Use the OB tool to set Schemaa for DBAs (the previous tables and views are gone),On the Internet to check the following two sentences after the

Adding a NOT null field before 11g is very slow, very fast after 11g, let's do a test first and then explore the principle.Sql> select * from V$version;BANNER----------------------------------------------------------------Oracle Database 10g

Nothing to do, want to re-install Oracle 11g, recorded as follows:(1) First stop all Oracle services in the service;(2) Start, oracle-oradb11g_home1, Oracle installation products, Universal Installer, click "Uninstall Product"-"Expand All" After

The Oracle Database operations class implemented in this article for C # can perform many common Oracle database operations, including the underlying database connection, closing the connection, outputting the recordset, executing the SQL statement,

1 environmentUbuntu 12.04 32-bit system in VMware virtual machines2 Specific installation steps① Download the latest JDK packageNote that the JDK distinguishes between 32-bit and 64-bit versions and is compatible with

Oracle EBS R12 file system structure (learning and summarizing online materials), ebsr12 The file structure of Oracle EBS R12 on the server is as follows: The top-level directory is divided 1) inst --- configuration information related to the

Differences between a transaction-based temporary Oracle table under 11 GB and 12CThe transaction-based temporary tables in Oracle differ from those in 11g and 12C. After collecting statistics on the temporary tables, the former records are cleared,

Optimize data batch processing performance and batch processing performance 2014-10-04 BaoXinjian I. Summary PLSQL _ performance optimization series 11_Oracle Bulk Collect There is an overhead for running SQL statements in PL/SQL programs, because

FAL [client]: Failed to request gap sequence GAP, falgapI. Problem Description After the host where the master and slave databases are located is restarted, rac (master database) is automatically started upon startup, but the slave database (Single

ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], [], [], ora-00600kcblasm_1 This error has been shown in the alarm log for the past two days: ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [],