Database Administrator

1. To establish a Database connection, you must have the PCREATE Database link system permission. to connect to a remote account, you must also have the CREATE session common permission;2. Ensure that connected users have the permission to access

Let's take a look at the explanation of this parameter in the official documentation. CURSOR_SHARINGProperty DescriptionParameter type StringSyntax CURSOR_SHARING = {SIMILAR | EXACT | FORCE}Default value EXACTModifiable alter session, ALTER

1. view the current database log ModeSQL> select name, log_mode from v $ database; orSQL> archive log list; (This method requires as sysdba) To archive a non-archive database, follow these steps:1. SQL> alter system set log_archive_dest_1 =

In Oracle, you must query the non-repeated columns t. address and t. mermer_name in the customer table: The general idea is: Select distinct t. address, t. customer_name from customer t However, this method is incorrect in oracle. Therefore,

From the following experiment, we can see that the full table scan is performed to retrieve data according to the extent/block sequence. The first experiment had a 'db file scattered read' wait event, and the second experiment had loaded the data

I: Row_number () over (partition by col1 order by col2) indicates grouping by col1 and sorting by col2 within the group, the value calculated by this function indicates the sequential number after each group is sorted (the continuous and unique in

Oracle 9i is really a headache, ORA-00600 has become a signboard error, although 10g also has similar errors, but it is already very different from 9i.At the beginning of DBA, on the ORA-00600 began to understand, when learning that this is "oracle

The solution is to use the hstore type. to use it, you must first create the corresponding extension. The following is a simple example: Iihero = # create extension hstore;CREATE EXTENSIONIihero = #Iihero = # select 'a => 1, B => 2': hstore;Hstore-

Redis2.6 has been released (http://redis.io/download), download, in make when a bunch of compilation errors, after looking at the issue, with the linux system version and number of digits. Yesterday, the author antirez released 2.6.2. This version

1. Redis IntroductionRedis is a key-value storage system. Similar to Memcached, Memcached supports more storage value types, including string, list, set, and zset ). These data types support push/pop, add/remove, Intersection Set and difference set,

Before starting the installation, first describe the difference between the mysql-5.6.4 and the lower version in the installation, from the mysql-5.5, mysql source code installation began to use cmake, so when we configure the installation directory.

There are many ways to synchronize tables between Oracle databases, such as triggers, Materialized View (MV), Stream, and Goldengate. Materialized View is a database object that includes query results. It is a local copy of remote data or used to

How to solve a Java error when installing Oracle 11gR2 on AIX 6.1: Sys-/tools/database>./runInstallerStarting Oracle Universal Installer... Checking Temp space: must be greater than 190 MB. Actual 7005 MB PassedChecking swap space: must be greater

In view of the problem that DBCP is directly used for JDBC connections, I made a simple example. All resources are from the Internet. It does not need any Web Container, but is a simple console

Environment: Sys @ ORCL> select * from v $ version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProdPL/SQL Release 10.2.0.1.0-ProductionCORE 10.2.0.1.0 ProductionTNS

1. modify a data table It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log on to the computer of localhost. After logging on to MySQL, change the "Host" item in the "user" table

When sqlyog is used to connect to a database of a non-local Mysql server, it is strange that the database cannot be connected. The error 1130 is reported,ERROR 1130: Host 192.168.3.100 is not allowed to connect to this MySQL server It is assumed

Two Linux servers, one as master server A and the other as backup server B. The system is CentOS and MySQL is used for the database. After mysql settings on A are complete, B cannot connect. However, the C server can connect to. Very strange.

To meet this requirement, the query number ends with 11 and cannot contain "4" from the fourth to the eighth digit. It was initially assumed that Oracle and SQL server support the same [^ 4], if I have checked a lot on the internet, it also means

[Bkjia.com @ OceanBase ~] $ Cat my. SQLCreate table x (a1 int, a2 int, a3 int, b1 int, b2 int, primary key (a1, a2, a3 ));Insert into x (a1, a2, a3, b1, b2) values (, 0 ); [Bkjia.com @ OceanBase ~] $ Mysql-h1.32.36.29-P4797-uadmin-padmin [Bkjia.com