Oracle

1, modify the index segment storage parameters 03:31:28 sql> ALTER index scott.indx_ename DEALLOCATE unused; Index altered. 03:31:36 sql> ALTER INDEX Scott.indx_ename allocate extent (size 1m); Index altered. 2. Rebuilding index 03:32:48 sql>

Profile is a named collection of password limits and resource constraints. When an Oracle database is established, Oracle automatically creates a default profile and then assigns each user, and if not specified, the user will enable default profile.

When you activate a constraint using the Enable VALIDATE option, the error message is prompted if the data already exists that does not meet the constraint rule, and the activation constraint fails. The existing data must be corrected at this time,

This is one of the Oracle's original brothers asked me a question, and then some people asked the question: Use Oracle internal principles to describe the following procedures: 1, Sqlplus GYJ/GYJ@ORCL 2, Updatet_gyj set name= ' gyj1 ' where id=1;

Oracle range partition Table already has a maxvalue partition, how do I add a partition? You cannot delete the data in the MaxValue partition without affecting the online application. 1, create a partition tableSql> CREATE TABLE P_range_test2 (ID

Recently, the work needs to see the binary format of some fields, simply write some of the transformation of the function to facilitate the invocation. Record the code for use. Create or replace package Pkg_digit_conv as-converts a string to its

The Listagg function is a newly introduced aggregate function in oracle11g, and it can be used as an analytic function, of course. The function can stitch together a measurement column based on the ordering of specific columns within a group.

Calling Java program segments in stored procedures Software Environment: 1. Operating system: Windows Server 2. Database: Oracle 8i R2 (8.1.7) for NT Enterprise Edition 3, Installation path: C:\ORACLE Implementation method: 1, create a file

Do a simple dynamic query code in a stored procedure, such as: CREATE OR REPLACE Procedure Zxm_sb_gz_get (P_table in Varchar2, P_name in Varchar2, P_value in Varchar2, Outpara out Lntxdba.zxm_pag_cs_power.c_type ） As Begin Declare

Analysis of the powerful tools provided by functional Oracle for data statistics is similar to our common aggregate functions, but is completely different. Aggregate functions, the first grouping of data, and then the operation of each group of data,

Business rules and business logic can be stored in Oracle by program, which is a stored procedure. A stored procedure is a combination of SQL, pl/sql, and Java statements that enables you to move code that executes a business rule from your

This article describes an example of using a temporary table to resolve table conflicts in Oracle, with an example of creating a temporary table Platform: Windows SP3 server Database: Oracle 9.0.1.1.1 Site Description: Users complain that not

Oracle provides the function of security tags, that is, OLS, which is often said to enforce access control. The model is based on the BLP security model and is extended. The elements of the BLP model are security levels and scopes, that is, the

One, backup operations Standby set 1. Set up a backup tag Backup Database tag= ' full_bak1′; Note: Each tag must be unique, and the same token can be used for multiple backups to restore only the most recent backup. 2. Set the backup set size

DB file Scattered read For frequently accessed tables, if an index is not indexed or an appropriate index is not established, Oracle can only scan it for a full table, resulting in a large number of waiting events. When a full table scan, the data

Load balancing is to increase the overall performance by allocating the load evenly to each node in the cluster. Oracle RAC provides two ways to achieve load balancing, the first is pure technology, that is, when users connect, depending on the

The purpose of Flashback Before there is a flashback, if you are wrong to operate the data and have submitted, then want to return to the wrong operation, it will be a very troublesome thing. One might say that backup can be restored to the wrong

Stream is an extended application of Oracle's Message Queuing (also known as Oracle Advanced Queue) technology. Oracle Message Queuing resolves event management through publish/subscribe. Stream replication is just a data sharing technique based on

Example of invoking an Oracle stored procedure using a Ruby script: 1. First create Oracle stored procedure test: SQL> create OR REPLACE PROCEDURE test(p1 in varchar2,p2 out varchar2 ) is 2 BEGIN 3 select p1　　’ PROCEDURE executeD！’ into p2 from

1, the role of the lock ORACLE: A lock is a mechanism that protects a database object from being modified when it is being modified by another process or user. To prevent objects being modified by two different users at the same time, the