Oracle

Sqlplus/nolog Conn/As sysdba Shutdown immediate; Startup Mount; Alter session set SQL _trace = true;Alter system enable restricted session;Alter system set job_queue_processes = 0;Alter system set aq_tm_processes = 0;Alter database open; Set

View users Select *From dba_users   View User table Select *From user_tables   /* Formatted on 2012-01-20 20.20.10:32:56 (qp5 v5.149.1003.31008 )*/Select distinct D. table_name, C. tablespace_name ind_tbsp_nameFrom user_indexes  select

Ref: http://www.adp-gmbh.ch/ora/ SQL /table_cast.html       Create or replace type date_obj as object (DT date)/create or replace type date_table as table of date_obj/create or replace function date_range (from_dt in date, to_dt in date) return

Oracle does not support batch query. Therefore, multiple result sets cannot be returned from one command. When using a stored procedure, returning multiple result sets is similar to returning a single result set. You must use the ref cursor output

ORA-01578: Oracle data block upload upted (file # num, block # num) Cause: When Oracle accesses a data block, due to 1. Hardware I/O errors; 2. Operating System I/O errors or buffer problems; 3. memory or paging problems; 4. Oracle failed to

ORACLE-merge query results Recently, I encountered a problem. I need to combine the values of a certain field in the query results to show that I had a workund und through my own efforts and wrote it down for forgetting. The following is the form of

Declare CNT number; Begin--- Query whether the table to be created existsSelect count (*) into CNT from user_tables where table_name = 'entry _ modifystatus ';--- Delete the table if it exists.If CNT> 0 thenDbms_output.put_line ('table exists not

1. operating system authentication (the user must belong to the ora_dba group and the connection is secure (see D: \ oracle \ product \ 10.2.0 \ db_1 \ Network \ admin \ sqlnet. does this row exist in the ora file: sqlnet. authentication_services =

PL/SQL does not use arrays. Its set data types are similar to those of arrays. In versions earlier than 7.3, there was only one set, called PL/SQL tables. After that, there were two sets of data types: Nested tables and varray. The number of

The query plan and main statistical data are as follows: Execution Plan :-----------------------------------------...... 2 1 hash join (Cost = 5 Card = 14 Bytes = 224) 3 2 table access (FULL) OF 'dept' (Cost = 2 Card = 4 Bytes = 52) 4 2 table access

Create Table space and user authorization in oracle 13:49:47 | category: work log | Tag: | font size, medium/small subscription Create Table space and user authorization in oracleDocument category: DatabaseThe SYS user logs in as a DBA under

8.Use DECODEFunction to reduce processing time   You can use the DECODE function to avoid repeated scan of the same record or join the same table.   For example: Select count (*), SUM (SAL) FROM EMP WHERE DEPT_NO = 0020 And ename like 'Smith %

Oracle uses the following command line in windows:Net startOracleserviceorcl // start the ORACLE service [oracleserviceorcl is the actual service name]Net stopOracleserviceorcl // stop the ORACLE serviceNet startOracleoradb10g_home1tnslistener //

Oracle's imp/exp component is a common tool. One of its operational principles is Backward compatibility. The following are the usage rules and related tests summarized as follows: Rule 1: earlier versions of exp/imp can be connected to database

The ORACLE Database Log File $ ORACLE_BASE/admin/orasid/bdump/alert_orasid.log records the conversion of logs,   Database startup and shutdown, database structure change, rollback segment modification, deadlock, internal errors, and other

When a user process connects to the database and creates a corresponding session, the Oracle service process sets a PGA zone for the user to store the relevant content of the user session. When the user session ends, the Database System

ORA-01578: Oracle data block upload upted (file # num, block # num)   　　Cause: When ORACLE accesses a data block, due to 1. Hardware I/O errors; 2. Operating System I/O errors or buffer problems; 3. memory or paging problems; 4. ORACLE failed to

In a high-availability system, changing the definition of a table is a tough issue, especially for a 7 × 24 system. The basic syntax provided by Oracle can basically meet general modification requirements. However, if you change a common heap table

Document directory I. Initial Conditions 2. Start the Oracle database I. Initial Conditions The database has been installed on one machine. It is best to install it on one * nix machine. My test environment: Oracle 10g + CentOS 5.22. Start the

One type: Sub test ()''Test macro' Dim cn As ADODB. ConnectionDim rs As ADODB. RecordsetSet cn = New ADODB. ConnectionCn. Open "Provider = OraOLEDB. Oracle.1; PassWord = XXXX; Persist Security Info = True; User ID = XXXX; Data Source = XXXX;