Oracle

Recently the company switched the original database server. Not before the whole piece, but also a bunch of degrees Niang. After a constant groping, finally succeeded. Now it is hard to record this hardship, to facilitate their later access to the

1. Viewing Active session Information[SQL] View plain copySELECT *From V$sessionWHERE USERNAME is not NULLand STATUS = ' ACTIVE 'ORDER by Logon_time, SID;Note: status is used to determine session stateActive: Executing SQL statement (waiting

The experiment environment creates two PDB, this experiment realizes when the database is opened, realizes pluggable database PDB2 self-start:Original environment:Sql> Shu ImmediateDatabase closed.Database dismounted.ORACLE instance shut down.Sql>

Operation Steps:1, DLL download and reference (this DLL is actually oracle for C # specifically provided, in its official can also download to the Oracle website): Oracle.ManagedDataAccess.zipAfter downloading, place the Oracle.ManagedDataAccess.dll

　　Control File Description:Each Oracle generates at least one control file, and one database can have multiple control files, but a control file can belong to only one database.In addition to the database name and its creation date, data files, log

Virtual Machine Files:Http://pan.baidu.com/s/1pJL5TubBackup one to prevent invalidationHttps://pan.baidu.com/s/1nvbZQadReadme file:Database version:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionLinux version:Red Hat

Open Https://localhost:5500/em, Login failed with two accounts (Sys;change_on_install) and (System;manager)Resolved in the following ways:(1) Enter Sqlplus Sys/change_on_install as SYSDBA on the Windows command line(2) Modify the SYS account

Tossing an afternoon, a few pits, and finally with PL/SQL connected to Oracle, tanning pits experience.First go to the Oracle website 12c, the official website has the login verification, if not registered, first register it. The database

The 7- bit Oracle database mounted on Win , and then loaded with a three-bit Oracle client, connected with Plsql when Oracle occurs , only user name, password, database fill or select box, there is no "login as" (role) selection box. Solution: 1

First, the development environment requirements: The premise is that the computer must have an Oracle client installed. Installed the Pl-sql software Second, configure PL-SQ and connect Oracle Configuration method: 1.

1. Acquisition of the CentOS image on the virtual machine. It is recommended that the CentOS7 version of the NetEase Mirror Station (other open source mirror stations may also). Here are the

Recently used Statspack on a customer's 8i production library. Found an error in alert:Mon June 16 13:17:52 2014Errors in FILE/ORACLE/8.1.7/ADMIN/PROD/BDUMP/SNP0_96626_PROD.TRC:Ora-12012:error on Auto execute of Job 304Ora-01631:max # Extents (505)

Process Control function DECODEIntroduction to the Decode () function:Main functions:Translate the results of the query into other values (i.e. in other forms, as illustrated below);How to use:Select decode (ColumnName, value 1, translation value 1,

It is slow to add a NOT null field before 11g. It was soon after 11g. Let's do a test first and then explore the principles.Sql> select * from V$version;BANNER----------------------------------------------------------------Oracle Database 10g

The actual project, backup data is an indispensable step, complete the automatic backup of data to reduce the workload of individuals, is our goal. There have been few scripts written before, but these simple operations can be done! Not much to say,

Auditing (Audit) is used to monitor database operations performed by users, and audit records can exist in data dictionary tables called Audit Records: SYS stored in the system table space. aud$ tables, which can be viewed dba_audit_trail view) or

I am learning Oracle is to do notes and experimental code records, the content is very full, but also quite detailed, send a blog post to the needs of friends, a total of 1w learning notes. is done before, has been at the bottom of the pressure,

Introduction: Usually when you do the project, often encounter the Oracle stored procedures to the project site to test the system. In this case, if you want to keep your own stored procedures confidential, do not let others see the source code, you

1. Page DesignPage A has several region, one region for file list management (contains display, download. Delete). A.In page A There is a button, click it will invoke page B, page B is responsible for file upload. B.Figure AFigure B2. database table

About one weeks before and after, this afternoon (first with the navicat) when I try to put the user name above the complex option from the service name to Sid , unexpectedly connected to the success of the moment, the whole person is a B, so