Oracle

Get help Exp Help=y/imp help=y Working style Interactive EXP Command line exp user/[email protected] file=/oracle/test.dmp full=y Parameter file mode exp parfile=username.par 　　　　　　　Parameter file contents　　　

1. Type comparison Oracle Mysql Int Int Number (6,2) Decimal (6,2) Date (sysdate) Timestamp (now ()) VARCHAR2 (20) varchar (20) 2. Common

Wm_concat (colname) is a built-in function for data-to-data transfer in Oracle 10g, with the following effects:Table T A B------------ 1 2 1 3 1 4 2 1 2 3Execute statement:SELECT from GROUP by AExecution Result: A

The creation of the job will not say, very simple, here is the main point is not in accordance with the specified time automatic implementation of the problemWorkaround:1. Run the jobbeginDbms_job.run (1);//Indicates the job number, which can be

Redo log file size under RAC adjustment(1) View current log information:SELECT * from V$logfile;(Step 2 Get the path can be seen here Member column, redo file name itself, such as, Redo07.log)(Note: The log group is now 6 groups)(2) Add log files

In this era of information explosion, how to help users to retrieve the data from the vast amount of data, fuzzy query is essential. So how is fuzzy query implemented in Oracle?First, we can use the LIKE keyword in the WHERE clause to achieve the

The requirement is to modify a list of Oracle to replace all 100 of this column with 200;Update B_nodes a set A.childs=replace ((select childs from B_nodes b where B.nodeid=a.nodeid), ' [+] ', ' $ ') where A.CHILDS&G t;10005The following is

Environment:Production system is an online user 10K OLAP system (11g RAC two nodes), one day the user unit found that the scanner is slow.View monitoring,Node1,io is high, heart rate is very highImmediately proceed to analysis:1. Original production

1.oracle exists the RowNum keyword, which is a pseudo-column (a special column that the system assigns on the result set)SELECT * from Oracletable WHERE rownum=1The above statement is capable of querying the first row of records.SELECT * from

This article is only used as a memo, without practical guidance, logic is slightly chaotic.1, command show parameter name;Sql> Show parameter Name;name TYPE VALUE-------------------------------------------------

Dbnewid is a tool that Oracle provides to modify database dbid and dbname.Before we introduce this tool, we must rebuild the control file if we want to change the database name of the database. However, it is not possible to modify the dbid of the

1) Change the date display type of the results queried in SQL developer in Oracle 11g R2, that is, the setting of the session date type:Alter session Set Nls_date_format = ' Yyyy-mm-dd HH24:MI:SS ';Oracle Plus fields:ALTER TABLE operator_daily Add

Download instantclient-basic-nt-11.2.0.2.0 -bit client, post-pressurized storage, such as F:\instantclient_11_2 Copy the Oracle 11.2G Msvcr80.dll and Tnsnames.ora to the extracted instantclient_32-bit client root directory, where they

Oracle fuzzy query methodIn this era of dramatic increase in information, fuzzy queries are essential to help users retrieve desired data from massive data volumes. In Oracle, how does fuzzy search work? 1. We can use the like keyword in the where

2. oracle installation knowledge, oracle server, oracle cluster, oracle service Introduction, user unlocking 1 oracle installation knowledge (oracle10g and oracle11g versions are different ): A installation directory does not contain Chinese

Oracle11gR2 cannot export an empty table with exp Oracle 11gR2 cannot export empty tables with exp Solution There is a new feature in 11gR2. When the table has no data, no segment is allocated to save space. Oracle cannot export empty tables when

ORA-27090 fault case The recent alert Log encountered an error message for the ORA-27090 with the error prompt Unable to reserve kernel resources for asynchronous disk I/O. According to this prompt, It is a kernel parameter problem related to

Dynamic log display in Oracle 1. view the location of the log file; IND_USER @ PROD> select inst_id, name, value from v $ diag_info; INST_ID NAME VALUE--------------------------------------------------------------------------------1 Diag Enabled

Why didn't I hit Racdatabasehome during oracleraco patchauto?First explain the environment: OS: AIX 7.1Oracle version: Oracle Rac 11.2.0.3 before the release of the 11.2.0.3.9 Patch Set, Rac is not officially used, so simply hit the latest 11.2.0.3.1

IT Ninja Turtles oracleconnectby usage Review First use the emp table of scott.The emp table has one field: empno (employee ID) and mgr (Superior manager ID)Below are all the data in the table 1 select *from emp start with