Oracle

Symptom: The Windows optimizer optimizes Oracle when optimizing the registry, so that the listener cannot be found. The solution is as follows: ◆ 1. in the registry, HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesOracleOraHome92TNSListener The

Today, I suddenly found that the TNSListener service could not be started. After I started it in the service console, I refreshed it and automatically returned to the stopped status. No error was reported. In addition, SPL PLus can be used normally.

1. How to configure EM to support SSL protocol OMS, DBConsole, and Agent in 10g em all support the SSL protocol. Specific operations: ◆ 1. if there is no environment variable ORACLE_SID, configure it first, or directly input set ORACLE_SID = xxx (in

The failure of oracle user connection makes us a headache. The following describes how to solve the failure of oracle user connection and hopes to help you learn about oracle user connection. After installing Oracle11g, I want to enable the

Since the oracle service is set to manual, you need to start the service each time you use it.Today, the connection failed after the startup,(1) command line sqlplus, connection failure prompt:ERROR:A ORA-01034: ORACLE not availableORA-27101: shared

One 16 million data table-text message upstream table TBL_SMS_MOStructure:Create table TBL_SMS_MO(SMS_ID NUMBER,MO_ID VARCHAR2 (50 ),MOBILE VARCHAR2 (11 ),SPNUMBER VARCHAR2 (20 ),MESSAGE VARCHAR2 (150 ),TRADE_CODE VARCHAR2 (20 ),LINK_ID VARCHAR2 (50

The following article describes how to use SQL * Loader to export Excel-related data to the Oracle database. The main purpose is to insert the actual application data in excel-related files into the Oracle database, the following describes the

-- Create permanent tablespaceCreate tablespace "58 SPACE"LOGGINGDATAFILE 'd: \ ORACLE \ ORADATA \ MYDB \ 57SPACE. ora 'size 5 M EXTENTMANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO-- Create temporary tablespaceCREATETemporary tablespace "58

I. Data Control Statement (DML) 1. INSERT (INSERT the record statement into the data table) 　　 Insert into Table Name (field name 1, field name 2 ,......) VALUES (value 1, value 2 ,......); Insert into Table Name (field name 1, field name 2 ,......)

Oracle POLICY learning 01 -- 1. create test table 02 create table TEST_POLICY03 (04 USERNAME VARCHAR2 (10), 05 password number (10) 06); 07 insert into t_policy values ('A', 30 ); 08 insert into t_policy values ('B', 20); 09 insert into t_policy

Oracle 11g default profile default Enable Password Expiration 180 days ORA-28001 error handling Problem description: the customer reported that the client could not connect when logging on to the application. Environment: AIX 5.3 + Oracle 11gR2

Use UTL_SMTP of Oracle Database to send HTML mail create or replace procedure html_email( p_to in varchar2, p_from in varchar2, p_subject in varchar2, p_text in varchar2 default null, p_html

Configure table space, create users, and import Databases --- Cmd go to the dos interface sqlplus/as sysdba ---- create table space --- create tablespace ciqpspace DATAFILE 'd: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ CIQP when creating the

Oracle foreign key table search SQL code Select B. table_name primary key table name, B. column_name primary key column name,. table_name foreign key table name,. column_name foreign key column name From (Select. constraint_name, B. table_name, B.

Routine Oracle database check methods and steps 1. Check the partition information 1. check which tables have partitions Select * from user_tables where partitioned=’YES’;  2. Check and list all secondary partitions in the current table select *

Subpartition template I have never known about the subpartition template. I tried it today. It is quite fun and useful. You do not need to fill in subpartitions when adding partitions during maintenance. The following is an example: Create table

Modify oracle memory usage # Su oracle $ cd $ ORACLE_HOME $. /sqlplus/nolog> connect/as sysdba;> show parameter sga; (view memory usage) name type value values ----------- ------------- lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size

Oracle-RMAN backup (1) I. concepts related to RMAN backup 1. in RMAN backup, The tablespace does not need to be in backup mode. It backs up data files, archive log files, control files, spfiles, and backup sets, but does not back up online redo log

Oracle-user-managed backup (ii) I. What will happen if the host is shut down abnormally when the tablespace is in backup mode? Open the first session window, Log On As A sys user, and place the tablespace users in backup mode. SQL> alter tablespace

For the left, right, and inner keywords, pay attention to the details. The details are very important! For example, remember to add comments when writing code! 1. Typographical editing-when writing SQL statements, especially writing batches, be sure