Oracle

ORACLE11G has more than one installation disc:File name DescriptionP102025301120--linux-x86-64_1of7.zip Database installation mediaP102025301120--linux-x86-64_2of7.zip Database installation mediaP102025301120--linux-x86-64_3of7.zip Grid installation

At first, I thought I was going to unzip. Inadvertently see a blog, understand the meaning of the compressed package. Ha haORACLE11G has more than one installation disc: Description of File namep102025301120--linux-x86-64_1of7.zip Database

the neglected Oracle User-owned groupChongqing days, Heat can't stand, still in the heat wave, a brother to call, tell a single instance database new Field operation, has been stuck there, do not go on. Because you are busy talking about things,

Assign the"Create Global Objects" User Right ToThe Non-administrator account.1.ClickStart,PointToPrograms,PointToAdministrative Tools, and ThenClick Local Security Policy.2.Expand Local Policies, and ThenClickUserRights Assignment.3.

The difference between Pfile and SPFilePrior to Pfile:oracle 9i, Oracle has been using Pfile to store initialization parameters, which are text files that can be modified at the operating system level. You can use Pfile file to start a database when

1. Download the Bcpserver and open the virtual machine via VMware Workstation2, vim/usr/sbin/workstation.list Modify the configuration file, the corresponding IP and Mac bindings, this program can only write the first 90 IP3. Botang-create-dhcpconf

The dual table is a virtual table that is used with the SELECT statement.1. View Current UserSelect User from Dual2. Used to call system functionsSelect To_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss ') from dual----get current system timeSelect

Problem:When installing 11.2.0.4 on Redhat 7:Error in invoking target ' agent NMHS ' of makefile '/u01/app/oracle/product/11.2.0.4/sysman/lib/ins_emagent.mk '.Workaround:In $ORACLE _home/sysman/lib/ins_emagent.mksearch for the line: $

1. Delete from T2. TRUNCATE TABLE TDifference:1. Delete is a DML operation; Truncate is a DDL operation and DDL Implicit commits cannot be rolled back2, delete from T can be rolled back, TRUNCATE TABLE t can not be rolled back3. TRUNCATE TABLE T

1: First the table in the database must be 2 of the tree structure:super_department_id For department_id The parent node number 3: The following statements are executed as a result:department_id = 88 records for all byte points and child

This post was last edited by Tsengyia on 2012-2-22 17:06Solve the problem of Chinese garbled when installing Oracle under LinuxOperating system: Red Hat Enterprise Linux 6.1Databases: Oracle Database 11g R2Method One: Evade the law, use English

In Oracle, this is not unfamiliar with the LOGMNR tool analysis log, which is often used for data recovery scenarios, where it is convenient to analyze archived logs;Of course, there is a LOGMNR interface tool on the Internet; the download requires

--Identify SID namesSELECT * from v$access where object = ' Pkg_smssend_proc ';--Using SID to isolate SPIDSelect Spid,osuser, S.program from V$session s,v$process p where s.paddr=p.addr and s.sid= (select SIDs from V$access wher E object = '

--view (can view owner, object name, creation time, last modified time)SELECTT.object_name, t.created, T.last_ddl_time fromUser_objects TOrder byT.last_ddl_timedesc;SELECTT.owner, T.object_name, t.created, T.last_ddl_time fromall_objects

Zysong.ttf Download is an Oracle font garbled resolution tool, in essence, the lack of Chinese font package!01 Examples of the situation02 Examples of the situation01, in the beginning of the installation of garbledDownload Zysong.ttf,unzip

1. Sub-query to solve the problem: not one-step solution2. Issues of attention2.1 Brackets2.2 A reasonable writing style2.3 can be used in the where select have from2.4 You cannot use subqueries after GROUP by2.5 Emphasize the word query from the

Use the Xshell tool.Log in as root:[Email protected] ~]#To view (Oracle related) process status:[[Email protected] ~]# PS Aux|grep OracleOr[Email protected] ~]# Ps-eaf | grep OracleKill Process:[email protected] ~]# kill-9 13118Log on as an Oracle

View the lock table process SQL statement 1:Select Sess.sid,sess.serial#,Lo.oracle_username,Lo.os_user_name,Ao.object_name,Lo.locked_modeFrom V$locked_object Lo,Dba_objects AO,V$session Sesswhere ao.object_id = lo.object_id and lo.session_id =

Record a statement in Oracle looking for tree structure data:SELECT * FROM tablewhere xxxstart with org_id = ' xx ' connect by prior org_id = parent_id;The 1.CONNECT by clause indicates that each row of data is retrieved in a hierarchical order, and

A colleague in the morning information how to get to the build table statement and is not with storage that kind of SQL.Oracle provides itself with a function dbms_metadata. GET_DDL, but the built-in statement contains properties for storage, table