NAV: SLTechnology News&Howtos > Database >

• 

  Instructions for using oracle database link

  Function: treat multiple oracle databases logically as one database, that is, you can manipulate objects in another database in one database. Simple syntax: CREATE [PUBLIC] DATABASE LINK dblink CONNECT

  2022-06-01 10:31:24 Views: 208
• 

  An operation example of online mall migration

  The online mall migrates and modifies the database password and IP. Take one of the malls as an example, and the other malls operate the same cd / home/webserver/tar zxvf nkwshop.tar.gzrm-rf nkwshop.tar.gz.

  2022-06-01 10:31:24 Views: 209
• 

  What database backup methods does sql servre have?

  Today, I will talk to you about what database backup methods sql servre has, many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article. One: four kinds of preparation for sql server database

  2022-06-01 10:31:24 Views: 276
• 

  What is the difference between nocatalog and catalog in RMAN?

  Nocatalog mode: using control file as catalog, each backup will write a lot of backup information into the control file, and there will be more and more backup information in the control file, that is, the backup information of RMAN will be written in the local control file. Cata

  2022-06-01 10:31:23 Views: 287
• 

  Linux mysql backup Import

  Connect to remote linux database mysql-hIP-u username-p password [root@localhost liuzhen] # mysql-h292.168.1.180-uroot-p123456 column

  2022-06-01 10:31:23 Views: 223
• 

  Php supports oracle oci compilation parameters

  . / configure-prefix=/usr/local/php-with-oci8=shared,instantclient,/usr/lib/oracle/11.2/client64/

  2022-06-01 10:31:23 Views: 300
• 

  Discuz3.0 website installation

  1. LAMP environment installation 1.1. Configure ok;yum install gcc http://wangfx.blog.51cto.com/1697877/18718971.2. in yum environment Agent to prepare OK;ht on the Internet

  2022-06-01 10:31:20 Views: 254
• 

  Statistics of active users by bitmap method

  Setbit practical application scenario: 100 million users, each user login / do any operation, recorded as active today, otherwise recorded as inactive weekly rating: award-winning active users: 7 consecutive days of monthly reviews, etc. Idea: Userid dt activ

  2022-06-01 10:31:17 Views: 219
• 

  What are the data types of fields in the mysql data table

  This article will explain in detail the data types of which fields are in the mysql data table, and the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article. The data types of fields in the data table are: TINYIN

  2022-06-01 10:31:16 Views: 285
• 

  Oracle DataBase single instance using ASM case (2)-- Environment preparation of Oracle 11g

  Oracle DataBase single instance uses ASM case (2)-- Oracle 11g Environment preparation system Environment: operating system: RedHat EL5 (64) Oracle Software: Oracle 11gR2, Oracle G

  2022-06-01 10:31:16 Views: 287
• 

  Besides, ORA-00845: MEMORY_TARGET not supported on this system

  There are many articles on the Internet about this error, some of them citing instructions in the Oracle documentation. Setting Memory Target at Instance Startup on LinuxStarting with Ora

  2022-06-01 10:31:16 Views: 217
• 

  PostgreSQL 10 data types and indexes

  The six commonly used index types in PostgreSQL 10 are btree,hash,gin,gist,spgist and hash. Btree and hash are the longest, and almost all data types are supported. For gin,gist,spgis

  2022-06-01 10:31:13 Views: 243
• 

  Oracle WebLogic Server 10.3.2 vulnerability repair method

  The modification method is as follows: 1. Decompress modules/com.bea.core.apache.commons.collections_3.2.0.jar2 under weblogic. Delete the InvokerTransfo in it

  2022-06-01 10:31:12 Views: 206
• 

  ORA-12154 TNScould not resolve the connect identifier specified

  Today, I logged in to PL/SQL to connect to ORACLE 11G R2 with the following error: ORA-12154 TNScould not resolve the connect identifier specified. My settlement office.

  2022-06-01 10:31:12 Views: 235
• 

  What is the MySQL monitoring tool mysql-monitor

  What is the MySQL monitoring tool mysql-monitor? I believe that many inexperienced people are at a loss about this, so this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem. 1. Overview of mysql-monitor

  2022-06-01 10:30:54 Views: 270
• 

  Performance Optimization of Oracle Learning (3) binding variables

  According to the performance optimization of Oracle learning (2) cursor, we know that the following two statements are not shared. Select * from emp where empno=7698;select * from emp where

  2022-06-01 10:30:41 Views: 281
• 

  Check_oracle_health Monitoring oracle

  First, the preparatory work 1. Create a user on the database and grant permissions (DBA cooperate with operation; user, password to be determined; just monitor native database TNS, SID) CREATE USER nagios IDENTIFIED BY XXXX; GRANT

  2022-06-01 10:30:41 Views: 265
• 

  Unlimited settings for oracle permanent password and login times

  Http://www.cnblogs.com/tippoint/archive/2013/03/08/2950126.html modifies oracle user password and never expires: 1. Check which user's proifle is, generally

  2022-06-01 10:30:41 Views: 207
• 

  MacOS system installs MySQL

  The key to the installation is that the configuration after installation needs to be paid attention to. There are also a lot of articles on the Internet to summarize the problems I encountered in the installation process. The first step is to download the macos version from the MySQL official website and then the installation prompts you to install step by step. One more in system preferences after the installation is complete

  2022-06-01 10:30:40 Views: 209
• 

  Oracle logical storage structure

  Logical storage structure is the division of data storage structure in logical concept. The logical storage structure of oracle is mainly composed of the concepts of table space, segment, interval and data block. Oracle data blocks are composed of multiple tablespaces, and tablespaces are composed of multiple segments, which are composed of multiple data areas.

  2022-06-01 10:30:40 Views: 206