Oracle

OracleDatabase Data File Transfer Method Due to insufficient space caused by video data restoration, some data files need to be transferred to other hard disks. Based on some network materials and their own practicesOracleData File Transfer Method.

Recently, Oracle was used in a project. Due to the large database, each backup and recovery time was relatively long. In the past few days, I have successfully cloned the database by referring to a large amount of data, i'm delighted to share this

-- Create SequenceCreate sequence Sq1Minvalue 1Max value 999999999999999999999999999Start with 2001Increment by 1Cache 20; Sequence Creation   Create Table testpatition(GID number (10, 3) primary key,Gname varchar2 (36 ),Gdate date)Partition by

Execute immediate replaces dbms_ SQL package in Oracle8i.It parses and immediately executes dynamic SQL statements or PL/SQL blocks created when they are not running. The performance of dynamic creation and execution of SQL statements is advanced,

VPD stands for Virtual Private Database.TechnologyProvidesDataFine-grained access control of database information. For more descriptive information about VPD, seeOracleOfficial documentation:

In Oracle/PLSQL, The substr functions allows you to extract a substring from a string. The syntax for the substr function is: Substr (string, start_position, [length])Note:String is the source string.Start_position is the position for

This articleArticleThe main purpose is to analyze the storage space used for building the system to avoid the waste of storage device transition and save investment. It also improves the common usage of OracleDataType. IntroductionThe types are as

When the Oracle server is running on Windows and in dedicated connection mode, the client cannot be connected when the number of client connections reaches a certain value (about 400. At this point, the client typically gets a ora-12518 error.

. Net to access the Oracle database link: ORA-02041: client database did not begin a transaction problem. . Net to access the Oracle database link: ORA-02041: client database did not begin a transaction problem. . When accessing the object with

Oracle dynamic SQL can be written in two ways: dbms_ SQL or execute immediate. The latter is recommended. The test procedure is as follows: 1. DDL and DML/*** DDL ***/BeginExecute immediate 'drop table temp_1 ';Execute immediate 'create table temp_

Solutions to Em-related problems in Oracle 10 GB The EM in Oracle 10 Gb adopts the web form to manage databases and related services. However, some em-related problems may occur during use. Based on the prompts from the peers and the actual

1. Two Ways to delete table data A. Delete * From my_table; B. truncate table my_table; 2. Delete the entire tableDrop table my_table; How can we recover tables accidentally dropped? In fact, Oracle also has a similar "recycle bin" For

I. Table integrity and constraints Entity Integrity: primary key constraintsDomain integrityIntegrity of reference: foreign key constraints Select constraint_name, constraint_type from user_constriants where table_name = 'emp '; 2. Manage

Batch Oracle operations: Syntax begin end UpperCode: Update_is_defluat 1Public Static StringUpdate_is_defluat ="Update neorule set isdefault =: isdefault {0} Where id =: Id {0}"; Front-end code 1 Dictionary String , String > Dict =

Insert into sammy_test_clobSelect to_lob (report_xml)From qm_s_reportWhere report_name = 'sammy '; To_lobFunctions andLongThere are many restrictions on the same type. To put it simply,To_lobGenerallyCreate TableOrInsert tableSubquery after

Oracle's system is too huge. For Beginners, it is inevitable that they will not start to feel like they want to learn anything, and the results will not be good. So share their learning experience, we hope that the beginners will have a general

 In Oracle, an error is often reported: the account is locked. Almost all beginners will encounter this error. In fact, the solution is very simple. Enter the User Name: System Enter the password: Admin(Note: This password is set in the first

Execution environment: it can be executed in sqlplus. EXE or DoS (command line, When dos can be executed, the \ ora81 \ bin installation directory in Oracle 8i is set to a global path, The exp. EXE and imp. EXE files in this directory are used for

Developers and DBAs have two different roles. In actual work, the two roles can help each other, communicate with each other, and jointly complete the project. But in fact, developers need some basic Oracle knowledge to make better and more

       I believe that many system administrators are doing the same job every day-backing up data. Once the system fails and data recovery is required, the system is powerless. It would be nice to set a fixed time every