Database Administrator

C # insert Timestamp data in Oracle In project development, it is required to save the time in milliseconds. Although the DateTime type in C # has the Millsecond attribute, the data in milliseconds cannot be saved when the Timestamp type Oracle

Oracle 11g uses slave backup to restore the standby Database Oracle 11g uses slave backup to restore the standby Database 1. Start backing up the slave DatabaseFirst, check the path of the control file, redo, undo file, and data file. 1.1 disable

Oracle 11g online reconstruction table Before Oracle9i appeared, you can only re-define the table by moving or exporting and importing the table. Therefore, the table redefinition process may be quite long or offline, during this period, the

Oracle proposes to use G1 as the default Garbage Collector for Java 9 Oracle is considering including JEP 248 in Java 9's JEP list, that is, using G1 as the default Garbage Collector in server configuration. This decision has sparked some debate in

FORALL and bulk collect statements for Oracle databases Let's take a look at the execution process of PL/SQL blocks: When the PL/SQL runtime engine processes a piece of code, it uses the PL/SQL engine to execute Procedural Code, the SQL statement

HBase cannot connect to ZooKeeper The following error is reported when you log on to the server after setting up the HBase Environment last time: Hadoop @ gpmaster logs] $ hbase shell SLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found

Regular functions in SQL There are four functions that support regular expressions in Oracle:1. REGEXP_LIKE: similar to LIKE, it is much more powerful than LIKE.2. REGEXP_INSTR: similar to INSTR.3. REGEXP_SUBSTR: similar to SUBSTR.4. REGEXP_REPLACE:

Mysql uses a cursor to delete a stored procedure, mysql cursor BEGINDECLARE hprocessInstanceId bigint DEFAULT 0; -- Historical Process instance idDECLARE hprocessInstanceIdStarttime CHAR default ''; -- Historical Process instance Start TimeDECLARE

Mongodb Study Notes 09, mongodb Study NotesOverview Shard sharding divides different data into different servers. Model Where: All user operations on mongodb are requested from mongs.Configsvr is used to save a piece of data on which shardHow to

Mysql logon ERROR 1045 (28000), 1045280001. symptom:[Root @ localhost ~] # Mysql-u root-pEnter password:ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES)2. cause: the database contains empty users.3. solution:1)

How to apply a key-value storage database or an embedded key-value storage database in embedded products [Disclaimer: All Rights Reserved. You are welcome to reprint it. Do not use it for commercial purposes. Contact mailbox: armink.ztl@gmail.com]1.

Sedna loads xml files and sedna loads xml files Suppose there is an xml file named a. xml, which needs to be loaded into the sedna database xml_db. Sedna loads xml into the database through se_term. There are two methods: 1. Use the-query

Introduction to set serveroutput on in Oracle, oracleserveroutputDefinition Set serveroutpu on enables oracle to use its own output methodDbms_output.put_line ('xx ');Scope of use Used in PL/SQL command window and SQL PLUSPermanently valid To

NoSQL database overview and its comparison with SQL syntax, nosql overview SQL syntax Abstr:] HBase is a highly reliable, high-performance, column-oriented, and Scalable Distributed Storage System. It is also one of the well-known NoSQL databases.

Mongodb Study Notes 08 and mongodb Study Notes Official documentation:Http://docs.mongodb.org/manual/replication/ Replication sets multiple servers maintain the same data copy Step 1: how to use a replica set When mongod is started, you must

[Oracle error collection]: ORA-12154: TNS: Unable to parse the specified connection identifier, ora-12154tns I believe this error is not unfamiliar to everyone. As long as Oracle is installed and used, it is estimated that this problem has been

Mongodb distributed cluster (4. Integration of shards and replica sets) and mongodb ClusterOverview The previous three blogs talked about mongodb's distribution and clusters. The first type of master-slave replication is almost useless, which makes

Oracle vs SQL Server, oraclesql With the changing learning knowledge, in order to use a variety of learning needs, the databases that access different data processing are also full of feelings for SQL, because they do. the net system uses SQL to

Mysql first-day architecture, mysql first-day ArchitectureArchitecture Mysql separates query processing from actual data storage and extraction (storage engine) operations. The overall architecture is as follows: Connectors can understand JDBC and

New Features of oracle11g-SQL Plan Management (SPM) and oracle11gspm 1. Introduction Oracle Database11gR1 introduces SQL PlanManagement (SPM), a new tool that allows DBA to capture and maintain the optimal execution plan for any SQL statement. This