Oracle Database
Abstract: In a large number of business data processing projects, consider using the partition table to improve the performance of application systems and to facilitate data management, This paper describes the use of the partition table. In the larg ...
Oracle database character set conversion law of a comprehensive analysis of rn rn rn A good article in this chapter, specific and comprehensive. rn rn rn As an Oracle database users, for the Export and Import two commands will not feel strange, becau ...
1.1 Basic commands 1. Get Help $ Exp help = y $ Imp help = y 2. Three kinds of work (1) an interactive way $ Exp / / Then prompted to enter the parameters needed for (2) command line mode $ Exp user / pwd @ dbname file = / oracle / test.dmp full = y ...
1 What is the ASM ASM called the Automated Storage Management, the automatic storage management, it is this version of Oracle since the Oracle10g new features. This is the Oracle provides a volume manager for the replacement operation of the operatin ...
2.5 The new ASM command-line (ASMCMD) commands and options. ASMCMD have the following four new commands: lsdsk, md_backup, md_restore and remap. In addition, you can use with the new option of ls and lsdg commands. The following describe these four n ...
Sometimes not careful, the operating system can not enter, need to re-install the system. That may be of your oracle database files are placed in another dish, assuming that the original installation of the database (D: \ oracle \ oradata), re-named ...
In the Oracle database, create an index is a relatively simple. However, to a reasonable index is relatively difficult to create. The author believes that when creating an index appropriate to do three, namely, in the appropriate table, the appropria ...
Prior to Oracle9i, the Chinese is based on binary coding to sort. The oracle9i added in accordance with the phonetic, radical, stroke sorting. 1, set parameter values NLS_SORT SCHINESE_RADICAL_M accordance with the radical (first order), stroke (seco ...
What are the responsibilities of Oracle database administrator 1, Oracle database administrator should be as follows on the Oracle database system for regular monitoring: (1). On a daily basis running Oracle databases, log files, backups, database sp ...
Oracle Database administrator should be as follows on the Oracle database system for regular monitoring: (1). On a daily basis running Oracle databases, log files, backups, database space usage, the use of system resources, it was discovered, and sol ...
rn Question: Creating a database manually Environment: Operating System: Microsoft Windows XP [Version 5.1.2600] Database: ORACLE 10.2 Source: 1 ORACLE DOC Oracle? Database Administrator's Guide 2 Creating and Configuring an Oracle Database Creat ...
A few days ago the database gave a number of useless delete a few tables, and later see what the current user, there are some table, actually featured a lot of garbled, and later checked the Internet know, these are I deleted The tables were put to t ...
In some cases, the need to provide a Linux operating system unattended on a random start Oracle functions, to perhaps just to help those who are not concerned about the details of Oracle's friends. Of course, if possible, must not use this automa ...
Oracle database password file to use and maintenance of By shijun »2009-11-03 11:01 Oracle, if the user wants to privileged user (INTERNAL / SYSDBA / SYSOPER) log Oracle, specifically, there are two authentication methods: (Source: linuxol.cn) (1) Th ...
: A start - "Set -" Control Panel - "Administrative Tools -" Service Stop all Oracle services. 2 to start - "process -> Oracle - OraHome81-> Oracle Installation Products-> Universal Installer Uninstall all Oracle pro ...
Silent installation of Oracle Database Practice Author: Qu Zhuo April 21, 2006 Directory Preface Silent install Oracle Database 10g chapter Oracle Database 9i silent installation chapter References Preface This article is the author of Oracle databas ...
ORACLE database structure diagram: 500) this.width = 500; "border =" 0 ""
The purpose of a document The company's current project, a database project using the oracle account for a very high ratio in various stages of the project life cycle, there is a demand for optimizing the database, this document used to guide the ...
While Oracle will be in the above development, but the management really is unreasonable, especially in linux, the company recently to restart the server always gets to have to restart the database, always remember the command, and now paste these co ...
Using PL / SQL Developer when you connect to the database "ORA-12541: TNS: no listener" error. rn 1, check the log listener.log found the following errors: TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-9 month -2,008 10: ...
Sun Oracle Database Machine Sun Oracle database machine for any type of database load for both the world's fastest, and is the only transaction processing applications to run the database machine. It is a comprehensive software, servers, storage, ...
Operating system, HP-UX 11.31 oracle 10.2.0.4 Question: Software developers to the system temporary table space in the temp table space when you add the raw LV, put their names wrong. Resulted in / dev / vgname directory generate a corresponding file ...
exp and imp local Import Export Hong Kong exp command: 1 exp username / psw @ TEST file = d: test.dmp full = y 2 exp username / psw @ TEST file = d: test.dmp owner = (ly) 3 exp username / psw @ TEST file = d: test.dmp tables = (grid1, grid2) First, o ...
Client-side character set defines the client-side character data encoding, any from the bottom or send to the client's character data are defined by using the client-side character set encoding, the client can be seen as directly connected with t ...
Method 1: Method 2: SQL> select * from product_component_version; PRODUCT VERSION STATUS ------------------------------------------- ------- --------- ---------------- NLSRTL 10.2.0.1.0 Production Oracle Database 10g Enterprise Edition 10.2.0.1.0 ...
- 1. Monitoring examples of waiting select event, sum (decode (wait_Time, 0,0,1)) "Prev", sum (decode (wait_Time, 0,1,0)) "Curr", count (*) "Tot" from v $ session_Wait group by event order by 4; - 2. Rollback of contenti ...
◆ 1. From one windows server A on the export of all objects the user Test1 and then import into the linux server, the user B on Test2. (Known to Test1 password Test1passwd or with system users to export are also line) ◆ 2.B machine Test2 user does no ...
Scenario: Users reported that a reporting format can not be updated. Reported the following error message 2009-09-14 16:01:36 [1002] [-1] [ORACLE] OracleFactory (3): SP = ARGTempletDetailSet, Source = System.Data.OracleClient, ERR = ORA-01578: ORACLE ...
AIX to automatically start the Oracle database and listener methods rn rn Projects, the need to start the operating system automatically starts data and listener, after a trial, in accordance with the following steps, success in achieving objectives: ...
Oracle Database offers several different database startup and shutdown mode, this article details of these startup and shutdown mode, as well as the difference between their different functions. 1, start and shutdown Oracle Database For most Oracle D ...
In the following conditions, check with the Chinese data in a table, be able to display correctly SQL> select * from nls_database_parameters; - database character set PARAMETER VALUE ------------------------------ --------------- NLS_LANGUAGE AMER ...
Synonym for V_ $ TYPE_SIZE V $ VERSION Synonym for V_ $ VERSION V $ WAITSTAT Synonym for V_ $ WAITSTAT V $ _LOCK Synonym for V_ $ _LOCK
Oracle Database 11.2 for Linux x86/x86_64 has been available for download, download address is: http://www.oracle.com/technology/software/products/database/index.html The document path is: http://www.oracle.com/pls/db112/homepage clusterware and ASM ...
1, startup nomount Non-installation boot: in this way to start the next executable: rebuild control file, rebuild the database, start instance, that launched SGA and background processes, which started just init.ora file. 2, startup mount dbname Inst ...
rn rn Concept: rn SID: the database instance name rn SQL> show parameter instance rn rn DB_NAME: database name. Can be DBNEWID (nid) command to change the DB_NAME. rn SQL> show parameter db_name rn rn DBID: databases created when the internal number
LoadRunner testing Oracle database and Siebel Performance Annex has a screenshot The test used for loadrunner version 8.1, oracle database version 10.2.0.1, the version of the test method is basically the same. Here loadrunner 8.1,10000 a web user ...
After the installation of the general, you can directly on the Dos interface (windows version) or its Unix operating system running directly sqlplus, use sqlplus to start or shut down the database, and only after the start, oracle enterprise manager ...
Oracle database import and export of basic methods of data collection using the most recent import and export data oracle encountered a lot of trouble! Oracle database was carried out on a serious study, summed up the import and export order of sever ...
rn rn How to configure the client can connect to the database: rn For a client machine can connect oracle database on the client machines need to install the oracle client software, the only exception is when the java database connectivity, you can u ...
ORACLE database and sometimes the operation, suggesting that a string???, Can not play the role of prompt, which is set up the environment because of language problems, the following operation is the actual use of. View the current session of the lan ...
rn rn Teach you to delete useless duplication of Oracle database data rn Oracle, the database, delete rn rn rn rn rn Operation of the database in the process, we may encounter this situation, the data table may be repeated, so that we process for the ...
rn Three default user and password: sys change_on_install [as sysdba] system manager scott tiger Start: Listener: lsnrctl start Database instance: oradim-startup-sid orcl Landing: sqlplus / as sysdba Create a user: create user lisi indentified by lisi; Sy
Oracle database tuning aspects of theory, is the largest Oracle database in the scope of what can be optimized. Roughly speaking, there are three major aspects of it. Data model tuning, SQL code tuning, physical configuration tuning.
Official Address: http://www.oracle.com/technology/global/cn/software/products/oracle9i/index.html Oracle9i Database Release 2 Enterprise / Standard / Personal Edition for Windows NT/2000/XP http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Dis ...
First backup $ ORACLE_HOME \ dbs \ spfileSID.ora document c:> set ORACLE_SID = xxx c:> sqlplus / nolog sql> connect / as sysdba - View the current value of the parameter sql> show parameter processes; sql> show parameter sessions; sql& ...
Generally only in large-scale application or performance data, according to the Treasury decreased only need to change the initialization parameters. So from this perspective, the adjustment of parameters to initialize Oracle database is a high-level ...
Also encountered "Oracle.DataAccess.Client.OracleConnection" set initial value of the type of an exception "error, annoying, Google-related information is as follows: Oracle database. Net connectivity problems summary Environment: mach ...
There are three standard Oracle database backup methods, which are the Export / Import (EXP / IMP), hot and cold backup. Export of spare parts is a logical backup, cold backup and hot backup is a physical backup. A, Export / Import (Export / Import) ...
In the Oracle database, create a relatively simple index. But the creation of a reasonable index is more difficult. The author believes that in the creation of three indexes which must be appropriate, that is, in the appropriate form, appropriate to ...
Unix environment explain fully optimized for Oracle database Today, the optimization has been to optimize the wait (waits) in transition, and the actual performance optimization in the emergence of the most fundamental points are concentrated in the ...
