Oracle

One, download the installation fileOfficial: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html [[email protected] data]# lsLinuxamd64_12c_database_1of2.zip Linuxamd64_12c_database_2of2.zip II.

For testing needs, we need to build a set of Docker Oracle 11g environment for testing in the Intranet test environment, test environment installs Docker 1.7, native Windows 7 environment for Redhat 6.6, installs Docker 17.121. Get the Oracle image

For most oracledba, the most common way to start and shut down an Oracle database is in command-line mode server Manager. From oracle8i onwards, the system will server All the functions of the manager are concentrated in Sql*plus, that is, starting

When more than one ORACLE service is installed under Windows, the system defaults to the last installed DB instance, and to switch instance login sqlplus, under the cmd window, first modify the value of Oracle_sid (set oracle_sid=xxxx, The

The current summary of the statement, in view of the data connection is very useful, after writing the program while testing the code side to see the release of database connections to help optimize the analysis of a robust system program.1.SQL code1

First, download the link addressHttp://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_database_1of2.zipHttp://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_database_2of2.zipLink acquisition, you must agree to the agreement, the

I. Overview　　What is the 1.SET operator?　To concatenate multiple queries into a new query with the SET operator　　　　　　Union/union all--and set　　　　　　intersect--intersection　　　　　　minus--difference Set (a\b=a the elements in B are removed)　　　　For MySQL,

Grammar1. Build a tableCREATE TABLE Table name (Column name data type,......);2, delete table:drop table name;3. Add column:ALTER TABLE name Add (column name data type);4. Modify column:ALTER TABLE name rename column name to column name;5, modify

Manual hot-Standby must be in the archive mode, read-only table space can not be hot-spare, temporary table space does not need to prepare.[email protected]> archive log list;——开启了归档Database log mode Archive ModeAutomatic archival

Today, I have encountered the problem of 11GR2 connection, before, because the application there is no in-depth inspection, did not find specific reasons, think of this version of the Oracle bug it.The last approach is to use the shell script to

Parsing statements:Sql>analyze index validate structure online;Analysis Table:Analyze table TableName compute statistics;Analyze index IndexName compute statistics;To view the index fragmentation situation:Sql>select

Recursion:SELECT *From t_pams_solution tStart with t.id is nullConnect by prior id = t.parent_idORDER BY level DESCThe red characters are the table name, the start condition, the child node and the root association condition respectively.Reverse

One menu way:Open Plsql, click "File"-"New"-"Database link" to open the window as shownAfter filling out the information, click "Apply" to complete the creation of the database link.　　Two-SQL mode-- Drop Existing Database link Drop Public Database

The role of Oracle's stored procedures 1. Stored procedures can make program execution more efficient and more secure, because the process is built and stored in the database, the direct write SQL needs to analyze and execute the process more

1.:Http://www.oracle.com/technetwork/cn/topics/index-088165-zhs.html2. Linux x64 and installation files for Windows can be3. Installed on Windows, Linux is temporarily not installed4. Go to the installation directoryOrion-help Viewing Help

Error message:[Email protected] grid]$./runinstallerStarting Oracle Universal Installer ...Checking Temp space:must be greater than MB. Actual 34027 MB PassedChecking swap space:must be greater than MB. Actual 3999 MB PassedChecking Monitor:must is

Now is the fashion to the highest level, the deployment of this project, good SQL Server threw it (there is a genuine authorized Enterprise Edition, God ... ), every person will boast: "We are on the top of the Oracle Database system! ”。 Look at the

How Does Oracle query duplicate data ?, Oracle duplicate data? -Query duplicate data Select tt. * from Table tt where custom conditions and tt. repeated field in (select t. repeated field from table t where custom condition group by t. repeated

Oracle uses expdp to migrate dblink (Tutorial), expdpdblink To create a dblink, you must use the dblink owner to log on to the database and create it in the current mode. If you do not know the database user password, you cannot directly create

After Oracle is successfully installed in Linux, start the sqlplus problem set (detailed description) and oraclesqlplus Note: The installation of Oracle cannot be performed by the root user, but must be performed by a new user. 1. The sqlplus