Oracle

My system is win7 32-bit flagship Chinese version, and the database is oracle10g.Http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip 10gAn error message is displayed when you directly install Oracle10g in win7, resulting in a

  Index optimization rules: 1. Do not start with a WILDCARD (WILDCARD) in the like file. Otherwise, the index will not be used. Example: SELECT LODGING FROM LODGING Where manager like '% HANMAN '; 2. Avoid using calculation on the index column or

  SQL & gt; select userenv ('language') from dual; USERENV ('language ') ---------------------------------------------------- AMERICAN_AMERICA.WE8ISO8859P1 SQL & gt; select userenv ('language') from dual; USERENV ('language ') -----------------------

When remotely connecting to the database, the following error message is reported: ORA-01031: insufficient privileges An error occurred while trying to grant sysdba to sys. SQL> grant sysdba to sys; Grant sysdba to sys * ERROR at line 1: ORA-0

Oracle lock table and unlockSELECT/* + rule */s. username,Decode (l. type, 'TT', 'table lock ','Tx ', 'row lock ',NULL) LOCK_LEVEL,O. owner, o. object_name, o. object_type,S. sid, s. serial #, s. terminal, s. machine, s. program, s. osuserFROM v $

Drop procedure mrr. delete_risk_assessment;Create or replace procedure mrr. delete_risk_assessment (Id IN NUMERIC) ISBEGINDelete mrr. riskassessmentvalueWHERE risktypedetail_id IN(Select mrr. risktypedetail_id FROM risktypedetailWHERE riskassessment_

The company's system uses tomcat + jsp + oracle. Currently, the system runs normally. Now there is a problem with the date when the system imports excel tables in batches.This system supports the date format, while the default date format in the

Case 4: Oracle diagnosis using SQL _trace Problem description: many times, when we perform database operations, such as drop user and drop table, we often encounter such errors. ORA-00604: error occurred at recursive SQL level 1. This prompt is

% TYPE attributeIn PL/SQL, you can declare variables and constants as built-in or user-defined data types to reference a column name and inherit its data types and sizes. This dynamic value assignment method is very useful. For example, the data

Related error promptOERR: ORA-12519 TNS: no appropriate service handler foundClient Connection intermittent failure, error ORA-12519Cause: the listener cocould not find any available service handlers that areAppropriate for the client

C: \ Documents ents and Settings \ Administrator> sqlplus/nologSQL> connect system/password as sysdbaConnected.SQL> shutdown normalORA-01109: the database is not open  The database has been detached.The ORACLE routine has been disabled.SQL> startup

My linux version is centos5.5 and the kernel version is 2.6.18-194. el5. in linux, it is best to install the oracle System with 1 GB memory and 2 GB swap space. The hard disk requires at least 4 GB space.1. Download oracleGo to the oracle official

Notes1. Data can be rolled back after being deleted in oracle because it places the original data in the undo tablespace,2. DML statements use undo tablespaces, DDL statements do not use undo, delete is a DML statement, truncate is a DDL statement,

When the physical standby generation GAP is simulated, the gap in the dataguardOracledatabase database may be generated because the archive file is too large or the network is unstable, and some archives cannot be uploaded to the standby. General

Optimization of IMPDP/EXPDP Import and Export speed data pump and exp/imp performance is greatly improved, the biggest impact is paralle. In this case, expdp/impdp = exp/imp + direct mode + paralle. Therefore, to increase the speed of data pump, you

Oracle multi-row record merging user-defined functions (udfs) are used to merge fields in oracle databases. You can use the wm_concat (column) function. However, this method is not recommended by Oracle, because WMSYS users are used for Workspace

Oracle may encounter tar databases during PSU. What is Inventory if it is not properly installed? Oracle OUI is used to manage the Oracle installation directory. Inventory registers the component and version of the database installed under an ORACLE_

Union all is used to display the total items in a total project. Generally, a column is calculated and the total is displayed at the end of the column. The conventional method is to use union all to establish meaningless connections. Example: SQL

SQL tuning advisor (STA) for Oracle SQL Optimization)SQL Tuning Advisor (STA) is an oracle SQL optimization subsidy tool. In fact, there are two main solutions to optimize SQL. One is to rewrite the SQL itself. To rewrite SQL, you must have a good

Considerations when using EXPDP and IMPDP: EXP and IMP are client tool programs that can be used either on the client or on the server. EXPDP and IMPDP are tool programs on the server. They can only be used on the ORACLE server, but not on the