Oracle

By manually creating an Oracle database, you can understand the structure of the Oracle database and the database operating mechanism to help you understand the Oracle database. First, open the command line tool, create the necessary relevant

Using the SYS or System/manager as SYSDBA; Connect to the database. Create a regular user konglin:create users konglin identified by Pwd_oracle; Delete users, drop user Konglin; Grant user permission to log on to the database:

SELECT * from aa01_2014 where aaa001= (select C.P from (select Aaa001,lag (aaa001,1,0) over (order by aaa001) as p from aa0 1_2014) c where c.aaa001= ' 8a9299ec522f54f401522f81eedc0007 ');SELECT * from aa01_2014 where aaa001= (select C.N from

There is no problem with the client using tnsping, but the error occurs when using Sqlplus connection.Cmd->tnsping 192.168.56.101:1521/ORA11GR2tnsping command: If you can ping, then the client can resolve the listener machine name, and Lister has

AdditionSelect Sysdate,add_months (sysdate,12) from dual; --plus 1 yearsSelect Sysdate,add_months (sysdate,1) from dual; --Add JanuarySelect Sysdate,to_char (sysdate+7, ' Yyyy-mm-dd HH24:MI:SS ') from dual; --plus 1 weeksSelect Sysdate,to_char

This afternoon work encountered problems, I need to put the data in a table in its backup table a_1, but the a_1 table is missing two fields, so I will add two fields, but the new field will default to the last side, and table A in the order of the

As a development/ tester , more or less have to deal with the database, and the operation of the database is ultimately SQL statements, all operations to the end are operational data, then the control of SQL performance has become a very important

Start by first preparing to test if the Oracle database starts normally "is the primary Oracle-related service open"Then create a class that connects to the database with the first thing to remember is what steps are required to connect to the

The composition of the 1.shared pool (shared pool)3 Block Area: Free cache, library cache, row cacheFree Cache: Idle spaceLibrary cache: Main cache SQL statements and execution plans for SQL statementsRow cache: Data dictionary cacheSELECT * from

In Oracle, sequence is the serial number, which automatically increases each time it is taken. Sequence is not related to tables.  1. Create SequenceFirst, create sequence or create any sequence permissions.Create the following statement: 　　 create

One, sub-typeThis type is the simplest, similar type of an alias, mainly for some commonly used types of simplification, it is based on a primitive type. Such as:Some applications often use some currency types: number (16,2). If you define this type

I. View tables, fields, constraints, and annotations in Oracle1, (1) see which tables the current user hasSelect table_name from User_tables;(2) View all users ' tablesSelect table_name from All_tables;(3) View all tables including system

1 "Download on Oracle network: odp.net2 Select Download according to your Oracle data 32bit/64bit.3 "Follow the prompts to configure the Tnsnames.ora file. # alias = # (DESCRIPTION = # (ADDRESS = (PROTOCOL = TCP) (HOST =localhost)

Sometimes when you need to do a DB efficiency test, you need to simulate a lot of data. You can copy large amounts of data by executing stored procedures based on one raw data:CREATE OR REPLACE PROCEDUREProc_msw_strsql isIINT;BEGINI:=1; whileI100000

REGEXP_SUBSTR extends the functionality of the SUBSTR function, allowing you to search for a regular expression pattern string.This is also similar to REGEXP_INSTR, but returns the position of the substring, which returns the substring

Backup and restoration methods for vCSA6.0 Databases VCSA: vCenter Server Appliance is a Linux-based virtualization management platform. Unlike vCSA5.x, when vCSA5.x is used, you only need to import the OVF template, but vCSA6.x is no longer an OVF

How to manage users and redo log files during routine Oracle maintenance, and routine oracle Maintenance I. Managing Users and securityVarious Objects in db are organized and managed as users (solutions) select distinct object_type from

Execution Plan in oracle-view, The content mainly comes from reading and learning notes. The following describes the methods for querying execution plans. 2.2 view the execution plan1. explain plan2. dbms_xplan package3. autotrace4.10046 events5.1005

The basic method for installing Oracle databases on Mac OS, osoracle Basic Environment: Snow Leopard10.6.2, Oracle10.2.0.4 Open the Mac terminal and execute: sudo -i Create an oinstall group and an oracle user. Make sure that the ID of the combined

Migration of Oracle tablespace data files Migrate the data files in the user tablespace from one path to another 1. Non-system tablespace that can be offline In this EXAMPLE, we move the oracle tablespace (EXAMPLE tablespace) from D: \ ORADATA \