Oracle

Oracle's Extract function // The extract () function in oracle is introduced from oracle 9i. It is used to Extract a specific part from a date or interval type. // The syntax is as follows: EXTRACT ({YEAR | MONTH | DAY | HOUR | MINUTE | SECOND} |

I. Basic commands 1. Get help $ Exp help = y $ Imp help = y 2. Three ways of working (1) Interactive Mode $ Exp // enter the required parameters as prompted (2) Command Line $ Exp user/pwd @ dbname file =/oracle/test. dmp full = y // enter the

  In Oracle:   Double quotation marks are used to indicate that when an object is created, the object name and field name are added with double quotation marks, indicating that Oracle will be case-sensitive. Otherwise, each else will be capitalized

I. backup solution:Multi-level backup is used to reduce the time required for recovery and the time required for daily backup, while ensuring that the system recovers well.The following is a recommended solution:Full backup of a database every six

ORACLE Database kill session operation   Bytes ----------------------------------------------------------------------------------------------- 1. view the locked tableBytes -----------------------------------------------------------------------------

Oracle manual recovery case 1: Historical logs are not overwritten 1. first, cut the database into non-archive mode: startup mountforcealter database noarchivelog; alter database open; view database mode again sys @ SIQIAN11> archive log

Oracle Installation process physical memory check and temporary temp space insufficient solution physical memory-this prerequisite will test whether the total physical memory of the system is at least 922 MB (944128.0KB ). Expected Value: N/A actual

The backup and recovery parameters of the parameter file include initsid. ora (Text parameter file) pfile (Text parameter file), spfile (binary parameter file) Three pfiles and spfile can be converted to each other (copy ): create spfile = 'path'

The following is a summary of the problems encountered when oracle 11g uses deferred_segment_creation to create a feature. Problem 1: You can create tables in all tablespaces. Problem 2: exp cannot export empty tables. Problem 1: Version: oracle 11.2

[Oracle]-[show_space and show_space_asm]-Run the Stored Procedure show_space and show_space_asm to report errors. Sys creates show_space () and show_space_asm (). Bisal execution prompt: SQL> exec show_space('MY_OBJECTS', 'BISAL');BEGIN

Oracle 11g RAC executes root. sh encountered CRS-0184/PRCR-1070 problems Oracle 11g RAC installation, at the first node execute root. sh encountered a CRS-0184/PRCR-1070, Google a lot of posts have not found a solution. Hey, let's calm down and look

ORA-01795: List of the maximum expression number is 1000 solution detailed system error, dizzy, I began to find, the original really have a problem, take a look at SQL, it turns out to be an SQL statement containing IN, while IN contains a large

[Oracle]-[LRU and DBWR]-LRU algorithm and Applications in DBWR the Oracle architecture often see LRU algorithm, Least Recently Used, this is also called the "least recently used page replacement algorithm". In short, Oracle will remove databases

Oracle-RMAN backup (2) in Oracle RMAN backup (1), the backup of various files in RMAN is described. backup sets are replicated in RMAN backups. You can back up your own backups. That is, you can back up a file in multiple directories. oralce

To enable password management, a user created before connecting to Oracle reported ORA-28002 is actually easy to handle as long: Alter user identified by ;After this operation, a simple test is conducted as follows: [Plain] SQL> conn hr/hr ERROR:

Oracle Database TableSpace and archive [SQL] -- TableSpace (TableSpace) is a pioneering concept of Oracle. Table space makes database management more flexible and greatly improves database performance. -- Function: 1. avoid the risk of sudden

ORACLE Database view User information using the default password after the Oracle database is created, many auxiliary users will be created. If these user accounts do not change the password, they will all use the default password, the default

Partition Table Study Notes (2) -- partition management main content: 1. Add new partition 2. split partition 3. Merge partition Merge 4. Move partition 5. Truncate partition 6. drop partition --------------------------------------------------------

[Oracle] Data Guard series (6)-role conversionThe core function of DG is to provide high-availability Disaster Tolerance. Therefore, the role conversion content described in this section is the most important part of DG. Role Switching between

Oracle Database recovery and backup 1. oracle database recovery 1. restore the deleted data. delete from emp e where e. empname = 'Smith 'select * from flashback_transaction_query f where f. the statements below table_name = 'emp' UNDO _ SQL are the