NAV: SLTechnology News&Howtos > Database >

• 

  New feature of Oracle 12.1-use RMAN to implement recover table from backup

  Before the Oracle12c version, the levels that could be recovered with RMAN were database level and tablespace level. If only one table needed to be restored, and at the database level or tablespace level, the impact would be too large. Therefore, a new feature is provided in version 12.2 to use RMA

  2022-06-01 15:15:38 Views: 296
• 

  Oracle 10g remote connection asm

  Asm remote connection may encounter the following error: ORA-12505 TNS:listener could not resolve SID given in connect descriptorORA-12541:

  2022-06-01 15:15:38 Views: 285
• 

  Detailed explanation of host conditions for automatic discovery

  Type of calculationThe following options of calculating conditions are available:AND-all condition

  2022-06-01 15:15:35 Views: 273
• 

  Keepalived to achieve High availability of mysql

  Description: three nodes are required, master node (202.207.178.6), slave node (202.207.178.7), test node (202.207.178.8), virtual address: 202.207.178.4. Configure to implement mysql database master

  2022-06-01 15:15:26 Views: 220
• 

  Linux oracle system installs the required installation packages and related dependency packages for oracle 11g, without software

  Cat > / tmp/rpm.txt < > / etc/sysctl.conf < > / etc/security/limits.conf < > / home/oracle/.bash_profile < 'e

  2022-06-01 15:15:26 Views: 253
• 

  Centos 6.9 compile and install LAMP + xcache

  Centos 6.9 compile and install LAMP apache 2.4 + Mysql 5.7 + php5.6.34 + Fast-cgi + xcache Experimental Environment: VMware Workstation P

  2022-06-01 15:15:26 Views: 237
• 

  Bootstrap$, you are so special.

  First, the Oracle database has a very special base table, you can delete it delete from bootstrap$; features: 1, the base table (data dictionary table) 2, delete the data, almost impossible to find. 3. An error is reported after the database is restarted and cannot be started. four

  2022-06-01 15:15:25 Views: 292
• 

  Collect oracle error codes and solutions by yourself

  Comment out PROGRAM = extprocORA- in ORA-28547:connection to server failed,probable Oracle Net adminlistener.ora

  2022-06-01 15:15:25 Views: 311
• 

  Query condition retrograde date: record 365 days before the current date

  Query criteria: record WHERE DATETIME for 365 days before current date < = DATEADD (DAY,-365,GETDATE ())

  2022-06-01 15:15:25 Views: 206
• 

  How does pt-osc modify foreign keys internally?

  Before we explain the internal processing flow of pt-osc, let's take a look at the information of the child table after the rename exchange table through the following example. -- create a parent table CREATE TABLE parent (id int (11) NOT NULL aut)

  2022-06-01 15:15:25 Views: 298
• 

  Installation, deployment and introduction of MySQL-5.6.38

  Chapter 1 introduction and deployment of MySQL 1.1.1 what is data refers to symbols that record and identify objective events, physical symbols or combinations of physical symbols that record the nature, state and interrelationship of objective things. It is recognizable and smoked.

  2022-06-01 15:15:21 Views: 263
• 

  Determine whether the date selected by the user is Monday

  How to determine whether the date selected by the user is Monday in the platform? The implementation code is shown in the following figure: original address: http://bbs.delit.cn/thread-888-1-1.html reprint Please indicate the source: writer: measurement Technology http://w

  2022-06-01 15:15:21 Views: 239
• 

  MySQL (Relational Database Management system)

  MySQL is a relational database management system developed by the Swedish company MySQL AB and currently belongs to the products of Oracle. MySQL is one of the most popular relational database management systems, and MySQL is the best RD for WEB applications.

  2022-06-01 15:15:02 Views: 260
• 

  Oracle recursive query

  -create data 1.1, create tables and insert data CREATE TABLE DISTRICT (ID NUMBER (10) NOT NULL, PARENT

  2022-06-01 15:15:02 Views: 215
• 

  ASM disk 2T limit

  When building the database, you need to pay attention to the use of ASM disk no more than 2T per disk, individuals generally set to 200g or 500g single disk. Oracle ASM Storage LimitsOracle ASM provides n

  2022-06-01 15:14:57 Views: 215
• 

  Report display part: set the variable value of the subreport business table

  Function: set the value of the business table variable of the subreport of the report. Example application: step 1: add a subreport to the report called by the form report display part, as shown in the following figure: step 2: add the following code through the platform Intelligent Wizard in the form load event: running effect: original address: http

  2022-06-01 15:14:57 Views: 210
• 

  Mongodb win installation

  Mongodb installation 1, window installation 1, download mongodb, download 32-bit or 64-bit versions from http://www.mongodb.org, depending on your system. 2. Extract it to the location you want to place, and the default directory for storing data files is

  2022-06-01 15:14:54 Views: 208
• 

  Rman migration point-in-time recovery

  I was supposed to take a day off today, but when I was having dinner at 8 p.m., the supervisor called me to restore a database. At 12:00, the developers improperly operated. One of the schema was used to receive data from other factories, which made a mess. ~ Let me restore the data at around 12:00 today.

  2022-06-01 15:14:42 Views: 258
• 

  Autonomous affairs of Oracle

  Autonomous transactions (autonomous transaction) allow you to create a "transaction in a transaction" that can be committed or rolled back independently of its parent transaction. With autonomous transactions, you can suspend the currently executed transaction, start a new transaction, complete some work, and then commit or roll back

  2022-06-01 15:14:42 Views: 238
• 

  SQLAchemy of 2Python full Stack Road Series

  The SQLAlchemySQLAlchemy of the Python full stack series is the Python SQL toolkit and object-relational mapper, which gives application developers full functionality and SQL flexibility. It provides a complete set of well-known enterprise persistence models

  2022-06-01 15:14:42 Views: 286