NAV: SLTechnology News&Howtos > Database >

• 

  Oracle checks whether the two users have the same number of tables

  Check whether the two users have the same number of tables, with uppercase select count (a.table_name) and count (b.table_name) from (select table_name from all_a).

  2022-06-01 10:57:57 Views: 245
• 

  Oracle connection startup and shutdown mode (summary)

  First, connect to database 1, start SQL*PLUS, but do not log in to sqlplus / nolog2, connect to connect username/password as sysdba with Oracle in the role of SYSDBA (if the user

  2022-06-01 10:57:56 Views: 265
• 

  Install and add instances of mongodb

  Description: MongoDB is a cross-platform, document-oriented database. It can achieve high performance, high availability, and can be easily scaled. Is an open source database system based on distributed file storage, in the case of high load, adding more nodes can ensure the performance of the server. Mon

  2022-06-01 10:57:41 Views: 235
• 

  Temporary watch of Oracle

  The temporary table concept temporary table is used to save intermediate result sets during a transaction or session. The data saved in the temporary table is only visible to the current session, and none of the sessions can see the data of other sessions; even if the current session has already committed (commit) the data, no other session can see its data. For temporary tables

  2022-06-01 10:57:40 Views: 292
• 

  Install mongodb 2.6.5 under CentOS 6.5

  Mongo DB is a very popular non-relational database (NoSql) in the IT industry, and its flexible data storage method is favored by current IT employees. Mongo DB implements the object-oriented idea very well. In Mongo DB, every note

  2022-06-01 10:57:40 Views: 299
• 

  Redis-- data type

  Five data types string (string) commonly used operations 127.0.0.1 nil 6379 > get name (nil) 127.0.0.1 nil 6379 > set name test OK127.0.0.1:6379 > get n

  2022-06-01 10:57:40 Views: 235
• 

  Simple Management of PostgreSQL (1)

  1. Initialize database cluster, like other RDBMS, you need to initialize a database on disk before you start using PostgreSQL database, which is called database cluster here. A database cluster is a collection of databases managed by running database service instances. After initialization

  2022-06-01 10:57:40 Views: 291
• 

  Mongodb3.2 sharding deploy

  1. Deploy the software pc1, pc2, pc3 and install mongodb, respectively. The operations are as follows: [root@pc1 ~] # tail / etc/security/limits.confmongod soft nproc 4000

  2022-06-01 10:57:39 Views: 286
• 

  11g RAC cluster startup and shutdown, various resource checks, configuration information view summary.

  Summary: 1: startup and shutdown of cluster 1. Manual startup of rac cluster [root@node1 bin] #. / crsctl start cluster-all2. View the status of the rac cluster [root@node1 bin]

  2022-06-01 10:57:36 Views: 226
• 

  Design Data Intensive Applicat

  What is SHARDING: divide large data sets into multiple chunks and store them on different servers purpose: scalability: different shards can be placed on different servers, decentralized read requests complex queries can be executed in parallel on different shards and write requests can be distributed to each server question 1: how to

  2022-06-01 10:57:36 Views: 223
• 

  Usage and Application of MySQL INT,TINYINT,SMALLINT,BIGINT

  MySQL INT,TINYINT,SMALLINT,BIGINT usage and application, MySQL supports all standard SQL integer types INTEGER, INT, and SMALLINT. In addition, MySQL provides TINYINT, ME

  2022-06-01 10:57:36 Views: 205
• 

  Postgresql 9.6 Multi-column Index Test

  Set up the test table structure CREATE TABLE t_test (id integer,name text COLLATE pg_catalog. "default", address character varyi

  2022-06-01 10:57:35 Views: 259
• 

  SQL queries whether a table exists and returns the ID of the new data

  The following is a brief description of SQL querying whether a table exists and returning the ID value of the new data. 1. Query whether the table exists: table name: "t_Demo", type ='u'to check whether it is a user table select * from sysobjects wh

  2022-06-01 10:57:35 Views: 227
• 

  Data insertion exception report in spring-data-mongo

  1. The background adds a uniqueness constraint to a collection and expects an exception to be thrown when duplicate data is inserted, so that the default configuration can be processed later. When inserting data into the database, if there is a uniqueness constraint conflict, the newly inserted data cannot be inserted, but

  2022-06-01 10:57:35 Views: 203
• 

  Oracle 12cR1 RAC installation on VMware Workstation (middle)-graphical interface installation

  Oracle 12cR1 RAC installed on VMware Workstation (middle)-graphical interface installation 1.1 graphical interface installation 1.1.1 installation GRID installation log: / u01/app/oraInventory/lo

  2022-06-01 10:57:05 Views: 225
• 

  Initialize Oracle 11gR2 RAC DG before installation

  1. Preusers.sh script #! / bin/bash#Purpose:Create 6 groups named 'oinstall','dba','asmadmin','asmdba','asmop

  2022-06-01 10:57:05 Views: 209
• 

  Database dictionary view dict that must be remembered

  Daily work will often check some data dictionary view, but also often can not remember, can only remember a prefix, then dict you must remember, it can help you find the view you want. You have to remember dict~~SQL > desc dict; Name

  2022-06-01 10:57:03 Views: 273
• 

  Pass a list in the sql and return a list

  -incoming array-returns list-String [] sendPersonIdArr = sendPersonId.split (","); List list =

  2022-06-01 10:57:03 Views: 208
• 

  MySQL backup command mysqldump parameter description and example

  1. The syntax option states-h,-- host=name hostname-- P [port_num],-- the TCP/IP port number that port=port_num uses to connect to the MySQL server-- master-data.

  2022-06-01 10:57:03 Views: 260
• 

  Upgrade WSUS 3.0 SP2 ON windows server 2008 R2 ENT to windows server 2012 R2 S in place

  Goal: the standard version of the Windows server 2008 R2 system does not support data redeletion, and the wsus wants to enable dedup, although it is said on the Internet that there is only about 17% weight removal rate, but if the space is 240GB.

  2022-06-01 10:56:37 Views: 226