Database Administrator

Export of Oracle 10g Data Pump Partition Table In Oracle 10 Gb, Data Pump supports local export/import of Partition Table partitions, but NET_LINK does not support partition tables. The following are some export experiments. Local export: C: \ Users

Oracle ASM errors-ORA-15031, ORA-15014 Oracle ASM errors-ORA-15031, ORA-15014 System Environment: Operating System: AIX 5.3.8 Oracle: Oracle 10gR2 Fault symptom: [Oracle @ aix213 ~] $ Sqlplus/as sysdba SQL * Plus: Release 10.2.0.1.0-Production on

In-depth analysis of RMAN-Incarnation application (Incomplete recovery) CASE Environment: Operating System: RedHat EL5 Oracle: Oracle 11gR2 When you use resetlogs to open the database during incomplete restoration of Media Recover, Incarnation

View conditions that allow DML operations A view can shield information about some base tables, or join multiple base tables to form a complex query. A view itself can also perform DML operations, but is limited by some conditions. Oracle DML

Resolution record of two Oracle configuration problems Whether installed or running, the Oracle database involves various relationships with peripheral software and hardware. To smoothly install and run a healthy database system, you must adjust the

Redis password management 1. How to initialize the redis password? A total of 2 steps: A. There is a parameter in the configuration file: requirepass, which is the parameter for configuring the redis access password. For example, requirepass test123 

Automated installation and deployment of MySQL Anyone who has been using MySQL O & M should be clear that online MySQL usually uses source code compilation, because this allows you to select the function to be compiled based on your own needs,

Basic concepts of data structures Data element: a basic unit that makes up data and has a certain significance. It is usually processed as a whole in a computer, also known as a record. Data items: a data element can contain several data items.

Create a sequence and view, and create a sequence View The project must ensure that the order number is unique. When the time is used to generate a large volume of business, there will still be duplicates. Solution: Create a sequence table and

MySQL inserts the data queried in Table a into Table B. mysql MySQL inserts the data queried in Table a into Table B. If table B exists insert into b select * from a; If table B does not exist create table b as select * from a; Extension: Insert

Notes on truncate table --- The following is a summary of the quotations of itpub's predecessors.   After truncate table, oracle recycles the index of the table and its table to the initial size, that is, the size of the initial allocated

ORM tool: nhib.pdf (1) Introduction, ormnhib.pdf Introduction: Object Relational Mapping. Why is ORM? Object-oriented features: The development language Java and. Net we usually use are object-oriented. The object is encapsulated with

Error message displayed in PLSQL Developer is garbled, plsqldeveloper Error messages in PLSQL Developer are garbled   Connection environment: win 7 Database Version: oracle 11g   Simulate an error and view the error prompt to display "???" The

Bison executable not found in PATH by mysql install, bisonexecutable [Root @ luozhonghua mysql-5.5.21] # cmake.-DCMAKE_INSTALL_PREFIX =/usr/local/mysql-DMYSQL_DATADIR =/data/mysql-DSYSCONFDIR =/etc -- Check size of pthread_t-- Check size of

[Translated from mos] in rac, The asmcmd command is used to move the system datafile from the file system to the asm disk group. asmcmddatafileIn rac, use the asmcmd command to move the system datafile from the file system to the asm disk

Build an Oracle10G (6) dbca database for RAC under AIX, and oracle10gdbca Establish a series of RAC instances under AIX Build an Oracle10G (6) dbca database with RAC under AIX Environment Node Node 1 Node 2 Small Machine

Solr in action Directory Part 1 first recognized SOLR 1 Solr Introduction 2. Getting familiar with Solr 3 Solr core concepts 4. Configure Solr 5. Create an index 6. Text Analysis Part 2 Solr core functions 7. Initiate query and processing results 8

Mysql fastest paging method, mysql Paging As we all know, mysql paging is written like this: select * from 'yourtable' limit start,rows A table in my database contains million pieces of data. The table name is tweet_data. select count(*) from

View the database again -- (2) view and database viewConcept * It is from the user's point of view on using the database. * Exported from one or more tables (Views) * A virtual table or a query table Why use a view? FirstSimpleAnd you can see what

Mysql Character Set settings Recently, I have been working on a mysql proxy project, which involves parsing SQL statements. I didn't know much about mysql before. As the project progresses, I had to make up for it. Today, I suddenly saw mysql's