Oracle

1, sys and system user differences The system user can only log on em with normal status. SYS user has "SYSDBA" or "sysoper" permission, landing em can only use these two identities, can not use normal. "Sysoper" permissions, which are database

1. Create a test table and insert a piece of dataSql> CREATE TABLE test (id int);Table created.sql> INSERT INTO test values (1);1 row created.Sql> commit;Commit complete. 2. Create a function, used to delay, to this function will be circulated here

If you manage some application projects under the Oracle database that have a large number of modifications to delete operations, data indexing needs to be periodically rebuilt. It can not only improve query performance, but also increase the

In Oracle, indexes and tables can be partitioned as well. There are two types of partitioned indexes, local partitioned indexes (locals), and global partition indexes (globally). 1. Local Index The local partitioning index is created with a local

To improve performance, we have tried a number of ways or scenarios that the Oracle database itself has provided, mainly including: Shared server mode (MTS); Cluster technology (clustering) RAC; Partition Parallel processing (mainly parallel

Use ORADBI to read multiple files stored in a BLOB field and restore to a specified path. Here's the complete code: // //READ_BLOBFILE.C-Read the blobfile example //cheungmine@gmail.com////Memory leak detection //Place the statement where needed

The three states of the database have similarities, and here's a quick summary. This article describes the state of Quiesce. RESTRICT, Quiesce and Suspend (i): When the database is in the QUIESCE state, only the DBA session can operate, and the

Oracle 8.1.7 for RedHat Linux 7.2 installation process 1). Confirm that you have installed the following compatibility packs:RPM–IVH compat-libstdc++-6.2-2.9.0.16RPM–IVH compat-glibc-6.2-2.1.3.2RPM–IVH compat-egcs-c++-6.2-1.1.2.16RPM–IVH compat-libs-

As you know, there are times when it is necessary to terminate all Oracle processes (process) or a specified set of Oracle processes. When the database is "locked" and you are unable to enter Server Manager to "gently" terminate the database, you

1, Application development (application Development) Sql*plus E:\Oracle\Ora81\BIN\SQLPLUSW. Exe 2. Database management (DB administration) DB Configuration Assistant Database Configuration Assistant: Creating, configuring, and deleting Databases DBA

1. Automatic growth of data type processing MySQL has an automatically growing data type, and the data value is automatically obtained when you insert a record without manipulating this field. Oracle does not have an automatically growing data type,

DCBA a new discovery last week that, in oracle10g, Oracle behaves differently than before when rebuilding a stored procedure. In Oracle9i, Oracle also needs to recompile the process even if a completely identical process is rebuilt, as can be seen

To understand the Oracle architecture, you must first understand two basic concepts: databases and instances.One: DatabaseA database is a collection of data.Whether the database is in a relational or object-oriented structure, the Oracle database

1. Installation of Oracle 10g R2 software2. To play Oracle 10g the latest patch, I'm playing a patch to upgrade to 10.2.0.23. Run pre-upgrade information Tool. It is used to analyze some of the things you need to do before you upgrade to 10g, such

1. Choose the appropriate Oracle Optimizer There are 3 Oracle optimizer types: A. Rule (rule-based) b. Cost (based on costs) c. CHOOSE (optional) Set the default optimizer to pass various declarations of optimizer_mode parameters in the Init.ora

There are many applications, just started with the MySQL database can basically achieve a variety of functional requirements, with the increase in the number of users, data, MySQL gradually become overwhelmed by the situation: the connection is slow

In real-world database applications, we often encounter the problem that a user who connects to an Oracle database does not have a subsequent operation after an operation, but is disconnected from the database for a long time. For a small

Execute a pair of billing program, the old execution to half of the time error, the author has not yet to print out Oracle error, just printed his own can understand the error hint, after the revision code, the Oracle error, put_line out, found to

There are no exp_full_database roles, and the following error occurs: Ora-31631:privileges are required Ora-39149:cannot link Privileged user to non-privileged user Sql> CREATE DATABASE link Pdbl connect to Rman identified by Rman using ' catalog

Some time ago in a migration of data pump and exp, found that the difference in efficiency is quite large. Here is an example of a simple comparison. This article discusses the effect of parallelism on the export of data pumps. Write a few