10g fet

From 10g, Oracle can recover the wrong statistics. This article briefly describes the statistical information recovery feature. Inaccurate statistical information may lead to the inability to produce optimal execution plans, and for the most part, the latest statistics reflect the current system data distribution, resulting in optimal execution plans. But sometimes a change in the execution plan that results from collecting statistics does not neces

Tags: Ops directory sed nal RTM user its source users Oracle HR Example User's build 10g,11g can be Put the 10. sql files on the attachment (see the end of the article) in this path first: $ORACLE _home/demo/schema/human_resources Script Name Description Hr_analz.sql Collects statistics on the tables in the schema. Hr_code.sql Creates procedural objects in the schema.

At first glance, this hint of ORA-00979 not a GROUP by expression is expected to quickly locate it as a SQL statement with a problem, in fact, you may encounter an Oracle bug, which is common in 10.2.0.4 version (10g The last patch version is 10.2.0.5).A few days ago and colleagues to do an application system upgrade encountered this problem, first of all, a view can not be created, carefully analyze the composition of the view of the query did not fi

identified by ar#admin# default tablespace arsystem temporary tablespace artmpspc Quota Unlimited on a Rsystem; Figure 9 Creating a Aradmin user 3. Granting database Permissions Grant alter Session,create cluster,create database link,create sequence,create session,create synonym,create table, Create View,create procedure,create trigger,query rewrite to Aradmin; Figure 10 Assigning database permissions 1.3.3. Database ImportImport command: IMPDP system/[email protected] Directory=file_path dum

Tags: OracleOracle 10g RAC Installer failure--oracle Software Installation Unable to discover the clusterSystem environment:Operating system: AIX 5300-08Cluster Software: CRS 10.2.0.1Database: Oracle 10.2.0.1First, the phenomenon of fault650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/53/7F/wKioL1RpcUHSbh9YAAHA2NM5OeA678.jpg "title=" Rac3.png "alt=" Wkiol1rpcuhsbh9yaaha2nm5oea678.jpg "/> After installing CRS, installing Oracle software fail

Issue: ORACLE 11g exports a user's own table with the EXP command export and IMP imports 10g found empty table cannot be exportedCause: 11g When you start to build a table, segment is not assigned by default to save space, and when the table inserts the first data, it is redistributed segmentWorkaround 3 ways:1: Insert a piece of data into the blank, and then delete it, allocate space (the empty table is relatively small).2: Modify the system paramete

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 B--------------- 1 2,3,4 2 1,3Attention:Wm_concat (colname) can be used when using row to column in the body, but Wm_concat (DISTINCT colname) will error when the package is compiled.For example

Oracle database system is one of the most popular client/server (client/server) or B/s architectures in the United States Oracle Corporation (Oracle) provides a distributed database-centric set of software products.As a relational database, it is a complete relational product; It realizes distributed processing function as a distributed database. But all of its knowledge, as long as it learns Oracle knowledge on one model, can be used on all types of machines.As a result, more and more people ha

