Oracle

First, EXP exportexp itzy/itzy@orcl file=D:\sql-bak\itzy.dmp Log=D:\sql-bak\itzy. Log exp User / password @ instance name file=log= path plus log name Ii. IMP Import1, connect to SYSDBA database Sqlplus "/ asSYSDBA "2, view the currently

Background: A table of cleanup mechanism problems, resulting in the table data has been increasing, the table water level is very high, it is necessary to clean up the table data and drop the water level.1.1 Pre-migration preparationStep one, create

The profiles file is a configuration collection of password and resource restrictions, including CPU time, I/O usage, idle time, connection time, number of concurrent sessions, password policy, and so on resource usage profile can control session

1. Check the alarm log/u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.logReal-time logs: Tail-f/u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.logTrace File ADR2. Dynamic performance view (v$) saved in memoryInformation used to access

Structure of the original tableQuery statements: Select Sno,sname,sum (language) language, sum (mathematics) Mathematics, SUM (English) English from (select Sno,sname,decode (subjiect, ' language ', grade) language, decode ( Subjiect, ' math ',

1. Initialize parameter fileStart instance, read initialization parameters(1) SPFile (server parameter file) binaries cannot be modified manually Spfile.oraSql> Show parameter SPFile;NAME TYPE VALUE------------------------------------ ----------- -

Oracle Usage Summary1. New Table Delete TableNew Table statement:CREATE table + table name {}CREATE TABLE Afa_user (user_id VARCHAR2 ( +) notNULL, tenant_id VARCHAR2 ( +), User_code VARCHAR2 ( +), PASSWORD VARCHAR2 ( +), user_name VARCHAR2 ( -),

Management SectionIf database force logging is not enabled, the repository/*+ append */operation, nologging operation, will report the bad block;Suggested table space Force logging or database force logging;--force logging/nologging TestALTER

Problem descriptionCustomer reflects the system can not login;ReasonThrough testing, it was found that the Oracle user password expired, mainly because "password_life_time=180 days" was set by default in oracle11g in the defaults

1. Create a POPo_headers_allSelect po_header_id from po_headers_all where segment1 =;SELECT * from po_headers_all where po_header_id =;Po_lines_allSELECT * from po_lines_all where po_header_id =;Po_line_locations_allSELECT * from

Sqlplus system/[email protected]; View Oracle Character set: SELECT * from nls_database_parameters where parameter = ' Nls_ CHARACTERSET '; C, server-side character Set Modify ***************************************************************** *

Basic information: RAC Cluster Information:Scan ip:10.133.200.230Server_name:cxydckRAC-1 "10.133.200.231"DB instance: Oracle_sid:cxydck1Public ip:10.133.200.231RAC-2 "10.133.200.233"DB instance: Oracle_sid:cxydck2Public ip:10.133.200.233 1.

--Query statement: SELECT Column name/wildcard/column alias/expression from table name (decoration/restriction statement)SELECT * from tab;Select Tname columns specified from tab;--Select Tabtype from tab;Select Tname "T-m" from tab;--new column

Oracle creates the user's syntax:CREATE USER username identified bypassword or identified exeternally or identified globally as ' Cn=user ' [DEFAULT tablespace tablespace] [Temporary Tablespace Temptablespace] [QUOTA [integer k[m] [UNLIMITED]] on

First, Environment Platform Version a machine: linux RHEL 5.8 X64 Oracle 11.2.0.3 X64 Single Instance Oral b machine: win2003 X32 Oracle 1

Tag: INF _id using select Not open RAC for loop begin1.for Loop traversalDeclareCursor Mycur is a select * from Ct_cust_info;CustInfo Ct_cust_info%rowtype;COU number;BeginFor CustInfo in Mycur loopCou:=mycur%rowcount;Dbms_output.put_line

There are four main functions in Oracle that support regular expressions:1,regexp_like: Similar to the function of like2,REGEXP_INSTR: Similar to the function of INSTR3,REGEXP_SUBSTR: Similar to the function of SUBSTR4,regexp_replace: Similar to the

Select To_char (signdate, ' yyyy-mm-dd hh24:mi '), COUNT (*) from (SELECT * FROM (select id,code,signdate from table1 WHERE signdate >= to_date (' 2017-04-01 00:00:00 ', ' Yyyy-mm-dd hh24:mi : SS ')and SignDate UNION AllSelect Id,code,signdate from

Download oracleinstant-client specifically choose which version to see their actual needs, generally if the corresponding is 32-bit application then select 32-bit instantclient Download oracleinstant-clientChoose which version to see

1, create a temporary tablespace when creating a tablespace, the DBF file is generally stored in the DataFile file under the folder (usually under the name of the instance folder) can be through the select * from V$datafile; View all data file