Oracle

1. Create a directory to save the backupMkdir/u01/oracle/oradata/archiveChown-R oracle/u01/oracle/oradata/archive2. Switch to an oracle userSqlplus/nologConnect/as sysdba3. Set the target address of the archived log Check whether the database is in

Memory optimization has always been the top priority of database or operating system optimization. In the Oracle database architecture, memory optimization is also the key to performance optimization. The memory optimization mainly improves the

Sudo ln-s/usr/bin/awkSudo apt-get install libaio-dev sysstat build-essential \ gcc make binutils lesstif2 libc6 libc6-dev rpm libmotif4 \ libaio1 libstdc ++ 6 alien autotools-dev ksh libltdl-dev \ libtool lsb-rpm unixODBC-dev unixODBCSudo groupadd

The data dictionary dict always belongs to the Oracle user sys.1. User:Select username from dba_users;Change PasswordAlter user spgroup identified by spgtest;2. tablespace:Select * from dba_data_files;Select * from dba_tablespaces; //

Recently, when inserting data, I encountered the BUG of "ORA-01461: Can only assign values to the LOGN values of the inserted LOGN columns ". The data type in oracle is varchar2 (4000 byte). The inserted data cannot exceed 4000. Changes to varchar2 (

Insert multiple tables.Most insert operations are for a single table. However, oracle supports insert statements for multiple tables. In terms of data warehouse extraction, transfer and loading (ETL, Extract Transform and Load) routines, you will

We know that Oracle 10 Gb introduces the recyclebin concept. When we delete a table without specifying purge, the system only renames the table to the name starting with BIN $, modify related data in the data dictionary.In the Administrator's Guide,

    In Oracle, four file system mechanisms can be used to store data. (A database may contain all the following types of files) · "Cooked" operating system (OS) File System These files are stored in the OS file system. You can use the OS tool to

Four features of transactions: ACID· Atomicity: all actions in a transaction either occur or do not.· Consistency: A transaction changes a database from a consistent state to one of the following.· Isolation: the impact of a transaction is invisible

  Two concepts are explained first:· Consistent read: the row to be modified is the Consistent read.· Current read: Get the block to actually update the row to be modified. The obtained result is the Current read.The tkprof report shows the

  Root @ localhost oracle] # vim/etc/oratab     1 $ ORACLE_SID: $ ORACLE_HOME: Y     ? 1 [root @ localhost oracle] # vim/etc/init. d/dbora     View sourceprint? 01 #! /Bin/sh   02 # chkconfig: 345 99 10   03 # description: Oracle auto start-stop

  Oracle 11.2.0.3 impdp error:   Gg2:/u01/backup> impdp dave/dave directory = backup dumpfile = pdba. dmp logfile = table. log tables = pdba table_exists_action = replace;   Import: Release 11.2.0.3.0-Production onWed Nov 16 12:35:19

  1. Install Character Set Character Refer:   Http://www.oracle.com/technetwork/database/globalization/index-085942.html   Generally. This tool is available when you install the oracle system.   Bash-3.00 $ which csscan /Orahome/oracle/product/11.2.0

  Package com. csdn. util; Import java. SQL. Connection; Import java. SQL. DriverManager;   Public class OracleUtil { Public static void main (String [] args) throws Exception { // Step 1 load the Driver com. mysql. jdbc. Driver Class.

After a SQL statement is used to add a partition filter condition, the cost increases by adding a filter condition to the query Partition Table in 10.2.0.1.0. The cost increases, because this is an oracle bug. Let's test it below: SQL> select * from

ORA-27302: failure occurred at: skgpspawn3 Applies to: OracleServer-Enterprise Edition-Version: 10.2.0.1 to 10.2.0.3This problem can occur on any platform. symptomsThe database can not start up due to the following errors: Errors in file ....... Trc

How to modify the sys password of ASM. Note that the sys password of asm is different from the db password. 10g: WINDOWS: orapwd file = /database/PWD . ora password = UNIX: orapwd file = /dbs/orapw password = although the password file can be

Oracle log mining solution preparation cd c: \ oracle \ product \ 10.2.0 \ db_1 \ BIN Sqlplus sys/slims as sysdba; -- check whether archive log list is in archive mode; -- If archive is not found -------------------------- shutdown immediate;

Using merge into for performance optimization sometimes the development team has such a requirement that a table and its backup table replace some fields in the backup table with the original table, when the data size is very large, it will be very

When oracle detects rollback for the remaining time to operate the oracle database, a large transaction needs to be rolled back, which is very slow. It depends on how long it takes to roll back. Find the following SQL statement on the