NAV: SLTechnology News&Howtos > Database >

• 

  What about the explosion of archived files after Oracle data migration?

  Data migration is the daily work of DBA. I believe many people already know the corresponding methods and commands like the back of their hand. A successful data migration process not only refers to restoring data from database A backup to database B, but also ensures the integrity of data and the availability of services before and after migration. Recently, I have been doing it for my clients.

  2022-06-01 22:31:46 Views: 246
• 

  Sybase stored procedure modification

  The stored procedure of Sybase database cannot be modified. You need to DROP it first and then CREATE it. You can first enter the original stored procedure to modify the content, copy all the contents that need to be modified, delete the stored procedure, and then create and paste the content into the content area.

  2022-06-01 22:31:46 Views: 204
• 

  19C ADG deployment

  Because customers need to deploy 19c DG environment, which used to be 11g and 12c deployment, test 19c deployment 1. DG basic environment ORACLE host library IP:111.111.111.203 SID:DT db_name='DT' hostname:

  2022-06-01 22:31:46 Views: 230
• 

  MySQL (mariadb) Multi-instance Application and Multi-instance Master-Slave replication

  MySQL multi-instance mysql multi-instance means that mysql service opens multiple ports (such as 3306, 3307 and 3308) and runs multiple service processes on one server. These mysql service processes come through different socket

  2022-06-01 22:31:42 Views: 214
• 

  MongoDB tutorial

  First, install and then configure the environment variable, find the bin directory, copy the path, create a new one under path, and then go into the copy directory to make sure you can configure the "environment variable". The purpose is to use it directly on the command line without having to enter a long path to enter the installation directory and then use it. 1. Hit

  2022-06-01 22:31:34 Views: 206
• 

  ORA-12514: TNS: the listener currently does not recognize the connection description

  I learned oracle10g these days. After using pl/sql.developer for a while, I reported an error such as the title, so I searched the Internet for the answer and made the following record. There are generally two situations in which this problem occurs. The first is that you do not configure monitoring after you have installed it (here

  2022-06-01 22:31:31 Views: 260
• 

  Constraint Operation of Dameng Database

  The constraints of Dameng database commonly used are primary key constraints, foreign key constraints, unique constraints, and some less commonly used check constraints, non-empty constraints, and so on. Next, we use test1 users to create operations. 1. Create primary key constraints. Let's start with test1 user creation.

  2022-06-01 22:31:11 Views: 283
• 

  MySQL 5.7 delayed replication

  MySQL 5.7 delayed replication is achieved by setting the replication parameter MASTER_DELAY (in seconds, that is, the SQL is executed after the delay from the library) for example: mysql > show slave status\ G*

  2022-06-01 22:31:10 Views: 277
• 

  How to use the OPC data logger OPC DataLogger through OP

  OPC DataLogger, an OPC data recorder that can meet various requirements of users, is compatible with OPC DA 2.x Compliant Servers and OPC UA, and can be used in a variety of operating systems and database processing. With Siemens S

  2022-06-01 22:30:51 Views: 205
• 

  Set up LVS load balancing cluster (theory + actual combat, easier to understand)

  LVS load balancing Cluster understands the principle of load balancing Cluster Mastering the deployment of LVS-NAT Enterprise Cluster Application Overview the meaning of cluster: 1.Cluster, cluster, cluster 2. It is composed of multiple hosts, but it is only shown as a whole in Internet applications, with the hardware performance of the site,

  2022-06-01 22:30:24 Views: 269
• 

  Password Policy and rules of Oracle Database

  Today, let's talk about the password rules and strategies of Oracle database:-change the password, alter user FINCHINA account unlock identified by finRTg6;- query whether user is locked, and

  2022-06-01 22:30:23 Views: 213
• 

  Oracle-ocp-051

  View Oracle users can use those tables data dictionary tables (manage all user tables) desc user_tables; (view operable tables) select tables_name from user_tables; (SCOTT)

  2022-06-01 22:30:23 Views: 282
• 

  Mysql function set graph

  Date function flow control function

  2022-06-01 22:30:03 Views: 249
• 

  MySQL fundamentals (01): classic practical query cases, summary and collation

  Source code of this article: GitHub click here | | GitEE click here 1. Schematic diagram of connection query 1. Table-building statement department and employee relations table: CREATE TABLE `tb_ dept` (`id` int (11) NOT NUL)

  2022-06-01 22:29:57 Views: 268
• 

  Installation of sybase12.5_x under linux always reports

  Installing sybase12.5_x under linux always reports that Segmentation fault builds the environment for new projects. A sybase database has been messing around all day, and every time it is Segmentation fault and Serv.

  2022-06-01 22:29:56 Views: 303
• 

  The whole process of MongoDB database file damage and data recovery

  one。 Fault description the customer equipment environment is a server with an operating system of Windows Server 2008, and the MongoDB database is deployed. Due to business needs, the customer copied the database files without shutting down the MongoDB database service. Set

  2022-06-01 22:29:45 Views: 281
• 

  MySQL partition subtable

  Blog outline: 1. Why do you want to separate tables? 2, MySQL sub-table 3, using merge storage engine to achieve sub-table 4, MySQL partition 1, why sub-table? The data in the database is getting larger and larger, followed by too much data in a single table. So that the query speed becomes slower, and because of the lock of the table

  2022-06-01 22:29:15 Views: 223
• 

  Networker 8.2 Module for Sybas

  1. Check the sybase installation directory 2. Upload the file Networker Module for Sybase AIX to the PlusWell directory in AIX. Nmda16_aixpower32.tar.gz nw811_a

  2022-06-01 22:29:01 Views: 282
• 

  Cross-network data exchange solution

  What is cross-network? cross-network refers to a network that cannot be directly connected between the Internet and the local area network. These Lans can be separate Lans with high confidentiality, public security networks, military networks and so on. Second, why should cross-network transmission take the public security network as an example, the public security network has higher requirements for data security, so it does not interact with each other.

  2022-06-01 22:29:00 Views: 271
• 

  Oracle client sql Developer installation uses

  Preface description: when I installed the Oracle client tool, I downloaded several versions of the sql/developer tool, all of which had problems when connecting to the external database. I tried to solve one problem and another; took a lot of detours; specially recorded my experience and gave way.

  2022-06-01 22:28:45 Views: 292