Tags: types name settime set EFI no output function posAs we all know, the output structure of static SQL must also be static. For classic row-to-column problems, if the number of rows is variable, the standard answer is to use dynamic SQL, which is a pivot with XML results in 11G. But Oracle 10G does not have a PIVOT function to do, write one of their own soon. Direct point on the code. CREATE OR REPLACE Type Pivotimpl_shx As Object ( Ret_type any

Tags: WinForm style blog http tar extBecause like new things, so basically computer development tools are the latest, Oracle also installed 11g R2, but colleague classmate is not 11g R1 is 10G, from here I exported the DMP file in their direction in, all show:IMP-00010: Not a valid export file, header validation failedFor this problem has been distressed, almost want to unload 11g and then installed 10g, th

AIX 5.3 Installation Oracle 10g error Case--runinstallerSystem environment:Operating system: aix5300-08Oracle Software: Oracle 10g (64-bit)Error phenomena:Client an AIX host, previously installed Oracle, uninstalled Oracle software, and changed the UID of the Oracle user, the following error occurred with the reinstallation of Oracle:650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/28/7B/wKiom1N5w

AIX 5.3 Under Oracle 10g RAC boot failure--crs boot failureSystem environment:Operating System: AIX 5300-09Cluster Software: CRS 10.2.0.1Database: Oracle 10.2.0.1System Architecture Diagram650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/26/B1/wKioL1NspizDELFmAAFqCT5td6k065.jpg "title=" r2.jpg "alt=" Wkiol1nspizdelfmaafqct5td6k065.jpg "/>Failure phenomena:After the system restarts, the CRS startup fails on the node or the CRS service starts

RedHat EL5 installation of Oracle 10g RAC-Build LibrarySystem environment:Operating system: RedHat EL5Cluster:oracle CRS 10.2.0.1.0Oracle:oracle 10.2.0.1.0: RAC System Architecture650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/26/2A/wKioL1NqAeDQ-M09AAGvUOVml00157.jpg "title=" Rac.png "alt=" Wkiol1nqaedq-m09aagvuovml00157.jpg "/>Iv. establishment of a database through DBCA1. First configure ASM Disk group with DBCA[[email protected] install

In an Oracle 10g R2 RAC Environment, there are three nodes C1, C2, C3,However, due to an error operation, OCR is destroyed, and the disk backup only C1, c2 two node state, restore the OCR disk, so C3 lost.The following issues are found in the process of adding C3 to the cluster:At the time of the. AddNode there will be C3 still present in the Runinstaller graphical interface, making it impossible to join.Corresponding method:1. Find/u01/app/oracle/ora

Redhat Linux AS4 install Oracle 10g (10.2) 1. Hardware requirements (1) memory> 1024 MB Memory swap Partition > 1024 MB 2 times memory > 8192 MB 0.75 times memory Display memory commands 2)/tmp> 400 M 3) detection command Memory # Grep MemTotal/proc/meminfo Swap Partition # Grep SwapTotal/proc/meminfo /Tmp Partition # Df-k/tmp Cpu Information # Grep "model name"/proc/cpuinfo 2. software requirements 1) Operating System Red Hat Enterprise Linux AS/E

Install Oracle 10g graphic tutorial in redhat 4, -- Note: This article only installs Oracle and does not create a database. I. Install a readhat4 System in the Virtual Machine Ii. IP Address Allocation The configured IP address is as follows: 3. create user groups and users Note: oracle users should have the same uid. Groupadd-g200oinstall Groupadd-g201dba Useradd-u200-goinstall-Gdbaoracle Passwdoracle 4. Create a directory Modify the file owner -- C

whether the deletion is successful; SQL>selectnamefromv$tablespace; NAME ------------------------------ ....... UNDOTBS2 12rowsselected. 13. Update pfile SQL>createpfilefromspfile; Filecreated. 14. The data file in the volume except the original UNDO tablespace is named as the result of execution in the step. #rm$ORACLE_BASE/oradata/$ORACLE_SID/undotbs01.dbf The solution to the insufficient disk space caused by the large Oracle

InWindows 7LowerInstall Oracle database lite 10 GBThe following error occurs after setup.exe is run. The error message is as follows: Checkinginstallerrequirements... Checkingoperatingsystemversion:mustbe5.0,5.1,5.2or6.0.Actual6.1 Failed ExitingOracleUniversalInstaller,logforthissessioncanbefoundatC:\ProgramFiles\Oracle\Inventory\logs\installActions2011-08-01_09-40-07AM.log PleasepressEntertoexit... Open the log file in the error message and check the first line in

. #SQLNET.ORANetworkConfigurationFile:D:oracleora92networkadminsqlnet.ora #GeneratedbyOracleconfigurationtools. SQLNET.AUTHENTICATION_SERVICES=(NTS) NAMES.DIRECTORY_PATH=(TNSNAMES,ONAMES,HOSTNAME) Name of sqlnet. ora in a three-tier structure #NAMES.PREFERRED_SERVERS= #(ADDRESS_LIST= #(ADDRESS=(PROTOCOL=TCP)(HOST=MICROSOF-3D9384)(PORT=1575)) #) 4. Oracle http server cannot be started Stop the site that uses port 80 in IIS, or change the port number of the Oracle H

First, add the ORACLE 10g installation CD to the optical drive. If it runs automatically, the installation interface 1 appears:Figure 1Click "Start installation" to install ORACLE 10 Gb. Generally, check whether the system configuration meets the requirements. Then, the "Oracle DataBase 10 Gb installation" dialog box appears, as shown in Figure 2:Figure 2You can select "Basic installation" or "Advanced installation" when installing Oracle DataBase at