Oracle

One, the Oracle data dictionary is composed of the following views mainly:1The user view is prefixed with user_ and is used to record information about the users object2The . All view is prefixed with All_ to record information about the user object

Under normal circumstances to write data to the table first through the library, the library to tell the operating system, the operating system to find the disk, after 3 steps!Table----> Libraries----> Operating systems----> disksBare devices do not

First, the demandDatabase has a table car, need to create a view for this table View_car, and create a new user User01, give the query this view permissionsIi. Steps of implementation1, the Administrator CLGL login database, the new view

Today we used the partition of Oracle table, and by the way I wrote a few examples to say the partition of this table:First, create a partitioned table1. Range PartitioningPartitioning based on the range of data table field valuesFor example,

Manually start two instancesSu-oracleLsnrctl start-Suppose one instance is ITSM and the other is testExport ORACLE_SID=ITSMSqlplus/as SYSDBAStartupQuitExport Oracle_sid=testSqlplus/as SYSDBAStartupQuitAuto-start, can be set in/etc/rc.local, add the

substr (string, intercept start position, intercept length) //Returns the truncated string (containing the start position)Select substr (' HelloWorld ', 0,3) value from dual; --The returned result is Helselect substr (' HelloWorld ', 1,3) value

Triggers and sequencesCREATE OR REPLACE TRIGGER t_mstb_bds_data before INSERT on mstb_bds_data for each rowdeclare integrity_ ERROR EXCEPTION; ERRNO INTEGER; ErrMsg CHAR (n); DUMMY INTEGER; FOUND

Oracle Study--oem Login Error system environment:Operating system: Windows 7Database: Oracle 11gR2"Certutil-setreg chain\enableweaksignatureflags 8", will prompt:650) this.width=650; "src=" http://blog.itpub.net/attachment/201402/25/25116248_1393298

Transferred from: http://blog.csdn.net/laoshangxyc/article/details/8615187Continuous update ...Oracle AWR Report Detailed DB Name DB Id Instance Inst Num Startup Time Release RAC ORCL

The Oracle data discusses char, varchar, VARCHAR2 data types:These three types are the most we use, in the database we how to use it?The length of 1.CHAR is fixed, with a maximum of 2000 strings:2.VARCHAR, VARCHAR2 can be sure that the Carchar data

Using an associated query, the fields of two tables define different types. One field is the VARCHAR2 type and the other field is the number type, with the following contents: ' 00187 ' and 187. In use, it is found that the VARCHAR2 type is

Enter the DOS interface. Enter the SQL file directory. Run Sqlplus,c:\sql>sqlplus user_name/[email protected]_service_name at the command prompt Specify the SQL execution log file, log filename arbitrary, but must be a log suffix name:

The. NET Framework accesses Oracle databases in at least two ways, one using Microsoft's ADO, and the other using Oracle-provided odp.net.When installing VS, it comes with ADO, which comes with odp.net when installing the Oracle client.In terms of

Connecting to the Oracle Database helper class is to encapsulate the method that connects the Oracle database, just call it on the other page and do not need to repeat the write.Import Java.sql.connection;import Java.sql.drivermanager;import

Oracle BASICS (5): Multi-Table query I. Multi-Table query (1) simple multi-Table query  1. Multi-Table query mechanism 1) SQL: SELECT * FROM emp; -- 14 records SELECT * FROM dept; -- four records SELECT * FROM emp, dept; -- show 56 data records ??

Oracle basics-Introduction (first meeting)I. Overall introduction: Oracle databases and databases represent the basis of all Oracle database objects. Oracle is a large-scale relational database based on advanced Structured Query Language (SQL). In

Recovering an instance in a catastrophic environment of an Oracle database (1) The so-called catastrophic means that all database-related files are lost or damaged due to disk faults or other causes and cannot be repaired. Backup must be used for

ORACLE11G tablespace shrinking error ORA-03297: filecontainsuseddatabeyondrequestedRESIZEvalue The disk space in the test environment is insufficient, so drop some useless large tables, but find that the space has not changed, and df-h still does

ORACLE records the IP address of the connected user and the IP address of the Login Failed User The main function is to record the IP addresses of logon users and the IP addresses of Logon failures in oracle.1. You need to create a trigger to record

ORA-02049: Timeout: Distributed Transaction Processing waiting for Lock diagnostics In the formal environment, there are two databases A and B. dblink is built on Database A. The business is to update some tables in database A to database B through