Oracle

This morning to the company, opened the computer and found that the launch of the Oracle instance, reported the following error:Oops, all of a sudden worried, the original still good how suddenly so? I recalled that it was my previous modified

I. ORACLE internal structure1. Table SpaceA tablespace is a logical division of a database, a table space belongs to only one database, each table space consists of one or more data files, and other logical structures in the table space are stored

In the common use of a database often encountered the problem of locking table, the phenomenon of occurrence.1. Stored procedures cannot be executed2, the query table data appears slowly3, the front end of the phenomenon of card deathThe data that

Basic syntax for user authorization: Grant permissions/role to username; Master2. Switch usersSwitch User basic syntax: Connect user name/password; Master3, xiaoming Change passwordChange Password basic syntax: password user name;Admin Change

A) UsersUsers in Oracle are divided into two major categories1) when the Oracle database server is created, users that are automatically created by the system are called system users, such as Sys.2) users created by the system users, called ordinary

/************** Date ********************/1.select trunc (sysdate) from dual--2013-01-06 today's date is 2013-01-062.select trunc (sysdate, ' mm ') from dual--2013-01-01 returns the first day of the month.3.select trunc (sysdate, ' yy ') from dual--2

Today in PL/SQL operation accidentally deleted some of the table data, this can frighten the ape, so quietly open the computer, hurriedly find Niang help. After the mother's small reptile help, a few minutes to restore the data.So how do I recover

View Buffer command: ListExecute save 1.sql can be saved by the buffer command.Execution @1.sql can execute the saved content;Show feedback Displays the feedback information, the last line.Show Echo onShow ArraySize 5000 View the number of rows for

The recent systematic study of Oracle SQL statement Performance Tuning has come to the conclusion that many performance tuning on the web is wrong or not comprehensive.Now the DBA Daniel are too low-key, not come out treatise, the younger brother to

1, if the number of Oracle connections to reach the upper limit, using Plsql to connect to Oracle, there will be no connection error, typical errors are:Maximum number of processes (exceeded)2. Restart the Linux machine (otherwise not connected),

Oracle implicit parameter modification and viewingAlter system set "_allow_resetlogs_corruption" =false scope=spfile sid= ' * ';Col name for A30;Col value for A10;SelectX.KSPPINM name,Y.KSPPSTVL value,Y.KSPPSTDF IsDefault,Decode (Bitand (y.ksppstvf,7

Create Oracle Tablespace and user/**/createtemporary'e:\tablespace\test_temp.dbf 'onnext 50m maxsize 20480mextent management local; /* 2nd step: Create a data table space */ create tablespace test_data Loggingdatafile " e:\tablespace\test_

First use is using: SYSDBA login Sqlplus/as SYSDBAIn the SQL command line, enter ALTER DATABASE open;This time it will be reported similar to "ORA-01157: Cannot identify/Lock data file 12-see DBWR trace file ORA-01110: Data file: ' E:\DBF\A.DBF '"

The Oracle tutorial you are looking at is: Renaming the foreign key for Oracle system tables.The foreign key of a table in Oracle is a means of guaranteeing system referential integrity, whereas referential integrity refers to a constraint

This article transferred from: http://www.cnblogs.com/suding1188/archive/2013/01/06/2848067.htmlThe use of the--oracle trunc () function/************** Date ********************/1.select trunc (sysdate) from dual--2013-01-06 today's date is 2013-01-0

Select To_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss ') from dual; --Show Current time2011-12-29 16:24:34Select Trunc (Sysdate, ' year ') from dual; -Interception to year (first day of this year)2011-1-1Select Trunc (sysdate, ' Q ') from dual;

AWR reportThe AWR report is a performance collection and analysis tool provided by Oracle 10g and above that provides a report of the overall system resource usage over a period of time, through which we can understand the entire operation of the

--insert a record into the tableCreate or Replace procedurepro_insertdept isbegin Insert intoScott.deptValues(' the','Dog','Dog'); Commit; Endpro_insertdept;--Executionbeginpro_insertdept; End;--define three input parameters, insert a recordCreate

Updating a field is simple and easy to understand: Update TableA a set a.name= (select name from TableB B where a.id=b.id) is more verbose when updating multiple fields: Update TableA a set A.name= (select name from TableB b where a.id=b.id), a.age=

--Current Date Select To_char (add_months (sysdate, 0), ' yyyy-mm-dd ') Pretoday from dual--last month current date select To_char (Add_months (sysdat E,-1), ' Yyyy-mm-dd ') Pretoday from dual--next month current date SELECT To_char (Add_months