Database Administrator

Impdp experience ORA-39001, ORA-39000, ORA-39142 Expdp/impdp because the source data version is higher than the target database version, encounter ORA-39001, ORA-39000, ORA-39142, solve only need to expdp export with the target data version, the

Considerations for new features of Oracle 11g After upgrading from Oracle 10g to Oracle 11g, you need to understand the new features of Oracle 11G. These features may affect the application and performance and need to be adjusted. 1. Oracle11g

"TNS-03505: unable to resolve the name" Problem Solution case, tns-03505 case  1. Problem A developer adds an ORACLE client in a windows environment and configures "tnsnames. ora, prepare to connect to the ORACLE database Linux environment, with

Practice: oracle timesten 11.2.2.7.0 on centos 6.5, timestencentos Entry level, but the steps are more detailed, there is no theory, can be used as an entry manual.   **************************************** * ******************************** 1.

Redis VM and RedisVM This article is original freas_1990, reprint please indicate the source: http://blog.csdn.net/freas_1990/article/details/42052813 When the value of a key of Redis is swap to a file, the RedisObject to which the value of the

Regarding the differences between Fusion OBIA and otbi data Analysis methods, Oracle Fusion data analysis can be divided into two forms: 1. OBIA This type of Fusion is similar to EBS and PSFT. It requires Fusion DB to extract, transfer, and load

Official oracle and oracle website Oracle SQL for report It was freezing, and I stayed at home and read "Mastering Oracle SQL" 2nd. I found that Oracle is still very powerful, and there are two hundred optical functions. It is difficult to simulate

Simple tutorial on SQL statements in linux --- UNION, simple tutorial --- union UNIONThe purpose of the command is to combine the results of two SQL statements. From this perspective,UNIONThis is somewhat similar to JOIN, because both commands can

Create users and tablespaces and create user tablespaces Oracle 11.2.0.1 1. Create a new user default tablespace DCSOPEN_TBS: Note: (1) The initial data file size is set to 200 MB, and the AUTOEXTEND attribute increases automatically by default.

[Logback + slf4j] correct configuration and error handling of Mysql DBAppender, logbackslf4j Prerequisites: jar package Required packages: Logback-core-0.9.8.jar Logback-classic-0.9.8.jar Slf4j-api-1.6.8.jar When writing this article, the latest

ProgressWheel: progress bar of the Android open-source ring, This is a custom Android component that replaces the standard progress bar component. Implement various progress bar styles, including rings and scans. XML:Add the following to your attr.

SQL statement records, SQL statements Query all surgical appointments and the corresponding schedule. If the pk is not null, separate them with commas ). The SQL statement in mysql is as follows: Select distinct. pk,. surgeryName,. clerkName,.

Mysql is configured based on binlog master-slave replication and mysqlbinlog master-slave The last time I configured the master-slave replication for mysql was at the beginning of the year, I did not expect to start using mysql again. If you don't

ORA-12801, ORA-08103, ora-12801ora-08103 I. Version Information Operating system version: AIX 61009 Database Version: 11.2.0.3.11 (RAC) Ii. Error description R & D response, today they report a lot of Process "ORA-12801: parallel query server P004,

View two common SQL statements used by the tablespace and two SQL statements used by the tablespace 1. view the tablespace size: SELECT tablespace_name, SUM (bytes)/1024/1024 total FROM DBA_FREE_SPACE group by tablespace_name order by 2 DESC; SQL>

Explore Oracle Database Upgrade 4 11.2.0.4.0 PSU 11.2.0.4.3, oracle Database Upgrade Explore Oracle Database Upgrade 411.2.0.4.0 PSU 11.2.0.4.3   1. Check the current database PSU Number: [oracle@db01 ~]$ cd/DBSoft/Product/11.2.4/db_1/OPatch/[oracle@

Phpmyadmin creates a database and sets the default encoding, phpmyadmin Encoding The database is used for php projects. When creating a database, you will inevitably enter Chinese characters. However, in the SQL command console, when the SQL

Mybatis calls the mysql stored procedure, mybatismysqlCreate a stored procedure: DELIMITER $$USE `test`$$DROP PROCEDURE IF EXISTS `user_user_selectUserByProAndCity_sp`$$CREATE DEFINER=`demao`@`%` PROCEDURE `user_user_selectUserByProAndCity_sp`(IN

SQL efficient paging (Millions of data records) and SQL Paging Reference: SQL paging statements Method 1: the most efficient Select top page size * FROM (SELECT ROW_NUMBER () OVER (order by id) AS RowNumber, * FROM table1) as a where RowNumber>

In Debian, Vbox only displays 32-bit systems and debianvbox   After Vbox is installed in Debian, a virtual machine is created and only 32-bit version is found. For example:     In fact, the operating system and Vbox installation packages are 64