Oracle

--Create Target library dblinkcreate database link target library connect to account identified by "password" using ' IP Address: port/target library '; --Query created Dblinkselect owner,object_name from dba_objects where object_type= ' DATABASE

Oracle table Designhttp://blog.csdn.net/lanpy88/article/details/7580820Oracle View all tables and fieldsGet table:Select table_name from User_tables;//table for current userSelect table_name from All_tables;//table for all usersSelect table_name

1 Example of differential increment experiment1.1 Differential Incremental backupTo demonstrate the effect of an incremental backup, we made some changes to the database after performing a 0 level backup.Perform a 1-level differential incremental

First, Introduction:Oracle 9i introduces Pga_aggregate_target to automatically adjust the PGA;Oracle 10g introduces Sga_target to automatically adjust the SGA;Oracle 11g combines these two parts, introducing Memory_target, which automatically

Oracle Log ViewA Path to Oracle logs:Login: Sqlplus "/as sysdba"View Path:sql> select * from V$logfile;Sql> select * from V$logfile; (#日志文件路径)Two What the Oracle log file contains: (The number of logs may be slightly different)Control01.ctl example01

Oracle's use of the SUBSTR functionGets a string that specifies the starting position and length of the string substr (string, start_position,[length] )Such as:SUBSTR ('This is a test', 6, 2) wouldreturn ' is'SUBSTR ('This is a test', 6) wouldreturn 

1. mysql Paging query(1) Keyword: LIMIT beginindex, MaxRow(2) Example:The limit clause can be used to limit the amount of data returned by the SELECT statement, which has one or two parameters. If two arguments are given, the first parameter

The EXP export tool compresses the data backup in the database into a binary system file. Can be migrated between different OSThe Imp Import tool imports binary system files formed by exp into the database.I. EXPORT TOOL EXPIt has three modes:A.

When an in-progress DDL operation executes or references a schema object (note), the Data dcictionary (DDL) lock is used to secure the definition of the schema object, and only a single schema object is locked during the execution of the DDL

Oracle automatically acquires row and table locks for DML operations, and the type of operation determines the behavior of the lock, which summarizes the situation of the DML operation Lock: SQL Statement Row Locks Table

The DML error log is a sql*loader-like error logging feature introduced by ORACLE10GR2. The rationale for this is to transfer any records that might cause the statement to fail and put them in an error log table.The specific use is as follows:1, use

"Previous topic" column conversion 1--Introduction of Pivot and Unpivot function Implementation case1001 Lufei1001 Shanzhi1001 Namei1001 QiaobaThe implementation results are as follows:1001 Lufei,shanzhi,namei,qiaobaTypical row and column

Oracle Database Restore, how to restore a DMP file to the Oralce library  Recently used to restore data from Oracle's DMP file because there is no such information, collected on the Internet, I believe that the following information, we can

system table Space: contains data dictionary informationSysaux tablespace: Stores metadata for various Oracle applications (such as AWR operational data)You cannot change the size of a table space after you create itArea Size Management:Automatic

Restore the entire process of Oracle10g when the operating system is damaged Environment: oracle10g, operating system 5.2 The database system is under rootvg/oracle file system, The data file is under datavg/oradata File System The control file is

How to install and uninstall Oracle databases ========================================================== ============================================== ====================================== 1. If there are two files when installing the database,

Use of dbms_ SQL in oracle 1. Run the query using dbms_ SQL Use dbms_ SQL to execute the select statement in the order of open cursor --> parse --> define column --> execute --> fetch rows --> close cursor; 1. Create a team table structure, as shown

Create an oracle database, user, tablespace, and role permission setting script/* Divided into four steps *//* Step 2: create a temporary tablespace */Create temporary tablespace contract_tempTempfile 'd: \ oradata \ contract_temp.dbf'Size 50

Oracle & #160; 11 & #160; password set to never expireFollow these steps:1. Check the user's proifle, which is generally default:SQL> SELECT username, PROFILE FROM dba_users;2. view the password validity period settings of the specified profile

Trigger 2 (learning notes), trigger learning notesDML triggers (statement triggers) Triggered by a DML statement. An INSERT, UPDATE, or DELETE operation is triggered when the user executes the INSERT, UPDATE, and DELETE operations. Example 1,New