Database Administrator

Use PL/SQL to connect to Oracle without installing the Oracle client Want to connect to the Oracle database? Install the client. OH ~ NO !, A few hundred megabytes are missing. Now you only need to download a software named Instant Client Package

Why didn't Oracle RAC Opatch go to Rac database home during auto? First explain the environment:Operating System: AIX 7.1Oracle version: Oracle Rac 11.2.0.3I used the 11.2.0.3.9 patch set before and it was not officially used for Rac installation,

Oracle Database Remote Access through DBLINK What is DBLINK? A Database Link is a Database Link, just like a telephone line. It is a channel. When we want to access data in another Database table across local databases, you must create a dblink for

Installation of Oracle Database 12C in Linux Install Oracle Database 12C in Linux. After the installation, Oracle Configuration Manager fails to be properly installed, which does not matter. It will be installed later. It must be about environment

How to build an Oracle 11g license uard   I. PreparationsI have read many tutorials when preparing to build a tracing uard. I followed the tutorials and encountered problems. Then I don't know how to proceed to the next step.Later, I went to the

[Practice]: Synchronize SQL server data to mysql and SQL Server mysql in real time 1. Install and install mysqlconne 2. Configure mysqlconnector ODBC data Manager-> system DSN-> Add-> mysql ODBC 5.3 ANSI driver-> Fill in the data source name, such

Oracle redo complexity-oracle Core Technology Reading Note 3, redo-oracle I. Overview We know that in oracle, Every modification to a piece of data generates a redo (that is, redo, which records the modified content ). The purpose is to back up the

PentahoReport Designer getting started tutorial (2), powerdesigner tutorial PentahoReport Designer getting started tutorial (2) Pentaho Report Designer5.1 is the latest version. I. Installation and introduction This section describes how to install

MongoDB database installation details (2). mongodb details How to change mongodb in java Java-based mongodb insert, read, modify, and delete operationsThis article describes how to operate MongoDB in Java and how to perform routine

Mysql query today, yesterday, last 7 days, last 30 days, this month, last month data, mysql January Recently, the data record query function for the current month was used in the project. The original idea was to construct a period of time in the

Remember a bizarre TNS-12545 TNS-12560 TNS-00515, tns-12545tns-12560 Recently, reportDB listeners cannot be started with the system, which is a strange phenomenon. Because the listener of another instance on the server can be started normally, it is

Basic knowledge of SQL injection and basic knowledge of SQL Injection What is SQL Injection) The so-called SQL injection attack means that an attacker inserts an SQL command into the input field of a Web form or the query string requested by the

Learning MongoDB 6: MongoDB query (cursor operation, cursor information) (3), mongodb cursorI. Introduction Db. collection. find () can be used to query based on conditions and specify fields returned using the projection operator to omit this

Mongodb advanced 2: mongodb aggregation and mongodb advanced AggregationIn the previous article we talked about mongodb's advanced query: http://blog.csdn.net/stronglyh/article/details/46817789 This article introduces mongodb aggregation. I. mongodb

Migrate SQL server data to mysql and sqlmysql The newly added project is just getting started, and many technologies have not yet been finalized. Originally, the team lead decided to use SQL server. These days they have been busy designing

Oracle BASICS (II): user and permission management, and oracle permission management1. Create a user(1) simple creation 1. Permissions: only DBA users have permissions or create user system permissions 2. Syntax: Create user Username identified by

Comprehensive Sqlite Learning (1), sqlite Learning Finally, CSDN was chosen to sort out the knowledge points published over the past few years. This article was migrated to CSDN in parallel. Because CSDN also supports the MarkDown syntax, it's

Postgresql database import and export, postgresql Import and ExportExport a remote database 1. Export the threshold table structure and data to the file threshold. SQL from the database monitor on the remote database IP Address: pg_dump -t threshold

It takes only 6 minutes to scan a 166G table from an oracle full table, and oracle166g How can I maximize the cpu usage? How to quickly scan a large table. If a large table has a primary key, count (*) takes the primary key. oracle only needs to

Data is an important asset of an enterprise's data center. obtaining and maintaining high-quality data is critical to efficient IT and business operations. In the face of increasing complexity of business data, how can we fully ensure data quality?