Oracle

http://episode.javaeye.com/blog/183016 The first time I ran a database test last week, I came across a lot of questions. Table Space:Oracle's UNDOTBS01.DBF file is too big a solution1. Prohibit undo tablespace automatic growthALTER DATABASE datafile

The origin of a table space is too large, after the deletion of data due to the end of the file is used, can not resize, intend to all the table space on the object move to a temporary storage table space to do collation. When you move a table to

First, view RAC Environment RAC Architecture, 2 node information Node 1 Sql> Show Parameter instance NAME TYPE VALUE ------------------------------------ ----------- ----------------------------------------------- Active_instance_count

Guide: 　　 Timed hot Backup (EXP) for an Oracle database can usually be implemented in two ways, one in the Oracle database Implemented by using the task Queue Manager provided by it (Job queue), or by using the operating system's timed execution

There are undocument functions in Oracle SQL that implement the functionality of reverse string, so can it be implemented in other ways? Here are a few ways to:1.undocument REVERSE FUNCTIONSELECT REVERSE (' Test REVERSE ') from dual;--Note that

Scenario Description: A friend asked, MSSQLServer to restore the database backup to other machines is very convenient, basically is a fool operation, Oracle has control files, parameter files a pile of things, Feel that the restoration is very

The retention policy for the recovery directory is configured, and then the recovery directory is backed up. 1 Set up the environment for the ORCL database. [Oracle@rtest ~]$ Export oracle_sid=test0924 2 starts RMAN and uses the recovery directory

1 Query Process 1 The process first checks the memory and the database cache area to see if there is a block of data that is needed. If it does not exist, proceed to step 2nd, and if it exists, proceed to step 4th. 2 If the query is started, the

This article from the following aspects to collate the concept and operation of the partition table:1. Table space and the concept of partitioned tables2. The specific role of table partitioning3. Advantages and disadvantages of table partitioning4.

016-09-27 14:36:09,802 ERROR [500.jsp]-Could not commit JDBC transaction; Nested exception is java.sql.sqlexception:ora-12048: Refreshes the materialized view "the". Check_form "Error ORA-12034: "Teenagers". The materialized view log on Ch_task is

How Oracle obtains system current time   Select To_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss ') from dual;    Oracle gets a time of year, quarter, month, week , the function of the day   select  to_char (sysdate, ' yyyy ')  from dual; --year     Select

Some simple process is not listed here, there are many online, here is the main write down some of the problems encountered, as well as solutions The environment of CentOS 7 is $ uname-a Linux Oracle 3.10.0-123.13.1.el7.x86_64 #1 SMP Tue DEC 9 23:06

1, with admin option With admin option means that the user granted this permission has the right to grant a permission (such as create any table) to another user or role, and cancellation is not cascaded. If you grant a system permission to create

first, start, close the database 1, start the various modes of the instance 1 start the instance, load and open the database This is the most common database operation, meaning that an instance has been started and the database has been loaded and

-Summary startup command as follows:Lsnrctl [Start|stop|status]-Start the listener, stop the listener, and view the state of the listener;NET [Start|stop] Oracleserviceorcl first, independent start-up: Microsoft Windows 5.00.2195 [Version](C)

Introduction to Functions The Lpad function fills the string with the specified character from the left. It is also understandable from its literal meaning that L is the shorthand for left, the pad is the meaning of the padding, so the lpad is the

First look at my own experimental environment is in what kind of archiving mode: Sql> Select T.log_mode from V$database t; Log_mode------------Noarchivelog Two. After determining that it is in the non-archive mode, I first create a regular table

Single-record functions in common Oracle function sql1.ASCIIReturns the decimal number corresponding to the specified character;Sql> Select ASCII (' a ') a,ascii (' A ') a,ascii (' 0 ') zero,ascii (') space from dual;A A ZERO space--------- ---------

Add_months: Add MonthSELECT Sysdate,add_month (sysdate,1) from DUAL;Sysdate add_months (sysdate,1)-----------   ---------------------03-1-8 16:2 03-2-8 16:21:59Plus Day:sql> SELECT sysdate,sysdate+1 from DUAL;Sysdate sysdate+1-----------   ----------

CENTOS7 silent installation of Oracle 11GR2 single-instance database1.vmware Minimized installation Centos7Allocate 20G HDD +2g memory +nat Network 400mboot+4gswap remove kdump minimize installation and configure