oracle study guide

Tags: Oracle Insert Table 11g 10gToday in the company's server installed a system, in the database guide the time has not been in, was originally 10g. dmp file, import 11g, suspect version incompatible, later put the. DMP table Open, change the version number inside to 11g, and found that import or not, IMP Fss12d/[email Protected] file= "./dc.dmp full=y Ignore=y"; Later, Baidu, change the environment varia

Tags: OracleOracle Study-View Oracle version operation Word length (32/64 bit) methodFirst, using Sqlplus view64-bit:[Email protected] ~]$ sqlplus '/as sysdba 'Sql*plus:release 11.2.0.3.0 Production on Wed June 24 14:14:10 2015Copyright (c) 1982, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWit

In order to generate some resources for the release of the library. Requires the API module to be migrated to MySQL in, need to boot data.Try the Oracle to MySQL tool. When migrating errors do not say that such a large amount of data, with such a crude tool is less reliable.Unexpected discovery tools typically use database views Navicat Premium has data migration tools that are surprisingly useful. The tool itself supports mysql,

Preface: What can you learn through this study Directory: One, what is a trigger. second, what is the application scenario of the trigger. 1. Complex security Checks 2, the data confirmation 3. Realize audit function 4, the completion of data backup and synchronization third, what is the syntax of triggers. Iv. What types of triggers are available. 1, statement-level triggers 2, row-level triggers v. Introduction of the Case --------------------

1, unzip the file 10201_database_win32.zip, and double-click the Setup.exe directory, the installation interface appears as follows:2, enter the password and confirm the password, such as:password, click Next, the following progress bar appears,Note: This password is the administrator password.3, check the prerequisites, select the Red box as shown in the selection box, such as:4, click "Next", the "Summary" screen appears, click "Install".5, the installation progress bar appears, waiting for in

Tags: array rar organization Throw exception build log job schedule exec expressionThis week's book is the Ultimate guide to Oracle's C PL (SQL) programming, published by the mechanical industry press, Sun Fingdong, Wang Yu, Guo Xiaohui. Content Introduction: The ultimate guide to Oracle 12c PL/SQL is the most systematic, comprehensive, practical and

Tags: OracleOracle Study-aix6.1 Building Oracle 11gR2 RAC (2)First, modify the system kernel parameters[[email protected] app] #chdev-l sys0-a ncargs=256SYS0 changed[[email protected] app] #lsattr-el sys0-a NcargsNcargs arg/env list size in 4K byte blocks True[[email protected] app] #vmo-P-o minperm%=3Setting minperm% to 3 in Nextboot fileSetting minperm% to 3[[email protected] app] #vmo-P-o maxperm%=90Modi

Oracle Study--oracle Wait event (3)Db file Parallel readThis is a very misleading wait event, and in fact this wait event is not related to parallel operations such as parallel queries, parallel DML. This event occurs when the database is recovering, and when some data blocks need to be restored, Oracle reads them from

Tags: OracleOracle Study---oracle Regular expressionCase Requirements:To set up a check constraint, require that the field input must be "00[number][number][a-z":The following constraints (constraint) are established through regular expressions:17:20:13 [email protected] PROD >desc cardName Null? Type----------------------------------------------------------------- -------- ---------------------------------

installation directoryChown-r Oracle:oinstall/u01/appChmod-r 775/u01/app5. Start the installation>> CD Disk1>> RPM-IVH oracle-xe-11.2.0-1.0.x86_64.rpm6. Run the command to configure Oracle XE>>/etc/init.d/oracle-xe Configure7. Modifying environment variables in Bash_profileAfter installation, the system will automatically establish a user named

Oracle expert Advanced Programming Study Notes (2) Three main components of Oracle architecture:1. File: five files that constitute the database instance (parameter files, control files, data files, temporary data files, and redo log files)2. system global area (SGA): Java pool, Shared Pool, etc.3. Physical Processes and threads: three different types of proc

October 14 to the electronic deployment system, with EXP, IMP Guide Library command successfully implemented the Oracle database export, import, in this case, also published a special article Oracle Database Export Import, explain the export, import process. Yesterday, the new server installed Oracle database with EXP,

lsnrctl reload //重启监听器 Landing Oracle via IP sqlplus username/[emailprotected]/ORCL Not null and default order problemsDefault must precede null or NOT NULL CREATE TABLE datp0 ( GLOBALID number(11,0) DEFAULT ‘0‘ NOT NULL, CYCLE number(11,0) DEFAULT ‘0‘ NOT NULL, P1 varchar2(5) DEFAULT NULL, ... ); Background execution SQL nohup sqlplus oracle/[emailprotected] @sql.sql View Locked process /

ORA-00604 error occurred at recursive SQL level string Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables ). Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle customer support. ORA-00604: An error occurred while recursion a SQL Layer Cause: an error occurs when you run a recursive SQL statement that applies to operatio

The Oracle 11g R2 DBA Operations Guide was the first book I learned about Oracle database knowledge, where I recorded my own learning notes, and I verified the knowledge points in the book by actual operation.1.Oracle Database Foundation 1.1. relational database 1.1.1. relational Database model 1. relational Database

Some ASP. NET + Oracle 11G systems write-and-learn essays, including referencing Oracle's official data provider and changing the date format of Oracle storage. (8) Reference Oracle's official data provider At the end of the last post "Oracle 11g Study Notes (3)", an ASP. NET 2.0 example is provided for you to down

OriginRecent 10g and 11g physical standby configuration experiments found that Data Guard is actually easy, but lacks good documentation. I was experimenting with the official documentation and thought it wasn't very clear.Google out of two PDF documents, read it feel much stronger than official documents. It may be useful for some friends to translate. I am also better acquainted with these two documents while translating. I have not translated English for a long time, can practice practiced ha

Study of oracle lesson one, oraclelesson Oracle learning Part 1 1. oracle Introduction 1.1 common database categories Small databases: SQL server, access (Microsoft) Medium-sized databases: mysql (from Sweden) and sybase (sybase from the United States) Large Databases: informix (IBM),

Oracle DBA Study Notes-STARTUP detailed description: Refer to database version: 10.0.2 I. Command Parsing STARTUP options | upgrade_options options is: [FORCE] [RESTRICT] [PFILE = filename] [QUIET] [MOUNT [dbname] | [OPEN [open_options] [dbname] | NOMOUNT], the three stages of NOMOUNT, MOUNT, and OPEN are startup. They cannot exist in the command at the same time. Here, open_options is: READ {ONLY | WRITE [

Tags: Oracle--oracle Full-text indexing with Case study tuningFull-Text Search (Oracle text)Oracle text enables oracle9i to have powerful text retrieval capabilities and intelligent text management capabilities, Oracle text is a n