NAV: SLTechnology News&Howtos > Database >

• 

  Oracle 11G RAC client installation and PLSQL connection configuration

  To facilitate the project team developers to use the oracle11g RAC database, install a client and configure PLSQL to access the database server. Download the following three packages from oracle: instantclient-basic-win32-11.2.

  2022-06-01 10:47:53 Views: 281
• 

  Delete or add a non-empty index after the table is created

  Alter table Salter column SN CHAR (8) not NULL-- set the SN to non-empty (but there is no name of the named constraint here, how can I delete it? ) alter table Salter colu

  2022-06-01 10:47:52 Views: 240
• 

  New feature of Oracle 11g password case sensitivity

  In the past, in the 10g version, the default password was not case-sensitive, but it was case-sensitive unless it was explicitly enclosed in "double quotes". Today, after changing the business database user password in 11.2.0.4, the login prompt user / password error. After checking the document, it is found that there is a parameter control, default.

  2022-06-01 10:47:52 Views: 290
• 

  Resolve the pit encountered when installing Oracle 11g

  1. Install Oracle 11g error message under Win10 [INS-30131] failed to perform the initial setup required for setup verification: use the following command with permission to create a c disk share in CMD (running as an administrator): net share

  2022-06-01 10:47:52 Views: 287
• 

  Software package management (rpm and yum)

  Software package in system management, the management of software package is the most important and the foundation of system management; only when we learn the management of software package can we talk about other applications. In this paper, in the format of bibliographic documents, list the relative documents of installation, update and query of software packages faced by novice brothers, as well as several

  2022-06-01 10:47:44 Views: 219
• 

  Common syntax of MySQL

  Database-level operations # check which databases are available show databases; # create database create database [database name]; # display the character set show create database [database name] of the database

  2022-06-01 10:47:43 Views: 280
• 

  Common prerequisite commands for MYSQL

  Mysql common commands (mandatory) 1) Export test_db database command: mysqldump-u user name-p database name > exported file name mysqldump-u root-p test_db > test_d

  2022-06-01 10:47:43 Views: 204
• 

  Solve all kinds of errors during 12c installation

  [for details, please click on the http://www.dbstyle.net/?p=993 address] shortly after the launch of Oracle Database 12c, I saw that many people have completed the installation test. But basically they use "Create an"

  2022-06-01 10:47:36 Views: 255
• 

  Mongodb Rights Management 02

  Mongodb Rights Management 02 next, how to log in the password in the configuration file of mongodb? We used this command [root@prd3-mysql-0-36] # mongod-f / ivargo/a directly before.

  2022-06-01 10:47:36 Views: 294
• 

  Considerations for HBase Operation

  1.HBase returns empty if the column is qualified, if the column does not exist. Look at the following code: Get get = new Get (Bytes.toBytes); get.addColu

  2022-06-01 10:47:36 Views: 254
• 

  SQLite lesson 2 download and compile

  File description downloads two source packages: sqlite-dll-win32-x86-3081101.zip, which provides the file sqlite3.def that exports the function of sqlite3. Sqlite3.def is mainly used to generate LIB files. Make sure to use sqlite for links.

  2022-06-01 10:47:36 Views: 218
• 

  The solution of mysqldump backup report Binlogging on server not active

  Redhat 6.5 x64 Mysql 5.7 perform backup: [root@master 3306] # mysqldump-u root-p-- master-data=2-- single-trans

  2022-06-01 10:47:35 Views: 271
• 

  Methods of moving and changing domain names for WordPress blog sites

  Plan 1, not a few friends who set up a personal blog use WordPress, so it is inevitable to change the space and domain name. Since the author personally experienced the situation of changing the space and domain name, changing the blog from AAA.com to BBB.com, this article will share a bit more.

  2022-06-01 10:47:35 Views: 294
• 

  Principle and Application of Database (Learning Notes)

  Static structural design of the database: the structural characteristics of the database are static and generally will not be changed easily. Database behavior structure design: determine the behavior and actions of database users, design the system hierarchy, functional structure and data flow chart of the database application system. A popular understanding of the user's behavior and actions

  2022-06-01 10:47:35 Views: 226
• 

  The simplest data extraction in history

  The simplest data extraction in history as a full-time DBA, in the previous work, I often received such a demand, I need to cooperate with the developer to regularly take out the data they need from several target tables and store them in the temporary table, and then the developers take the data from the temporary table and show it to the front-end page. Receive such a need

  2022-06-01 10:47:08 Views: 278
• 

  Mongodb-mongos problem record

  Mongodb starts mongos Times with the following error Error initializing sharding system: DistributedClockSkewed: clock skew of the

  2022-06-01 10:47:07 Views: 226
• 

  MySQL5.5 multi-instance compilation and installation-- mysqld_multi

  1. Introduction to MySQL multi-instance MySQL multi-instance, to put it simply, it means that multiple different service ports (such as 3306, 3307) are opened on a server at the same time, and multiple MySQL service processes are run at the same time. These service processes come from different socket listeners.

  2022-06-01 10:47:04 Views: 262
• 

  How to simply read library cache dump

  Originated from the systemdump analysis of the example, now take out the part of library cache dump and make a simple guess. SYS@moe SQL > col KGLNAOBJ for a40SYS@moe SQL >

  2022-06-01 10:47:02 Views: 289
• 

  Install MariaDB using yum

  The YUM source for adding MariaDB is based on the YUM source of YUM's Linux distribution. Using the online source generator, you can easily generate the correct MariaDB.repo for your distribution. Different system versions of yum source generator: https://downlo

  2022-06-01 10:47:01 Views: 227
• 

  Introduction to MySQL Database-- A brief Analysis of View and transaction

  = view = a virtual table in the database, equivalent to a soft link: the data in one table provides access to users with different permissions. Suppose a table: company employee performance salary appraisal form, worker number, age, post performance salary 1 Tom

  2022-06-01 10:47:01 Views: 232