Oracle

Then the second article http://www.cnblogs.com/myrunning/p/3996183.html4. Installing the Cluster Software 4.1 verifying the installation environmentAfter inspection, the following 3 package checks were found to have

1. Current session is validalter session set nls_date_format= " yyyy-mm-dd:hh24:mi:ss " ; 2. Permanent entry into force　　sys用户登入后运行例如以下命令 然后重新启动数据库使其生效alter system set nls_date_format= " yyyy-mm-dd:hh24:mi:ss ' scope= spfile; View

CREATE TABLE CC (Student NVARCHAR2 (2), Course NVARCHAR2 (2), score INT ); INSERT into CC Select n ' Zhang San ', N ' language ', dual union ALL Select N ' Zhang San ', N ' math ', the dual union ALL SE Lect N ' Zhang San ', N ' English ',

Here are just a few ways to introduce backup methodsBackup: Logical backup, cold backup, hot backupLogical backups are also known as import, export, which is the role of transferring data between different Oracle databasesPhysical backup, which is

To view a table in the Recycle BinSelect Object_name,original_name,partition_name,type,ts_name,createtime,droptime from RecycleBin;Recovery tableSql>flashback table Test_drop to before drop;Sql>flashback table "Bin$b+xkko1rs5k10uko9bfmua==$0" to

0. Table SpaceSql>Select Username,default_tablespace from User_users;View the role of the current userSql>SELECT * from User_role_privs;View system and table-level permissions for the current userSql>select * from User_sys_privs;Sql>select * from

1.1Descriptive narrative of phenomenaThe database node responds slowly and some of the user's business is affected.Check the database alarm log to start displaying ORA-07445 errors, followed by a large number of ORA-04031 errors and ORA-00600 errors.

1.SUBSTR: Find substrings in the parent stringSUBSTR (' HelloWorld ', 1,5)1: Represents the starting position of the substring, if positive, positive, negative, reciprocal5: The terminating position of the string, only the right number, can be

This article is original, reproduced please indicate the source.The calculation method of checkpoint lag of Oracle GoldenGate (OGG) OGG end rep ProcessBackground: The following is the display of the process of the rep of Ogg destination, at that

Pfile (parameter file) is used from oracle8i and can be used in oracle9i. It is in the form of a text file, you can use the VI and other editors to modify the database parameters. The file format is Initsid.ora. Oracle 9i establishes a pfile for

Oracle has a number of functions, which are sorted out:Absolute value of ABS (m) mMoD (m,n) m is removed after n remainderPower (M,n) m n-Th SquareRound (M[,n]) m rounded to the value of n bits after the decimal point (n defaults to 0)Trunc (M[,n])

First, ITL describes:The ITL (interested Transaction List) is an integral part of the Oracle data block, located in the block header, which consists of Xid,uba,flag,lck and SCN/FSC, Used to record all occurrences of the block, an ITL can be viewed

Points of knowledge involvedA, the use of substitution variables with a &b, substitution variable usage with two &C,define command usaged, accept command usageE, custom Sql*plus environmentF. Save custom results in the Glogin.sql fileG,sqlplus Edit

This method is a reference to one of the itpub's forumsMake a note, but also to share with you, convenient for later use, heyMethod One: Su-oracle Edit the. Bash_profile under the Oracle user's home directory. Add export Editor=vi

    This is a recovery that is performed by the system. No human management and operation is required. This method is generally used when the system fails due to sudden power failure. Automatic recovery occurs when the database is started again.    

first, after the Oracle installation is enabled by default OS authentication, the mentioned OS authentication refers to the server-side OS certification. OS authentication means that the user and password checksum of the login database is placed

MD5 encryption in Oracle and OracleMD5 Encryption I. Technical Points 1. DBMS_OBFUSCATION_TOOLKIT.MD5DBMS_OBFUSCATION_TOOLKIT.MD5 is an MD5-encoded data packet function, but an error message is displayed when select DBMS_OBFUSCATION_TOOLKIT.MD5

Introduction to Oracle System Variable Functions and oracle Variable Functions Oracle functions are diverse, and system variable functions are one of them. The following describes the three most common system variable functions, which will help you

Install and configure OracleDatabaseControl using emca on the command line interface As a loyal user of the command line, the O & M of the server software tends to be completed using commands or scripts, so it is annoying to use a large amount of

New Features of Oracle 11g Flashback Data Archive instance, 11 gflashback Flashback Data Archive (flash back log archiving) is actually used to save undo Data for a long time. For some important tables, you can customize the retention period of