Database Administrator

This article describes the comparison between SQL Server and stored procedures from multiple perspectives. ① Why should stored procedures be used? Because it is faster than SQL statement execution. ② What is a stored procedure? Combine a bunch of

1. Simple QueryA simple Transact-SQL query only includes the select list, FROM clause, and WHERE clause. They indicate the queried columns, the queried tables or views, and the search conditions.For example, the following statement queries the nick

There are many ways to export data from SQL to mysql. This article introduces a graphic interface that uses SQL and mysql without programming.A Simple Method for importing and exporting data.The premise is that you have installed the sqlserver

When logging on to phpPgAdmin: If you always get a "Login failed" and confirm that you have used the correct username and password and can log on normally in pgadminIII! Solution: Modify php. in the ini configuration file, set extension = pgsql. so

This article introduces several major technologies and solutions for Oracle Database Remote replication and Remote Disaster Tolerance.Currently, the following technologies or solutions are available for remote replication and Disaster Tolerance of

1. Delete the SQL installation directory under Program files (back up important data first) C: \ Program Files \ Microsoft SQL Server \ 80 \ Tools. C: \ Program Files \ Microsoft SQL Server \ MSSQL. 2. Delete ExceptionComponents: HKEY_LOCAL_MACHINE \

Oracle10g was installed several times in the first burst. It is necessary to remember EM login garbled characters to prevent future forgetting.There are three places to change1. In the $ ORACLE_HOME/jdk/jre/lib pathBack up font. propertiesCp font.

MYSQL command:Mysql-h host address-u user name-p password to connect to MYSQL; If MYSQL is just installed, the Super User root has no password.(For example, mysql-h 110.110.110.110-Uroot-P123456)Note: u and root do not need to add spaces. The same

The two servers are both linux systems. It took me a lot of time to move the data in the database to the new server (new_server) from the old server (old_server), but I finally succeeded. Mysqldump usage: operate in the mysql/bin directory 1.

In front of this article, a lot of such articles are searched on the Internet. Why should we write it out? The reason is that most articles on Oracle 9i on the Internet are incorrect, and no matter what the sender is, the installation method

It is not easy to install the Oracle10G Database Under Fedora8. After some time of exploration, I finally installed it successfully! Now let's share the entire process. 1. Download Software10201_database_linux32.zip 2. decompress the file Unzip 10201

1. Installation and Environment SettingsI installed MySQL5.0 + MySQL-Front3.2 + mysql-connector-java-3.1.14The default setting is used.I am mainly used to support JDBC (put the mysql-connector-java-3.1.14-bin.jar under the JDK directory \ jre \ lib \

The logrotate tool is a log rollback program that comes with the Linux system. It is started by the cron program of the System Planning Service tool and can be used to roll back various system logs. Due to the rapid growth of Oracle listener logs,

User Management Use the orapworcl file (under $ Oracle_HOME/dbs) to verify remote user login. after removal, you cannot log on remotely (that is, you cannot use sqlplussys/sys123 @ lcro to log on ), however, local login is not affected. This file is

Back up and restore the Oracle database in Java. I don't know if there are any better methods. I hope some of them can also provide the following methods or code. Package com. servlet. util; Import java. io. File;Import java. io.

[Oracle @ www.bkjia.com ~] $ Expdp admin/admin tables = studentinfo, teacherinfo DIRECTORY = dpump_dir3 dumpfile = info. dmp content = all Export: Release 10.2.0.1.0-Production on Tuesday, 25 May, 2010 18:23:02 Copyright (c) 2003,200 5, Oracle. All

I. Bidirectional replication Node 2 Configuration:1) add additional redolog InformationDblogin userid ogg, PASSWORD ogg Add trandata scott .* 2) Configure extractGGSCI (cuug97) 11> edit params EORA_1 EXTRACT EORA_1SETENV (NLS_LANG = AMERICAN_AMERICA.

I. Preface: After a period of development and learning about the Oracle stored procedure, I wrote some summary and learning experiences during development to share with you. I hope this will be helpful to you. Ii. target readers: Database developers,

Environment: An openstack Virtual Machine with 8-core CPU, 16 GB memory, and GB disk Ubuntu 12.04x64 Server Install redis2.6.7 Process: During the experiment, we need to import 0.21 billion key-value data into redis for fast query. After

To adjust indexes, we can use the index monitoring feature provided by Oracle to track whether indexes are used. Although this feature does not provide the index usage frequency, it is still one of our reference methods. However, the index is also