Oracle

The Oracle 11g listening and warning logs are both in the/u01/oracle/diag/tnslsnr/oracle/listener directory and the/u01/oracle/diag/rdbms/db1/ The DB1 directory has the following names, respectively, listener directories and DB1 directories. Both

To report the system environment in the usual way: Export environment: Operating system Release version :CentOS 6.5 OS kernel kernel version: 2.6.32-431.el6.x86.64 Oracle Version information: Sql> select * from V$version; BANNER----------------------

Using Maven to manage Oracle JDBC driver dependencies, it was found that adding Oracle JDBC dependencies by modifying Pom.xml files always prompts Missing artifact com.oracle:ojdbc14:jar:10.2.0.4. 0 Oracle JDBC dependencies can be found on the http:/

Oracle time operation (Get week) Orcle get all weeks in the time period (including Week 1st, Sunday Day, week of year) First you get all the dates for a period of time, and then you get each of the Monday, Sunday, and weeks of the time period.

Environment Description:Operating system: LinuxDatabase version: 11.2.0.4 begin~ CREATE TABLE Spaces TEST_TB sql> Create tablespace test_tb datafile '/u01/app/oracle/oradata/prod/test.dbf ' size 50M; Tablespace created.Create user test Sql> create

Clean up the old data, not very familiar with the operation, directly deleted the table space, did not delete the data file, HIS20170927 This tablespace has been deleted but the data file is still in place, a new table space is created directly on

Environment: RHEL 6.4 + Oracle 11.2.0.3 Scenario One: only some ordinary data file migration, can be online operation. 1. Offline The corresponding table space, move the data file to the new path 2. Data file Alter DATABASE rename file ' to '; 3.

Recently, in the forum, we often see someone using the WITH table as statement, generally building a temporary table for testing, after studying the use of this statement I understand the following benefits: 1 without the actual construction of the

The use of parameter files in Oracle startup generally has the following situations 1 Single Instance 1.1 starts by default: In non-RAC environments, the parameter files for Oracle databases are placed by default in the $oracle_home/dbs directory,

Spent two or three days to configure Oracle Enterprise Manager, referred to as EM, whether through the DBCA or EMCA commands are always failure, in the search for a lot of information without fruit, after a toss finally configured successfully, and

This article is reproduced to http://www.ecdoer.com/post/oracle-dictionary-table-sql.html Oracle Common Data dictionary table (system table or system view) and query SQL The data dictionary is where Oracle holds information about the database, and

conditions for the occurrence of an implicit conversion When the type of the source data and the type of the target data are different, if there is no conversion function, an implicit conversion occurs, also known as automatic conversion. Of course,

In the project database design process, because of the large amount of data in the single table, we need to partition the table. Because the data in the table is a historical transaction, it is divided by month to improve the query and management.

Immediately thereafter: http://ixdba.blog.51cto.com/2895551/882362 After the Oracle Clusterware installation is successful, start the installation of Oracle database, log on to any cluster node as an Oracle user, and start the installation by

ORACLE Advanced Function Application --Grouping functions 1, ROLLUP --Subtotal, total of statistical standard grouping and corresponding dimensions The Oracle GROUP BY statement also supports rollup and cube statements in addition to the most basic

The project uses the MyBatis to do the persistence layer, the database is Oracle, uses the batch insert function, because previously did is the MySQL, also did postgresql the database, the batch inserts the statement to be identical, but was not

Why should there be a constraint?Constraints: constraint is a keyword Constraints are meant to prevent invalid or problematic data flow into a table, the term is-"maintain data consistency." Constraints are rules imposed on a table, conditions. If

Experimental environment: SOURCE End: ip:192.168.40.10 Database:oracle 11.2.0.1.0 ORCL os:oel5.6 Ogg:fbo_ggs_linux_x86_ora11g_32bit Target side: ip:192.168.40.128 database:10.2.0.1.0 ORCL os:oel5.6 Ogg:fbo_ggs_linux_x86_ora11g_32bit First configure

Author: The source of Xiaoxiang: http://www.cnblogs.com/kerrycode/ ------------------------------------------type conversion function------------------------------------------------Automatic type conversion, ORACLE can automatically according to

--=========== 0:xserver PreparationInstall Xserver, configure Xshell--xming,xmanager,vcxsrv--=========== 1: Disk Partitioning and mountingcd/etc/yum.repos.d/# # SCP Ol6.repo root:10.198.15.105:/etc/yum.repos.d/RM