Oracle

  Today, I made a simple test of database pressure and shared something. Server Status:   Operating system version: CentOS 5.6-64 Cpu: Intel (R) Xeon (R) CPU X5660 @ 2.80 GHz * 24 Memory: Mem: 16425876 Swap: 32764556 Database Version:

Create Table abcCreate table abc (a varchar2 (10), bvarchar (10 ));Add a columnAlter table abc add c number;Delete a columnAlter table abc drop column c;Delete tableDrop abc;Data Control Language,Grant select permissionGrant select on [tablename] to

This article briefly introduces how to register A database instance on one machine to another machine, for example, registering A database instance on machine A to machine B. 1. Check the status of listener of machine B before machine A registers

This article describes how to use RMAN in step by step mode. Generally, the directory database and target database of the Backup directory should be stored on different machines, where the two databases are on the same machine.Add in listener.

When a non-ORACLE user logs on to the database, the following error occurs:[Marven @ hpserver2 ~] $ Sqlplus "/as sysdba"  SQL * Plus: Release 10.2.0.4.0-Production on Wed Feb 1 15:55:07 2012 Copyright (c) 1982,200 7, Oracle. All Rights

Author: runming QQ: 226399587 http://blog.csdn.net/runming9181. Restore Flashback Table from RECYCLEBINTo put it simply, if we regard the flashback query as a recovery record, the flashback table is used to restore the table (because the record is

1. Introduction to shared pool: The location, parts, and functions of the Shared Pool; Ii. Set and view the shared pool size: In 9i, we use the Shared_pool_size parameter to set the size of the Shared Pool. Let's talk about the setting in 10 Gb. In 9

After successfully connecting to the database, check the listener status: lsnrctl status Status READY status, which must be switched from non-archive to archive. The operation is as follows: 1. Shut down the database shutdown immediate and shut

[Java]Orcale entry commandBasic commands:1. the spool command is used to screen recording in sqlplus.Spool c: \ 1.txt automatically creates 1.txt, screen recording Spool c: \ 1.txt appendAdd to 1.txt 2. conn system/orcl switch user connection3. --

[Root @ bt bin] #./sqlplus ./Sqlplus: error while loading shared libraries:/home/mnum/app/mnum/product/11.2.0/dbhome_1/lib/libclntsh. so.11.1: cannot restore segment prot after reloc: Permission denied Solve the Problem of libclntsh. so first: [Root

The database used by the customer is mysql, and the developed product supports oracle, We must switch the database environment from oracle to mysql. We encountered the following problems during the conversion process, hoping to give some reference

In oracle 10 Gb, a database is created. By default, three control files are created: control01.ctl, control02.ctl, and control03.ctl. You can manually add some control files to the database. When the data is opened, we can use show parameter control

Oracle SQLServer MySQL view all current database table names and other information environments: Oracle 11g + SQLServer 2008 R2 + MySQL 5.1 Oracle: 1. view All data tables in the current database [SQL] select * from all_tables; select table_name

Com. ibatis. common. jdbc. exception. nestedSQLException: --- The error occurred in --- The error occurred while applying a parameter map. --- Check the outwhbill. insertDtlHis-InlineParameterMap. --- Check the statement (update failed ).

During daily application development, filter-type local range scanning often encounters a need to determine whether a set that meets certain query conditions exists. In fact, this operation is essentially a special filtering operation, you need to

Oracle recursive query example analysis start with connect by Hierarchical Queries. areaid,. name,. parentid,. levelcodeFrom prnbsn_area a www.2cto.com Start With. areaid = 3 Connect By Prior. areaid =. parentid this query will find all sub-regions

Commands for adding log groups and log members in oracle 1. Adding a log group: alter database add logfile group 4'/oradata/oracle/oradata/oracle_sid/redo04.log 'size 100 M; 2. Change the log group size (First, check the archiving status: SQL>

In SQLPLUS, you can view the table structure in oracle, modify the table field in SQL statement 1, view the table structure in desc table name 2, modify the table field in SQL statement, and use the rename keyword to modify the field name:

Oracle SQL Summary 2: Set operator and DML Statement 3. Set operator 3.1 The set operator can only appear before the order by clause. Www.2cto.com 4, DML statement 4.1 SAVEPOINT from ORACLE SQL references Savepoint names must be distinct within a

Full Learning Guide for pl/SQL 3 large loops 1 loop overview each loop consists of two parts: the loop boundary and the loop body. The cyclic boundary consists of pl/SQL reserved words. Code located outside the loop body should not know the internal