Oracle

ORACLEprimary system tables and system views 1.system Tables ORACLEthe system parameters of the database are stored in the database and can beSQLPLUS, to the userSYSto query. A few important tables or views are as follows:V$controlfile: Control the

Extending the capabilities of the database Provide SQL functionality access to PL User SYS owns all packages It's a public synonym. can be accessed by any user Some built-in packages Package Name

Preface:                      cannot guarantee 100% pass, each system will be more or less different, If some of the dependencies are missing, please also forgive  1, install Apache need to compile and install the package, the official website

$ adrciadrci:release12.1.0.2.0-Production on Tue Nov - the: to: to -Copyright (c)1982, the, Oracle and/or its affiliates. All rights reserved. ADRBase="/u12/app/oracle"Adrci>Show log; ADR Home=/u12/app/oracle/diag/rdbms/ora12/Ora12:****************

The following issues occurred when importing. dmp files to Oracle with Plsql:Import started on 2015/11/18 10:42:44E:\oracle\product\10.2.0\db_1\bin\imp.exe Log=c:\users\lrb\appdata\local\temp\plsimp.log file=e:\work\doc\2015-0 ~1\2015-09-11.dmp

. Basic query StatementsSELECT [DISTINCT] column_name1,... | *From table_name[WHERE conditions];　　The role of the P:DISTINCT keyword is to filter out duplicate records.. Querying all fields in a table and specifying fields　　 querying all fields in a

First, the numerical function1. MoD (m,n) to find the remainder functionNote: if m or n is null, NULL is returned. If n is 0, the value of M is returnedeg2. Round (M[,n]) roundingIf n has no value, the default is 0, which is equivalent to

I. Description of the RowNumWith regard to Oracle's rownum problem, many of the data say that the ">, >=, =, between...and" Operators in SQL statements are not supported, and can only be used with the following operation symbols "Not to say ">, >=, =

1. Backing Up the NON-CDB database2. Close the NON-CDB databasesql> shutdown immediate;3. non-cdb to read-only statussql> Startup Open Read Only4. Create an XML file (created in non-cdb)sql> begin Dbms_pdb.describe (pdb_descr_file='/tmp/test.xml')

This event is definitely the last technology event in Oracle database!This technology event, sponsored by Oracle University, the Oracle Western User group, Chongqing si Zhuang Technology Co., Ltd. full sponsorship!This technical lecturer-China West

2015-10-24DirectoryResources[1] Management and maintenance of ASM under oracle11g RAC[2] Oracle 11g RAC with ASM installed on RHEL5 (simplified version)[3] Oracle 11g r2+rac+asm+oraclelinux6.4 installation details (figure)[4] Oracle11gr2+asm

First, install the Oracle databaseEnvironmental checks are performed prior to installation:1. Check the system version#uname-A2. View memory Size#/usr/contrib/bin/machinfo | Grep-i Memory3. View Swap Size#/usr/sbin/swapinfo-a4. Disk space size#bdfA

21, stored procedures, simplify complex operations, increase data independence, improve security, improve performanceCompare with function creation:The Create or Replace function fun_01 (v_01 in number) return number--must require a return value

With its native Oracle 12c installed, the company's platform needs to support both Oracle and SQL Server, often with the need to synchronize data from Oracle to SQL Server. The purpose can be achieved through the SQL Server link server, but because

[Experiment-Video process] Simple and useful backup-oracle physical cold backup operationMainly to the database to use the important files for targeted backup, data files, control files, online log files, archive log files, parameter files, password

RMAN for Data block recoveryRman can be used to achieve data block-level data recovery, in the traditional recovery means that a data file block is damaged, resulting in the entire data file can not be tried,The entire data file must be recovered

I. Modifying table space size Solution to the above problem: by increasing the table space can be resolved as follows:SQL code log in with a DBA user Sqlplus/ as SYSDBA;    execute the following command: SQL > ALTER tablespace

Oracle large table cleanup truncate... reusestorage Recently, a large table needs to be cleaned up, which requires no impact on performance. In MySQL, we can minimize I/O by using coreutils and hard links. Oracle can also minimize I/O by recycling

Prepare the VNC environment for installing oracle11g under the centos Virtual Machine of Microsoft cloud The company is preparing to use Microsoft ECs, so we need to test it first. oracle11g also needs to be migrated to Microsoft ECS.1. Check

Get the corresponding information from date, and get the corresponding information from date Create a test table: Create or replace view v ASSELECT TO_DATE ('2017-5-5 13:14:15 ', 'yyyy-MM-DD HH24: MI: ss') AS c from dual; SELECT * FROM v; The