oracle study guide

;start_en_tirger.sqlSet Line 1800Spool/home/oracle/en_tirger.sqlSelect ' Alter TRIGGER ' | | Owner | | '. ' | | trigger_name| | ' ENABLE; ' From Dba_triggerswhere status= ' DISABLED ';Spool off;Appendix V: Building Index statements from the entire library structure DMP fileThe following statement is the index statement for the specified table, which is also available for the whole library, and after generating the statement, you can modify the concurr

Tags: OracleOracle Study-aix6.1 Building Oracle 10GR2 RAC (1)Environment:Operating System: AIX 6100-09 (SP3)Cluster Software: CRS 10.2.0.1Database: Oracle 10.2.0.1There are two ways in which RAC can be used to build an AIX platform based on shared storage:1. Establish shared storage based on concurrent volume group (VG concurrent)2. Build shared storage based on

Oracle supports two types of clustering: Index clustering and hash clustering. Guide to index Clustering L create clustering for tables frequently accessed in connection statements. L if the table is occasionally connected or its public columns are often modified, do not cluster the table. (Modifying the record's clustered key value takes more time than modifying this value in a non-clustered table, bec

Label: a while ago, to do Oracle restore of the database. Because it's a rookie, I didn't use oracle database. So many places do not know how to start. in the SQL Server database restore, nothing more than an additional database . Or use a script to restore it. but in Oracle in the database restore, there is no such visual tools (self-installed client does n

the "Desktop Class" radio button, and select the "Next" button.　　　　　　　　　5): In the "Typical installation Configuration" window, select the Oracle base directory, the database version Select "Enterprise Edition",Global database name, admin password can be set casually, click "Next".　　　　　　Tip: (click "Next" button, error message "[INS-30011] input ADMIN password does not conform to Oracle recommended standar

Oracle Study-aix6.1 Building Oracle 10GR2 RAC (2)First, view system I/O (asynchronous I/O is enabled for Oracle database)For AIX6.1, the default asynchronous I/O is automatically activated when there is a requirement, and no configuration is required.[[email protected]/] #ioo-a |grep AIO aio_active=0 aio_maxreqs=65536

1.2 requirement Software Installation A typical development environment includes the following components: Jdeveloper-refer to 3.1 "installing Oracle jdeveloper ." Webcenter extension bundle-please refer to 3.2 "installing the webcenter extension bundle ." Supported database-(optional) for example, Oracle Database 11g. Supported content repository-(optional) Example: Universal Content Management (UCM)

Tags: OracleOracle Study-aix6.1 Building Oracle 11gR2 RAC (1)Environment:Operating System: AIX 6100-09 (SP3)cluster:hacmp6.1Cluster Software: GI 11.2.0.1Database: Oracle 11.2.0.1There are two ways in which RAC can be used to build an AIX platform based on shared storage:1. Establish shared storage based on concurrent volume group (VG concurrent)2. Build shared st

software is installed, a database instance is created automatically). The fourth step: System class: Directly select the default desktop class to be able. Fifth Step: Typical installation: This step is an important step. It is recommended that you only update the Oracle base directory, and that the directory path does not contain Chinese or other special characters. The global database name can be defaulted, and password passwords must be kept in m

Tags: book com load otto transform one bottom 11g VerticaA very nice ebook on building reports in Oracle Fusion middleware 11g. This manual was intended for anyone the uses Oracle Reports to build Reports. The needs of both novice and advanced users is addressed. Following the step-by-step instructions, you can build the example reports from start to finish. Each report, you build would demonstrate how to u

Tags: OracleOracle Study--aix 6.1 installation of Oracle 11gR2System environment: aix6100-09 (Patch: SP3)Oracle:oracle 11gR21. View System Hardware Information$ prtconf |moreSystem model:ibm,7028-6c4 Machine Serial number:1096b0d Processor type:powerpc_power4 Processor Implementation Mode:power 4 Processor version:pv_4_2 number of processors:2 Processor Clock speed:1453 MHz CPU type:64-bit Kernel type:64-bi

Tags: OracleOracle Study---Use of oracle in and not not in vs. in: ------------------------------------------------------------------------------------------------------ not in equivalent to If not is followed by a subquery, the subquery contains only one A null return value causes the In the equivalent of =any , you can effectively handle the case of returning null values in a subquery and retur

Oracle Study--oracle Wait event (5)Db File Single writeThis wait event usually occurs only in one case when Oracle updates the header information of the data file (for example, checkpoint occurs). When this wait event is obvious, it is important to consider whether the number of data files in the database is too large,

the underscoreINSERT into t05102_a values (""); Insert single quotation marksINSERT into t05102_a values (Chr (39) | | 1); Man ASCII View-derivedCREATE TABLE T05102_b (a number,b number);INSERT into t05102_b values (1,999);INSERT into t05102_b values (1,0);INSERT into t05102_b values (2,999);INSERT into t05102_b values (2,0);SELECT * from T05102_b order by a B;SELECT * from T05102_b ORDER by a desc, b desc;Select a "x", B "Y" from the T05102_b Order by "X" desc, "Y" desc; aliases, in order by t

Use of index clusters: Create clusters of tables that are often accessed in connection statements. Do not cluster tables if the tables are only occasionally connected or their public columns are often modified. (It takes more time to modify the record's clustered key than to modify it in a nonclustered table, because Oracle must migrate the modified records to other blocks to maintain the cluster). If you often need a full search on a table, do not

is made, it's not affected by the call. The change was only seen in the runs of the job.In general, you should not alter a job, which is automatically created for the database. Jobs, were created by the database has the column SYSTEM set to in TRUE job views. The attributes of a job is available in the views *_SCHEDULER_JOBS .It is perfectly valid for running jobs to alter their own job attributes using SET_ATTRIBUTE The procedure, however, these changes Won't is picked up until the next schedu

Tags: Oracle Permissions environment configurationOne, Oracle installationFirst of all, Oracle service, I am using Oracle 11g, direct download version of the official website, downloaded is: Win64_11gr2_database_1of2.zip, Win64_11gr2_database_ 2of2.zip Two unpacking package, note is to setup.exe the contents of the two

Oracle Study Notes (1) -- oracle recursive queryFirst of all, we mentioned that connect by is used for Recursive queries. It is to traverse the link of the recursive application designed by the table structure in the database to meet our requirements. Connect by is followed by recursive conditions. In this condition sentence, the keyword prior is often used. This

Oracle user creation and permission operations (oracle study Note 1) 1. create userSQL> create user arthur identified by m123 (m123 is a password and must start with a letter) normal users do not have the permission to use create user. Users can be switched and then created # Use system to create user arthurSQL> conn system/password SQL> create user arthur identi

ORACLE Case Study on stored procedures, oracle stored proceduresORACLE detailed requirements on stored procedure cases Using the stored procedure: Obtain the old organization number from the CDEPDP table, then obtain the new organization number based on the old organization number table CDETRADEEX_BAK, and suffix the new organization number to the old organizatio