Oracle

1. What is high water levelThe high water level is the boundary line in the used and unused space in Oracle, and can also be understood as the dividing line between the data and non-data, but the data file here refers to the data file that stores

Edit the following two files to read as follows:[Email protected] ~]# Cat/etc/oratabHrdb:/opt/u01/app/oracle/product/11.2.0.3/db_1:y--originally N, changed to Y--this path is the installation path for the database[Email protected] ~]#

The use of the--oracle trunc () function/************** Date ********************/1.select trunc (sysdate) from dual--2011-3-18 today's date is 2011-3-182.select trunc (sysdate, ' mm ') from dual--2011-3-1 returns the first day of the month.3.select

Solve:(1) Conn Sys/sys as sysdba;//logged in as DBA(2) Alter user Scott account unlock;//then unlock(3) Conn Scott/tiger//Popup A Password Change dialog box, modify the password can beThe following are the steps:C:> SqlplusPlease enter user name:

1. Put Oracle's jar package for example: Ojdbc14.jar or other versionPut it under the D:\apache-tomcat-7.0.57\webapps\solr\WEB-INF\lib.2. Then create a new profile under tomcat-solr\collection1\conf: Data-config.xml, and then edit the configuration

Startup and shutdown of Oracle database under Linux1. $ su-oracle2. $ sqlplus/nolog3. sql> Conn/as SYSDBAOr is it 2,3 a sqlplus/as sysdba4. Sql> startup (generally does not need to add parameters, as long as the environment variables set)5. Sql>

Sys_guid ()-Unique indexIn Oracle, you can use Sys_guid () to generate a GUID that is equivalent to NEWID () in MSSQL.A project requires a view to build a primary key, here is an example:Ext.: http://blog.csdn.net/myfmyfmyfmyf/article/details/3769473

　　Note: Operations on Oracle should be performed as an administrator as far as possible.　　  　　 to install Oracle, let's be clear: Installing Oracle is divided into installing Oracle services and creating Oracle databases!　　Different computer

1. Order of execution:Client input SQL statementSQL statements reach the DB instance over the networkAfter the server porcess receives the SQL statementA. Parse the SQL statement into an execution plan before executingB, parsing: Consume a lot of

The bulk collect feature has been introduced for the first time in Oracle8i, which allows us to use batch queries in PL/SQL, which in some cases can significantly improve query efficiency. With bulk collect, query results can be loaded into

Shut down:1. Shutdown normalDo not allow new connections, wait for the session to end, wait for the transaction to end, make a checkpoint, and close the data file. No instance recovery is required at startup.2, Shutdown transactionalDo not allow new

Haven't written a blog for a long time. I don't know what to write.Today, let me clear a table of data, the result is clear, the system is not moving, as if the server hangs dead.Later found a half-day to find that the original is I delete data

ProblemThese two days just plsql and Oracle configuration, but in the plsql to insert data, there is a problem, the table in Plsql cannot display Chinese, Chinese cannot save, cannot output, Chinese display question mark in the table,ReasonAfter

Oracle Application-tablespace. User Name. Permission, oracle permission Although the oracle database application has few codes, it is very practical!     -- 01. tablespaceCreate tablespace tp_hrDatafile'E: \ tp_hr01.dbf' size 10 M,'E: \

Reset Oracle configuration and oracle configuration ORACLE is often pitfall. As a programmer who only needs to connect to ORACLE during development, he decided to write down these trivial things after having gone through time and time.   ORACLE

DBA problem-solving set: Learning dataWill you count? Many people may sneer at this problem, because when I was a child, my mom and dad taught us to count the stars and the sheep on the ground. Therefore, most people are the first to think: "Are you

The archive log after oracle11gw.uardfailover reconstruction is not NO longer applied.1. the archive records of the master database are inconsistent, as shown below: After failover, the bad old master database becomes a new slave database, but the

Use scripts to automatically clear Oracle archived logsBackground Because the archive mode is enabled for the Oracle database, the database cannot be connected normally due to the large space occupied by the archive log files. You need to manually

Oracle's rownum principle and usage, and oraclerownum Principle I sorted out and learned some posts from online experts about rownum: References: http://www.cnblogs.com/mabaishui/archive/2009/10/20/1587165.html For the rownum problem in Oracle, many

[To] the difference between in and exists in oracle, oracleexistsAddress: http://blog.itpub.net/7478833/viewspace-441043/Thanks to the author Differences between in and existsIn performs hash join on the External table and the internal table, while