Oracle

The permission system of Oracle database is divided into system permissions and object permissions. System permissions (Database system privilege) allows users to perform a specific set of commands. For example, the CREATE TABLE permission allows a

Bulk gets the number of rows per child of the specified partition table! Otherwise manual inquiry too troublesome! ---View the number of rows per child of a specified partition table Create or replace procedure show_tabparcnt (Partiton_tablename

Oracle installed by using the OTK tool does not configure EM by default, and the configuration and startup process is documented below! First create EM, and execute the following command $ emca-config Dbcontrol Db-repos recreate I ran the following

Export mode There are 5 export modes that are mutually exclusive and cannot be used at the same time, noting that some schemas are not exportable, such as SYS, Ordsys, and Mdsys. Full mode Set Full=y (default = N), export whole library, example:

Today, we need to create a 24*7 production library of a DG physical standby, requiring the main library can not be shut down, initially thought impossible, and later checked the document, the original through the Rman Duplicate command can be

1, first set oracle_sid=manual 2. Create a password file Enter/u01/app/oracle/product/10.2.0/db_1/dbs directory, execute command to create database password file [Oracle@myorcl dbs]$ orapwd file=orapmanual password=oracle 3, create the desired

Control file Diversity: Copying multiple control files and putting them on different disks. 1, the use of SPFile diversified control documents 1) View Control file information and spfile information 05:55:48 sql> select name from V$controlfile;

1, instance function: For managing and accessing the database. 2, init parameter files: Manages instance-related startup parameters. Location: $ORACLE _home/dbs 3, Pfile: Static parameter file. (1) A text file that can be modified by an editor.

1. Warning Files: Alert file To record commands and results for major events in the running of a database file Alertlog is a special kind of trace file, each database has a trace file, synchronization records the database messages and errors.

The password file, or password file, is used to authenticate users who manage through the network. 1. Local connection By default, whether the instance is started or not, the database server local user logon to the database is validated by the

1, store all things log. Redo the two concepts of the log, redo the log group and redo log group members. There should be at least two log group files in a database, one group written and then another, which is written in turn. There is at least

Auditing is the monitoring and recording of the data activity of the selected user. Audit operation types include logon attempts, object access, and database operations. The audit records include information such as the audited operation, the user

Oracle has a number of views built into the SYS user scenario that we can use to easily view system-related information. We can call these views without schema, and here are some Summary of views about user, role, and permission information: (1)

Profiles are used to limit the system and database resources that are used by users and to manage passwords. If you do not specify a profile when you create a user, The default profile will be used. 1. Create profile by using the "create" Profile

First, users 1, the use of SQL to create the user's syntax format is as follows: Create user user_name--username/ [identified by password | externally | Globally as ' external_name ']--how to authenticate the user , the authentication

1, the role of statistical information Oracle's CBO optimizer relies heavily on statistics when generating execution plans, you can interpret the CBO as a complex mathematical model, and statistics is its primary input, the execution plan is output,

1, the principle of lock (lock) Locks in Oracle are often business-level issues, and locks are designed to ensure database consistency in concurrency, so there is no lock without concurrency. There are several principles for Oracle locks: The rows

The ANSI-defined transaction ISOLATION level standard (http://blog.csdn.net/u010415792/article/details/8977635) is mentioned in the previous article, but different vendors implement the same approach. This article mainly introduces the transaction

--New test table Create Tablespace Test DataFile ' E:\APP\ADMINISTRATOR\ORADATA\ORCL\test01. DBF ' Size 500m Autoextend on Next 100m MaxSize Unlimited Extent Management Local Autoallocate Segment Space management auto; CREATE TABLE T1 (

Beijing time September 16 morning news, according to foreign media reports, market research company Global Equities study analyst Tripp Chodri (Trip Chowdhry), in order to make the acquisition of Sun's plan won the EU antitrust regulator approval,