Oracle

Tag:tab   read   oss   manage    copy     options   ons   line   base    $ Sqlplus '/as sysdba ' sql*plus:release 12.1.0.1.0 Production on Tue June 13:03:06 2015Copyright (c) 1982, Oracle. All rights reserved. Connected to:oracle Database 12c

One, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is

I. What is PL/SQL?PL/SQL (procedural language/sql) is an extension of Oracle in the standard SQL language.PL/SQL not only allows the embedding of the language, but also defines variables and constants, allows the use of conditional and circular

1. The Tomcat was released yesterday, but after login error, unable to open hibernate session, check that the database cannot connect2. Using PL/SQL to log in to the database, reported ora-12541,tns no listening program, Baidu found the need to

To completely uninstall the oracle11g step:1. Start-> Settings-> Control Panel-> Management Tool-> Service stop all Oracle services.2, Start-> Program->oracle-orahome81->oracle installation products-> Universal Installer, click "Uninstall

Local dynamic SQLFirst we should understand what dynamic SQL is, the SQL that we use in the Oracle database Development PL BLOCKDivided into: Static SQL statements and dynamic SQL statements. The so-called static SQL refers to the SQL statements

Log in to Plsql with the DBA user and ExecuteThe first step is to create a table spaceCREATE SmallfileTablespace "ASSETS"LOGGINGDataFile' E:\ORACLE\PRODUCT\10.2.0\ORADATA\SDZC0216\ASSETS1.ora ' SIZE500M AutoextendOn NEXT 10M MAXSIZE UNLIMITED,'

Oracle 11g Install the text guideFirst, Oracle downloadNote that Oracle is divided into two files, and after downloading, two files are extracted to the same directory. In the path name, it is best not to appear in Chinese, and do not appear spaces

SELECT statement1. If...then statementsGrammar:If Thenplsql_sentenceend if;Condition_expression: Represents a conditional expression whose value is true when the program executes the PL/SQL statement below if;If the value is False, the program

RMANConfiguration$ rman target/or Rman target Sys/[email protected]Rman> Show All; all backup Related SettingsRman> CONFIGURE controlfile autobackup on;Rman> CONFIGURE controlfile autobackup Clear;rman> backup tablespace users; To back up a table

650) this.width=650; "Src=" http://images2015.cnblogs.com/blog/819681/201512/819681-20151202163739424-751270142. JPG "alt=" 819681-20151202163739424-751270142.jpg "/>1 Oracle Boot options;When the Oracle database is started on startup, Oracle looks

1. Database2. Primary key , the uniqueness of the table identifies a column, and the value of the primary key can never be heavy. Primary keyType of PRIMARY key: Single PRIMARY key: one column; Compound PRIMARY key: Multiple columns combine to act

The recommendation can be checked with a regular check: Data dictionary information/EXP export structure check1. CheckSELECT * from All_source t WHERE t.owner = ' to query user ' and T.type = ' Package BODY 'SELECT * from user_source where type = '

Oracle scalar queries and their own defined functions are sometimes easier to use, and are often used by developers. Small amount of data does not matter. The amount of data is large and there are often performance problems.Here is a test to help

First, Oracle downloadNote that Oracle is divided into two files, and after downloading, two files are extracted to the same directory. In the path name, it is best not to appear in Chinese, and do not appear spaces and other irregular characters.

Install the Oracle VM Virtual Box Install the extension Select "Manage"?" Global Settings " In the Settings dialog box, select Extensions Select "Add Package" Find "oracle_vm_virtualbox_extension_pack-4.1.18-78361" and click "Open"5. Click

I. Temp table space roleTemporary table space is mainly used in the database for sorting operations, management index, access to the view and other operations to provide temporary computing space, when the operation is complete after the system will

1. Check the master standby sync status2. Turn on the flash back function and flash back directory of the standby library3. Cancel the recovery process for the repository4. Create a restore point for the standby library5. Archive logs in the main

1. Check the current master standby sync status On primary SelectADS.DEST_ID,Max(sequence#) " CurrentSequence ",Max(log_sequence) "Last Archived" fromV$archived_log al, v$archive_dest ad, V$archive_dest_status

1. Check the status of the master standby library On primary columndatabase_role Format A20columnopen_mode Format A15columnprotection_mode Format A20columnswitchover_status Format