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

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

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:

[One Moss per day]-Fundamentals of the Large Pool the following describes the 'large Pool 'introduced from Oracle 8 '. What is Large Pool ")? A large pool is an area in SGA similar to a shared pool, but its usage is strictly limited. Only a few

In Oracle, the chr (38) type database oraclejavajavaEEsql chr (38) type chr () function in Oracle converts ASCII code to character: character-ASCII code; ascii () the function converts a character to an ASCII code: ASCII code-character. In oracle,

Top 10 physical segments of Oracle databases select owner, name, type, mega, tbs from (select owner, case when segment_type = 'LOBSEGMENT' then logical_name else

Brief Introduction of oracle imp and exp commands for data migration, especially migration between different versions and between different systems, can be completed using exp/imp. Of course, we recommend that you use expdp/impdp to import and