Oracle

The index is like the directory of a dictionary. With the dictionary directory, we can find the items we need very quickly. The same is true for databases.　 　With an Oracle database index, related statements can quickly locate the location of a

Oracle EBSGetting StartedOracle EBSFull name isOraclee-commerce Suite (e-business Suit), was in the originalApplication(ERP) is based on an extension that containsERP(Enterprise Resource Planning management),HR(Human resources management),CRMA

Object permissions refer to the right to access other schemes, and the user directly accesses their own schema objects, but if you want to access objects of other scenarios, you must have permission to the object.For example, if a Smith user wants

Issue: Win8 on a 64-bit system that uses PLSQL developer to connect to a local Oracle database can cause an inexplicable problem, and the error box may even be empty.Reason: According to the internet, the reason is estimated to install 64-bit Oracle

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.Deep Blue Blog: http://blog.csdn.net/huangyanlong/article/details/40165733We

1. Delete the primary key ALTER table TABLENAME drop primary_key Run the above SQL to remove the primary key; Assuming that the ALTER TABLE TABLENAME drop CONSTRAINTS COLUMN Cascad is not successful E --delete constraint alter TABLE TABLENAME

Oracle 10g 11g RAC installed on personal virtual machine The following is the Toggle Script command#10g RAC >11g rac****************************************###############Cat/etc/inittab >/etc/inittab10gcat/etc/inittab11g

The LAG () and lead () statistics functions are able to fetch the first n rows of the same field and the values of the last n rows in a single query . Such operations can be implemented using table joins to the same table, but using lags and leads

 When a virtual machine can connect to a native, but discovers that the remote is still not able to connect, this time to add a rule at the firewall, add the way:A: in Root LoginB: enter on the terminal Setup , configure the firewall. as follows:C

Reference: http://blog.csdn.net/oraclemch/article/details/5551634Oracle 11g Beginner's GuideHttp://www.cnblogs.com/netsql/articles/1745978.htmlOnline information are very fragmented, and most of them can not complete the requirements of the function,

Oracle stored procedure record in project-common syntax memoAn Oracle stored procedure needs to be written in a project that collects the contents of a complex query (involving multiple tables) and then inserts the qualifying records into the target

Change Oracle from archive mode to non-archive modeStart –> Run command cmd into command line mode1. Use the command Sqlplus to open the following form without logging:Sqlplus/nolog;2. Connect to the database Dev.world where Dev is the Oracle SID is

1. Oracle memory is composed of SGA+PGA2. Oracle Database ArchitectureDatabase architecture refers to the composition, working process and principle of database, and the organization and management mechanism of data in database.How Oracle Works:1),

Awr Basics1. Automatic Working Load WarehouseOracle collects a large amount of statistical information about performance and motion. This information accumulates in memory and is written regularly to the disk (that is, to the table that makes up the

1. Nvl functionNVL (EXPR1,EXPR2), returns EXPR2 if Expr1 is empty;2. NVL2 functionNVL2 (EXPR1,EXPR2,EXPR3), returns EXPR3 if Expr1 is empty, otherwise returns EXPR2;3. Nullif functionNullif (EXPR1,EXPR2), if EXPR1=EXPR2, returns NULL, otherwise

1. Create a data table space:SQL>Create tablespace rusky_data 2 'D:\rusky\rusky_ DATA01,DBF' size 10M 3on 4 Next 10M maxsize 1024m 5 extent management Local, table space created. EXTENT MANAGEMENT LOCAL: Storage area management method.

Check the information you need to focus on within two days:VI alter_error.shecho "Check Alter Error:" Cat $TRACE/alert_$oracle_sid.log | GREP-E ^ora-\| reconfig\|abort\| shut\|^start\|error\| instance\| suspend\| resuming\| Deadlock\| " ' Date '

The new Oracle table uses sequence as the insert value. The initial value is not the first, oraclesequence This problem occurs when you use oracle11g to insert data:   1 -- CREATE test TABLE -- 2 create table tbl_test (3 test_id number primary key, 4

Oracle row-to-column and column-to-rowI. Row-to-column ConversionThe following format must be set:Convert:This is the most common row-to-column conversion. The main principle is to use the decode function, aggregate function (sum), and group by

Oracleblockcorrupt Bad blocks In general, oracle's Bad blocks can be divided into two scenarios: physical damage and logical damage. The physical damage is caused by storage and other reasons. As a result, oracle finds that the checksum of the block