Common Oracle ebs dba SQL-installation/patch

Common Oracle ebs dba SQL-installation/patch Common Oracle ebs dba SQL-installation/patch Check whether the application patch is installed:Select bug_number, last_update_date from ad_bugs where bug_number = '& bug_num '; Check which languages are

Solve the problem of Chinese garbled characters stored in MySQL 5.5 and hibernate

Solve the problem of Chinese garbled characters stored in MySQL 5.5 and hibernate When using hibernate and mysql for data storage, you will find garbled characters in the database if you store Chinese characters. The solution is as follows: Change

Whether the path change of the bare device in ASM affects the operation of the database

Whether the path change of the bare device in ASM affects the operation of the database Use asm to store database files. In linux, you can use asmlib to manage Block devices, or use bare devices to create an asm disk. In asmlib mode, changing the

Blob field value for accessing the Oracle Data Link

Blob field value for accessing the Oracle Data Link Access photo table Select * from zp @ dblink1 where a1 = '201312 '; Error: The ora-22992 cannot use the LOB locator selected from the remote table Change to the following method: Method 1:Drop

Create partitions on the 11g virtual column of Oracle

Create partitions on the 11g virtual column of Oracle On Oracle 11g, partitions can be performed on virtual columns. This feature is useful. Let's perform a test: SQL> select * from v $ version; BANNER-------------------------------------------------

Oracle FGA Audit

Oracle FGA Audit You may be familiar with trigger, but Oracle also has a function named FGA. It works like trigger, but it is more powerful. its full name is Fine-Grained Audit, which is a special method of Audit. to use FGA, you only need to call

ORA-01861: Text and format strings do not match error handling

ORA-01861: Text and format strings do not match error handling An error is returned when the following materialized view is created.Create materialized view BBBRefresh complete on demandAsSelect a. vbillcode,B. invname,Del. exchdateFrom AA @ AAInner

ORA-16456 error, because the slave database is not mounted and the master database to perform switching, detailed solution

ORA-16456 error, because the slave database is not mounted and the master database to perform switching, detailed solution If you need to switch the master database to the slave database, the prerequisites are: (1) The standby database must be in

Cannot set user id: Resource temporarily unavailable

Cannot set user id: Resource temporarily unavailable A while ago, Infra reported that the database server could not be connected through putty and SecureCRT. The error message is Resource temporarily unavailable. Since there are almost 20 nstance on

Oracle 11g installation manual on RedHat Linux 5.8 _ x64 Platform

Oracle 11g installation manual on RedHat Linux 5.8 _ x64 Platform Oracle 11g installation manual on RedHat Linux 5.8 _ x64 Platform Build Environment: VM10 + RedHat 5.8 _ x64 + Oracle 11g (grid + db) Steps: 1. Install VMware software on your

Analysis on solutions for creating and last updating timestamp fields in MySQL

Analysis on solutions for creating and last updating timestamp fields in MySQL Before writing this article, clarify my MySQL version. Mysql> select version ();+ ------------ +| VERSION () |+ ------------ +| 5.5.29-log |+ ------------ +1 row in set (0

Oracle 11g column-to-row listparts

Oracle 11g column-to-row listparts It is a little difficult to switch between the first 11g of Oracle, and it is very simple after 11g. Currently, a test table records the approval information of a document. The id is the primary key of the Approval

Help! How to batch Delete the same segment of characters in a field in a database table !, Batch Delete

Help! How to batch Delete the same segment of characters in a field in a database table !, Batch Delete How do I batch Delete AN01-1 strings in the Site_A field in a table? How does mysql batch remove the same part of strings under a field in a

Database downtime migration oracle10g instance and oracle10g migration

Database downtime migration oracle10g instance and oracle10g migration1. Operation 1.1 of the original database view original configuration 1.1.1 view User Permissions View user system permissions: SQL> select * from user_sys_privs; View User

In linux, databases are regularly backed up after time.

In linux, databases are regularly backed up after time. bakfordatabase.shmysqldump -uuser -ppassword database>folder/`date "+%Y-%m-%d~%H-%M-%S"`.sql Back up a mysql database in a specified time Mongodump-d database-o folder' back up mongodb

Delete the same data (only one record is left) across the oracle network and one record from oracle

Delete the same data (only one record is left) across the oracle network and one record from oracle Delete from reg_user t1 WHERE user_name = '2013' and rowid> (SELECT min (rowid) FROM location t2 WHERE t1.user _ name = t2.user _ name ); How to

Detailed process of user interaction with Oracle DB, process of user oracledb

Detailed process of user interaction with Oracle DB, process of user oracledb Interaction with Oracle DBThe following example describes the Oracle database operations at the most basic level. This example shows an Oracle DB configuration in which

Simple MySQL database operations, mysql database operations

Simple MySQL database operations, mysql database operations For children who want to engage in or love mysql-related work, it is necessary to implement some simple operations on mysql under the command line. This article describes how to log on to

How does mysql count the number of entries in a table?

How does mysql count the number of entries in a table? The following is a common SQL statement used to count the entries in a table: Select count (*) from tableName; # orselect count (1) From tableName; # or counts a column, such as IDselect count

Let's look at the database -- (4) transactions and database transactions.

Let's look at the database -- (4) transactions and database transactions. What is a transaction? Simply put, it is what you do or what you do. A term refers to a program execution unit that accesses and may update various data items in the database.

Total Pages: 1013 1 .... 420 421 422 423 424 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.