Oracle

First step: LoginAfter root login, switch to Oracle user, enterSu OracleStep Two: ConnectUnder Oracle user, enterSqlplus/nologStep Three: Use Administrator privilegesInputConnect/as SYSDBAFourth step: Start/Close ServiceInputStartupStartup

http://kely28.blog.51cto.com/665690/1412730http://kely28.blog.51cto.com/665690/1412737http://kely28.blog.51cto.com/665690/1412962http://kely28.blog.51cto.com/665690/1412965Http://www.ahlinux.com/oracle/17395.html1. Install dependent packagesYum

Sometimes the data is dead, or no listening, do not have to restart the machine, restart the database service line, the following is the Linux boot step, did not execute under win, may also be!Taking Oracle9i as an example(1) Log in to the database

Run cmd as follows input command sqlplus/as SYSDBA---------with sys login Super User (SYSDBA) ALTER user username account unlock; ---------unlocked (must be with ";" Alter user username identified password;  -------------Change your password and log

There are two simple examples to illustrate the efficiency issues of "exists" and "in"1. Select * from T1 where exists (select 1 from T2 where t1.a=t2.a);When the T1 data is small and the T2 data is very large, the exists query efficiency is high

One, duplicate table structure and dataCreate Table as Select * from V_topic v where > to_date ('2016-01-01 00:00:00','yyyy-mm-dd hh24: Mi:ss');Second, duplicate table structureCreate Table as Select * from V_topic v where 1

Oracle Advanced Queries1 set operationUnion combining two tables to form a single tableIntersect the intersection of the same leave, not the same don'tMinus minus the previous result minus the result of the followingCREATE TABLE Emp3 as SELECT *

Query method: Like '%xx% 'Normal: SELECT * from TABLE T WHERE t.colunm like '%xx% 'Optimization: Using INSTRSELECT * from TABLE T WHERE INSTR (t.colunm, XX) >0At the time of execution, the execution plan shows that the consumption value, IO value,

Oracle's production libraries are all launched in archive mode, and the same is true for non-archived switches and single instances under RAC, both in the Mount mode and in the ALTER DATABASE Archivelog/noarchivelog command. The difference is that

Recently encountered a server using the Oracle database, in the Mad learning oracle+ to consult a master after finally got the site management interface of all user passwords, I found that Oracle operation is too troublesome, for the sake of the

Today help others solve the problem, about Oracle, suddenly feel that should be a note, friends can see. Here is the detailed configuration:1. First locate the attached configuration net Manager at installation time in Oracle, open it, and configure

There may be people who don't use the Oracle database for a long time, and then, in turn, they'll find that they still forget the password ...Here is a workaround after forgetting your passwordFirst of all, you open the database with the SYS or

When importing data today, the database throws an exceptionBaidu a bit, the most common reason to operate at the same time, someone truncate TABLE, and then in the Select table caused.Put the error in the group, immediately someone came out to

Using node to connect Oracle It takes a little time to install the environment for those of you who have just started the node project or used MySQL

First of all, the installation of Orcale should be very simple, installation is not good only familiar with some of the problems encountered in the record, if later forget can also look.The first biggest problem is installing the client when

We know in Oracle that we are able to use a skip Index Scan (index SKIP scan). However, there are some limitations to the use of a skip-index scan.CREATE TABLE test as SELECT ROWNUM a,rownum-1 B, ROWNUM-2 c,rownum-3 d,rownum-4 e from all_objects;sql>

Open Database Configuration Assistant Next Select "Advanced Mode" next Choose the type of database you are creating (typically select Data Warehouse)(general purpose or transaction processing?:?thatOLTP(online transaction processing). The

The beginning of the study, I am a bit stupid, originally wanted to use Oracle VBox, installed a red hat+oracle, but the virtual machine has been error, 0x00000000 memory can not written. So think of other ways, just contact Golang, and then know

GROUP BY group--Number of jobs per job from the EMP group by job;--How much work select COUNT (coutn) from the EMP group by job;--the maximum wage for each job select M Ax (SAL) from EMP Group by job;--minimum wage per work Select min (sal) from EMP

Calling external C dynamic library functions in OracleIn order to shorten the development time, the project must call the C program that has been developed externally in Oracle.I found some posts on the Internet and summarized the article based on