Oracle

First, the principle of startup and shutdown of Oracle1. Oracle Boot Step AnalysisSql> Startup-This is the command to start the databaseORACLE instance started. --first stage, launch instance, Nomount stateTotal System Global area 608174080

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/43926321First

Case 2: Putting the database into restricted mode1. Open the database directly to restricted modeSql> startup RestrictORACLE instance started.Total System Global area 608174080 bytesFixed Size 1268920 bytesVariable Size 230687560 bytesDatabase

Oracle 11gR2 relink New featuresFrom:Oracle 11gR2 relink New Feature (document ID 883299.1)Suitable for:Oracle database-enterprise edition-version 11.2.0.0 to 11.2.0.0 [Release 11.2]Generic UNIXSolution:I) Oracle 11gr2 There are 2 ways to relink

Oracle has been released Oracle 12C for some time, Oracle this release only 64-bit version, and no 32-bit version. Our system installation environment is CentOS 6.5 x86_64. 1. Install Oracle Dependency PackageModify the Yum configuration by default

1, get the last day of the monthSELECT To_char (Last_day (to_date (' 20140125 ', ' YYYYMMDD ')), ' YYYYMMDD ') Lastday from DUAL2, get the last day of the end of last month:Select To_char (Add_months (Last_day (' 2008-08-08 ', ' yyyy-mm-dd '), -1),

I am borrowing to recommend others The purpose is to learn dbms_scheduler create chain type of job, as for executable type of job I have been in introduced. The following to the online related:Oracle CHAIN, which is a chain, connects a bunch of

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/43764267The

In the case of like, there are two forms of writing that are based on a 5% assessment of the total data.sql> drop table test purge;sql> CREATE TABLE test as SELECT * from Dba_objects;sql> exec dbms_stats.gather_table_stats (user, ' test ');Sql>

1.how to create a tablespace this employs the most common features1 CreateTablespace Tb_name #Createbigfile tablespace tb_name2DataFile '/U01/DBFile/Orcl/tb_name.dbf '3 size 100m4Autoextend onMaxSize 1000m #don ' t recommend UseThe Autoextend

SELECT ' EXEC sys.sp_addextendedproperty @name =n ' | | Chr (39) | | Ms_description ' | | Chr | | ', @value =n ' | | Chr (39) | | comments| | Chr | | ', @level0type =n ' | | Chr (39) | | SCHEMA ' | | Chr | | ', @level0name =n ' | | Chr (39) | | dbo '

The use parameters of the function are differentMySQL supports multiple string concatenation:CONCAT (STR1,STR2,...)Oralce only support two strings of stitching, if you want to stitch multiple strings can be nested use concatCONCAT (STR1,STR2)Two,

Used to learn. NET connection to a database, it also makes a variety of connection configurations. Now, while using Java to manipulate Oracle, there are also some operations. Here's a summary.1.JDBC_ODBC Connection DatabaseThis method requires an

Flashback is used to recover objects that the user mistakenly deleted (including tables, indexes, etc.) and does not support SYS users. Objects under the system table space cannot be retrieved from the Recycle Bin.Therefore, when using SYS or system

JobDescribe interval parameter valuesEvery night 12 o'clock ' TRUNC (sysdate + 1) 'Daily 8:30 A.M. ' TRUNC (sysdate + 1) + (8*60+30)/(24*60) 'Every Tuesday noon 12 o'clock ' Next_day (TRUNC (sysdate), ' Tuesday ') + 12/24 'Midnight of the first day

Oracle Scheduler Chain usage I am referring to other people's articles to learn about dbms_scheduler to create a CHAIN-type JOB. As for EXECUTABLE-type jobs, I have introduced how to . the following is an introduction to the Internet: The Oracle

Install oracle in linux and linux Storage records1. Steps for installing the database Ii. Download the database Address: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html3. View System Resources and Environment

Quick creation of DBLink SQL statements in oracle When dblink is created normally, you need to enable the listener on the target end, configure tns on the source end, and then check the configuration of the target database GLOBAL_NAMES. This is a

Detailed steps for building dataguard at ORACLE11G (all physical standby operations)Preface:DATAGUARD establishes a reference relationship by establishing a PRIMARY and STANDBY group. Once STANDBY is created, DATAGUARD passes the REDO of the PRIMARY

The database cannot be started because the access $ table is lost in oracle 11.1.0.7. Next let's take a look at oracle 11.1.0.7 may also see the loss of the access $ table, resulting in the database cannot be started. If you need to know, you can go