NAV: SLTechnology News&Howtos > Database >

• 

  Oracle forgot the SYS password, recovered the SYS password and recreated the new user login database

  1. When you run CMD, pay attention to the path of ORACLE orapwd file=C:\ oracle\ product\ 11.2.0\ dbhome_1\ database\ pwdctcsys.ora. You will be prompted to enter the above command.

  2022-06-01 12:38:24 Views: 297
• 

  SQLite Analysis of SQL As Understood By S

  Original: the http://www.sqlite.org/lang_explain.html keyword "EXPLAIN" or the statement (by the phrase) "EXPLAIN QUERY PLAN" can be placed in SQL

  2022-06-01 12:38:24 Views: 221
• 

  MongoDB erroneous deletion table recovery

  First, the scenario describes that an engineer in the company executes db.giveget_card.drop () and deletes the online table by mistake. Fortunately, backups are made every day, which reflects the importance of backup at this time. Second, simulate the failure process backup data size: rs_test0

  2022-06-01 12:38:23 Views: 248
• 

  Optimize paging query for comments

  Possible_keys, key, and key_len are all null. It can be seen that there is no calculated differentiation of available indexes on the table. The closer to 1, the better. It should be placed on the left side of the federated index. The explain after the federated index is built: the more pages are turned, the slower the speed is, and enter.

  2022-06-01 12:38:15 Views: 268
• 

  The latest version of MySQL MySQL5.7.11 batch automated one-button installation

  Used to like the source code to install MySQL, always feel that the source code is a high-end thing, but the source code also takes time, especially when make, if the disk and cpu are poor, the time is very long, especially slow to install mysql on the virtual machine. Now that the business has developed, it is starting to be on the cloud.

  2022-06-01 12:38:14 Views: 211
• 

  Clean up the log file for sql server2008

  Today, due to the large growth of log files in sql server, the log files are deleted after the separate databases are deleted. When they think that they will attach the database, they will automatically produce log files. As a result, they have thought of a lot of ways to reconstruct log files and build the database with the same name. After the database is built, it will be used after construction.

  2022-06-01 12:38:14 Views: 283
• 

  Error in installing RAC in Oracle 11gR2-clock out of sync

  Oracle 11gR2 installation RAC error-clock out of sync system environment: operating system: RedHat EL5Cluster: Oracle GI (Grid Infrastructure) Oracle: Oracl

  2022-06-01 12:38:11 Views: 245
• 

  Mybatis- ordinary sq adds, deletes, modifies and examines study notes

  Import java.util.*;import cn.mybatis.entity.Student;import cn.mybatis.util.MybatisUtil;import org.ap

  2022-06-01 12:38:11 Views: 266
• 

  How to solve the problem that when modifying the SQLServer table structure, the Timeout time is up

  Background: recently modified a SQLServer table structure with massive data, reported an error [unable to modify the table. Timeout time is up. The timeout expired or the server did not respond before the operation was completed. [solution]: tools-> options > designer-> Table designer and

  2022-06-01 12:38:08 Views: 297
• 

  Building and configuring virtual host of LAMP environment under Centos7.2 / Linux

  LAMP environment: LINUX + Apahce + MYSQL + PHP web server environment. (1). Preparation work 1. Download and install CentOS7.2, configure the network environment, ensure that centos can access the Internet, and access to yum sources (A

  2022-06-01 12:38:04 Views: 281
• 

  Linux command: the 12th of MySQL series-- MySQL backup and restore mysqldump (important chapter)

  Types of data backup: hot backup, warm backup and cold backup hot backup: read and write are not affected; warm backup: only read operations can be performed; cold backup: offline backup, read and write operations are aborted; backup method: physical backup and logical backup: physical backup: copy data files, fast, save data

  2022-06-01 12:38:04 Views: 224
• 

  Basic Oracle commands for Oracle rookie learning

  Launch: http://www.arppinging.com/wordpress/?p=93Oracle rookie learning Oracle basic commands 1.connect and show user to connect users and view current users SQL >

  2022-06-01 12:38:04 Views: 273
• 

  Stored procedures and functions of Mysql

  Mysql stored procedures and function stored procedures are a collection of one or more SQL statements that can be treated as batch files, but they are used not only for batch processing. Stored procedures are divided into: 1, stored procedures 2, functions use call statements to call stored procedures, can only use output variables to return values. I.

  2022-06-01 12:37:46 Views: 286
• 

  Log Mining Technology of Oracle

  Log mining: logminer function: through the analysis of the log, you can obtain the user's dml operation statements, which can be used to repair the loss or error of user data; through log mining, you can obtain the reverse operation (undo_sql) or forward operation (redo_s) of the user action.

  2022-06-01 12:37:46 Views: 244
• 

  Oracle--OEM and common fault handling

  About OEM OEM is a tool set that uses an intuitive and convenient graphical interface to control and manage ORACLE databases. It contains a large number of tools that are useful for DBA. In oracle, database management and operations can be done using OEM, such as creating users and roles, and assigning permissions.

  2022-06-01 12:37:46 Views: 284
• 

  Mysql replication

  Mysql replicaton environment: master: 192.168.48.150 from: 192.168.48.152 simply put, master writes database changes to binary logs, slave synchronizes these binary logs, and according to these binary logs

  2022-06-01 12:37:45 Views: 263
• 

  Query all user information in oracle

  1. View all users: select * from dba_users;select * from all_users;select * from user_users;2. View user or role system permissions (direct assignment

  2022-06-01 12:37:45 Views: 230
• 

  The problem of 1781 of BINLOG

  Recover data once via BINLOG Times: ERROR 1781 (HY000): @ @ SESSION.GTID_NEXT cannot be set to UUID:NUMBER when @ @ GLOBAL.

  2022-06-01 12:37:45 Views: 272
• 

  Oracle fault analysis ORA-01089

  Today, after issuing the shutdown immediate command to the test library, we observed the log and found the following: Tue May 12 09:52:45 2015SHUTDOWN: Active processes prevent s

  2022-06-01 12:37:45 Views: 228
• 

  Pglogical 2.2.0 configuration instructions

  Master: postgresql 9.5 (192.168.31.205) standby: postgresql 10.3 (192.168.31.202) 1.postgresql configuration 1) .vi po

  2022-06-01 12:37:45 Views: 252