NAV: SLTechnology News&Howtos > Database >

• 

  Solution to the problem that the permissions of oracle export data do not match those of import

  In a project, it is found that the data exported by DBA account in the data exported from oracle database (limited experience) cannot be imported in accounts without DBA permissions, which will prompt IMP-00013 that only DBA can import problems exported by other DBA. After groping for a long time

  2022-06-01 18:27:38 Views: 268
• 

  Application of redis-Registration, Login

  Field design: # set login account: set user:1:account zhangsanset user:2:account lisi# set user name: set user:1:name Zhang San set user:2:n

  2022-06-01 18:27:37 Views: 205
• 

  Oracle RAC error-- A case of oifcfg error

  Oracle RAC error-- oifcfg error case system environment: operating system: RedHat EL5Cluster: Oracle GI (Grid Infrastructure) Oracle: Oracle 1

  2022-06-01 18:27:36 Views: 250
• 

  ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], []

  ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [] was suddenly wrong when building the database today.

  2022-06-01 18:27:36 Views: 251
• 

  Install community version MongoDB under Mac

  MongoDB download address: https://www.mongodb.com/download-center?_ga=2.98072543.1777419256.1515472368-391344272.1

  2022-06-01 18:27:35 Views: 258
• 

  Mongodb connection error caused by a space

  Recently, in the study of mogodb, the following error occurred in the execution of. / mongo 192.168.1.51Error 30000, Error: couldn't connect to server 192.168.1.51purl 30000

  2022-06-01 18:27:35 Views: 250
• 

  Several common commands for formatting output from the oracle command line

  Set linesize (line) sets the maximum line width of the sqlplus output-- the maximum number of lines of the set pagesize setting page set newpage sets the number of blank lines between pages of the spool sqlplus screen

  2022-06-01 18:27:34 Views: 296
• 

  MSSQL and MYSQL replicate table structure and data

  MSSQL: only copy table structure: select * into new.table from old.table where vend_id=10;-the condition cannot be established. The primary key and other information should be rebuilt. Copy the old table data to the existing

  2022-06-01 18:27:34 Views: 216
• 

  MySQLdb module of python

  Security code: MySQLdb is a module used to control mysql database through python. Before we talk about this module, let's think about the steps of operating mysql database in command line mode, which are generally divided into three steps: 1, connect to the database; 2, fuck

  2022-06-01 18:27:34 Views: 300
• 

  Oracle database installation

  A server prepares the system for centos6.5 version 64-bit. The database configures 1.groupadd oinstallgroupadd dbauseradd-g for oracle11G Enterprise 11.2.0.1.0 two server environment

  2022-06-01 18:27:33 Views: 228
• 

  Solution of garbled code in oracle display under Linux

  1. Log in to oracle users, log in to dba, and display garbled codes. [root@redhat4 ~] # su-oracle [oracle@redhat4 ~] $sqlplus / as sysdbaSQL*Pl

  2022-06-01 18:27:33 Views: 275
• 

  Oracle DG-- build Physical Standby (a master library corresponds to a multi-standby library)

  Oracle DG-- build Physical Standby (a main library corresponds to a multi-standby library) system environment: operating system: RedHat EL6Oracle: Oracle 10.2.0.1.0 as shown in the figure, the main library is bjdb (d

  2022-06-01 18:27:33 Views: 237
• 

  The way of MySQL Management-Notes-MySQL5.7- online adjust innodb_buffer_pool_size

  Online adjustment innodb_buffer_pool_size does not need to restart the mysql process MySQL5.7, before the innodb_buffer_pool_size adjustment process needs to restart the mysql process to take effect. It is recommended that the business be carried out at a low peak time.

  2022-06-01 18:27:32 Views: 230
• 

  SQL introduction Classic (5th Edition) Learning Notes (3)

  1. Can the following CREATE TABLE command be executed properly? What changes need to be made? Are there any restrictions on execution in different databases (MySQL, Oracle, SQL Server)? No as:middle_name null.

  2022-06-01 18:27:32 Views: 283
• 

  Basic backup of database

  Sort out the data backup method one encountered in the work: using Aliyun backup database Ariyun has automatic backup function, there is a snapshot function in the control center, which is used for automatic backup and recovery. Ali cloud server will automatically back up system disk and data disk every day. If the server is * *, you can borrow a snapshot.

  2022-06-01 18:27:30 Views: 244
• 

  ORACLE ADF11g: getting started with Taskflow

  In ORACLE ADF, taskflow is mainly responsible for the flow and reuse of pages, and then use examples to explain the simplest taskflow creation and use. Illustration: end

  2022-06-01 18:27:20 Views: 266
• 

  ORA-01810: format code appears twice as a solution

  When writing a sql to insert into the database, to_date ('20140509131034') is because the representation of the year, month and day in java is different from that in oracle. Oracle is represented by MI

  2022-06-01 18:27:19 Views: 273
• 

  NoSQL----Redis 2.4--List

  1. Overview: 1. List: duplicate elements are allowed, and list can be used as a stack (first in, first out) or queue (first in, first out). Header element and trailing element: the header element refers to the first element at the left / front end of the list; the trailing element refers to the first element at the right end / back end of the list. For example, column

  2022-06-01 18:27:19 Views: 298
• 

  Characteristics, installation and use of redis

  What is redis: Redis is an open source, BSD licensed, advanced key-value store. It is often referred to as

  2022-06-01 18:27:19 Views: 299
• 

  Single table query of MYSQL select statement

  This article uses the example code to show the use of the single table query of the select statement, the code is very detailed, which can be used as a reference for interested friends. I hope it will be helpful to you. The basic syntax of the SELECT statement is as follows: select selection_list

  2022-06-01 18:27:09 Views: 255