Oracle

+---------------------------------------------------------------------------+ General Ledger Management system: Version:12.0.0copyright (c) 1979, 1999, Oracle Corporation. All rights reserved. Gltrbald module: Trial Table-Detail +--------------------

1. Start the CDB and PDB databasesSql> select Con_id,dbid,name,open_mode from V$pdbs;con_id DBID NAME Open_mode---------- ---------- ------------------------------ ----------2 1226396669 pdb$seed READ only3 411454583 DB12CCD MountedSql> Alter

1. Startup optionsORACLE will find the initialization parameter file in the default location $ORACLE _home/dbs (unix/linux) when starting the database when the startup command is issued. Oracle will look for the appropriate initialization file in

The process is as follows:1-Confirm the following installation package, if not installed, find the appropriate package from the CD to install#rpm-qa | grep

The Oracle database object is also called the schema object, and the database object is a collection of logical structures, and the most basic database object is a table. Other database objects include: Synonyms synonyms are an alias for an existing

A tablespace table space is a collection of one or more data files, all of which are stored in the specified table space, but are primarily tables, so called table spaces.Partition TableWhen the amount of data in the table is increasing, the query

There are four main functions in Oracle that support regular expressions:1,regexp_like: Similar to the function of like2,REGEXP_INSTR: Similar to the function of INSTR3,REGEXP_SUBSTR: Similar to the function of SUBSTR4,regexp_replace: Similar to the

Oracle has a high-speed buffering concept, which is to store executed SQL statements, which Oracle does a lot of work when executing SQL statements, such as parsing SQL statements, estimating index utilization, binding variables, reading blocks, and

Overview of Oracle's main processesData write Process (DBWR): Responsible for writing changed data from the database buffer cache to the data fileLog write Process (LGWR): Writes changes in the redo log buffer to the online redo log fileSystem

Some time ago learning Oracle To do the study notes, organized a bit, the following is a share of the Oracle common functions of some notes, and later will share other parts of the notes, please criticize correct.Use of the To_date () function in a 1

Oracle Two time subtraction default is the number of daysOracle two time subtraction The default is the number of days *24 is the difference between the hoursOracle two time subtraction The default is the number of minutes *24*60 is the difference

1, the default processing Oracle in order by default is considered null is the maximum value, so if it is ASC ascending is the last, desc descending is ranked in the top2. Use the NVL function Nvl function to convert an input parameter to a specific

1 The difference between function and procedure1). You can understand that a function is a 2 of a stored procedure. A function can have no parameters, but a return value must be required, and the stored procedure can have no parameters and does not

"Go" Oracle Set operation functions: Union, intersect, minusThe set operator is specifically used to combine the results of multiple SELECT statements, including: Union, union All, INTERSECT, minus. When you use the SET operator, you must ensure

When programming with Oracle SQL, the syntax for SELECT into is often used, such as the following simple example:SET serveroutput ondeclare Var_score INTEGER; Var_name VARCHAR2 (): = ' Sheldon ';    BEGIN SELECT score to Var_score from STUDENT1

After creating the user, the user can not do anything, the login database will be reported Ora-01045:user Xiaoming lacks CREATE SESSION privilege; Logon denied error. At this point, we should give the user authorization. First, learn about Oracle's

In the same table, the data is archived by placing the row in the inactive state. Database, you can compress optimizations for those inactive row. While archiving is implemented, applications can be restricted from accessing only those data in the

ORA-12537: TNS: connectionclosed error handling process1. My colleague said that the oracle test failed to connect. The error is as follows: [oracle@pldb236 admin]$ rlwrap sqlplus powerdesk/pd141118@PD236SQL*Plus: Release 11.2.0.1.0 Production on

Oracle em webpage inaccessibleCheck the status of emctl status dbconsoleOracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 Copyright (c) 1996,201 1 Oracle Corporation. all rights reserved. https: // udbs01:

Case study of downtime caused by ORA-04031 errorsToday we met an ORACLE database downtime case. The following describes the causes of this database downtime case. In the analysis process, we will record the cause and effect of this case, accumulate