Oracle

If you need to view the general meaning of the error, run the following command: [plain] [root@localhost ~]# su - oracle [oracle@localhost ~]$ oerr ora 01507 01507, 00000, "database not mounted" // *Cause: A command was attempted that requires

Solution to Oracle database running errors: Error 1: ORA-01034: ORACLE not available After Oracle is installed and started, use sqlplus "/as sysdba" to log on. If you run any select statement, an error occurs: Select * from dictionary * ERROR at

I. Move data files: -You can use alter database or alter tablespace to move data files. 1. alter database method; -This method can be used to move data files in any tablespace. ◆ STEP 1. database: $ Sqlplus/nolog SQL> CONNECT INTERNAL; SQL> SHUTDOWN;

Based on my practical experience, this forum article (CCID technical community) provides some insights for Oracle learners. For details, see the following: Learning Oracle is a long and arduous process. If you are not interested but forced to learn,

O_date ("string to be converted", "format to be converted") must match the format of the two parameters. Otherwise, an error is returned.That is, the first parameter is interpreted according to the format of the second parameter.To_char (date,

1. What is the initial password after Oracle is installed?   Internal/oracleSys/change_on_installSystem/managerScott/tigerSysman/oem_temp  2. What is the initial Default User and password of ORACLE9I as web cache?Administrator/administrator   3. How

701. USER_MVIEWSAll materialized views owned by the current user in the database.702. USER_NESTED_TABLESThe nested table in the table owned by the current user.703. USER_OBJ_AUDIT_OPTSAudit options for user-owned tables and views.704.

501. DBA_COL_PRIVSLists all the privileges granted to columns in the database.502. DBA_COLL_TYPESDisplays all named set types in the database.503. DBA_CONS_COLUMNSInformation of accessible columns contained in the constraint definition.504.

Expdp IntroductionEXPDP command line options1. ATTACHThis option is used to establish an association between a customer session and an existing export role. The syntax is as follows:ATTACH = [schema_name.] job_nameSchema_name is used to specify the

① Determine whether it is an Oralce database:And 0 <> (select count (*) from dual) returns the normal page, which is represented as an Oracle database.② Number of fields to be guessed:Use order by or group by to submit numbers one by one until the

After Incomplete recovery, the database may not meet the recovery requirements. At this time, the database has been opened in the resetlogs mode. If the database is not fully backed up before Incomplete recovery, at this time, I want to restore some

Oracle log mining command 1. Log Mining 1.1 supplement log command (log contains rowid) alter databaseadd supplemental logdata;  1.2 DML-based log mining example: SCOTT updates a record. I want to mine the operation time and SCN, as shown in

The oracle Stored Procedure exception is caught in oracle. [SQL] // SQL Execution exception when others then dbms_output.putline ('exception ');  Others indicates that an unnamed exception is caught. Other exceptions include Access_into_null: the

Oracle11G Silent Installation Process-linux environment 1. operating System and Oracle version Linux version: CentOS release 5.5 (Final) Oracle version: Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86-64 release) 2. hardware Detection:

Oracle Database performance optimization provides four different adjustment levels for ORACLE database data access. The first adjustment is the operating system level, including the hardware platform, the second adjustment is the oracle rdbms-level

Failed to create slave uard slave database by GC: A New Slave database must be created in the original slave uard environment (one master and two slave databases) due to business growth. However, the Standby database fails to be created through grid

Oracle Database status query Startup status SQL statement result nomountselect status from v $ instance; STARTEDselect open_mode from v $ database; ERROR at line 1: ORA-01507: database not mountedmountselect status from v $ instance; MOUNTEDselect

Oracle V $ SESSION SADDR session addressSID session identifier is often used to link other columns SERIAL # SID may be repeated. When the SID of two sessions is repeated, SERIAL # is used to differentiate sessions (in other words, a session is

CBO learning ---- 03 -- Selectivity CBO learning --- Chapter 1 -- Table scan (Tablescans) http://www.bkjia.com/database/201307/229069.html Chapter 2 Single Table Selectivity is the optimizer to estimate Rows (Cards) important Basis. /****************

[SQL] Three Methods of Oracle paging Query use the pseudo column rownum to query the first 10 records [SQL] select * from t_user t where ROWNUM = 10; based on the student ID ranking, 10 records are extracted starting from 10th records. [SQL] SELECT