Database Administrator

Oracle EXP export error EXP-00091 Analysis Solution Oracle EXP/IMP is an early data backup and restoration tool. It is widely accepted by the industry for its ease-of-use and powerful features. Some development tools (such as PL/SQL Developer) even

ORA-16014: Log 1 serial number 242 Unarchived, no available destination SQL> alter database open; *Row 3 has an error:ORA-16014: Log 1 serial number 242 Unarchived, no available destinationORA-00312: Online log 1 thread 1:'C: \ Oracle \ PRODUCT \ 10.

Oracle uses TRACE for SQL Performance Analysis If the SQL _trace parameter is set to true, the entire instance will be tracked, including all processes: User processes and background processes, which may cause serious performance problems and must

ORA-01110 ORA-01180 error reported when rman backup is restored to an exception [Oracle @ server1 ORACLE] $ rman target/ Recovery Manager: Release 10.2.0.5.0-Production on Thu Jul 31 13:51:40 2014 Copyright (c) 1982,200 7, Oracle. All rights

How to check the storage engine type of MySQL Data Tables on Linux Question: I want to know whether my MySQL database is of the MyISAM or Innodb type. How can I check the MySQL database table type? MySQl mainly uses two storage engines: MyISAM and

Create a role random name (mysql extraction random records) and mysql cursor usage, mysql cursor I have encountered some problems in development recently. I have forgotten the solution here. 1. Currently, when creating a game role, it basically

Account alias miscellaneous transaction processing, account alias Transaction ProcessingZookeeper account alias for miscellaneous Transaction ProcessingSELECT mtl_material_transactions_s.nextval INTO orders FROM dual; OPERATOR: = Operator; l_mtl_txn_

SQL Server database does not have three solutions for valid owners. Problem: During the development process, the operating system had a problem and decided to reinstall the system. However, the SQL Server database file is not separated and the

ORACLE parameter file introduction, oracle parameter Introduction After the ORACLE database is started, you can use the select * from v $ parameter statement to view all the parameters used by the oracle database.   Oracle parameter files are

MongoDB database details (1). mongodb details MongoDB> port 27017 I. What is Nosql (object-oriented storage-key and value) Ii. CognitionMongoDB (json storage)   How to Create a mongodb database with a user name and password I'm so

Database downtime migration oracle10g instance and oracle10g migration1. Operation 1.1 of the original database view original configuration 1.1.1 view User Permissions View user system permissions: SQL> select * from user_sys_privs; View User

First paradigm, second paradigm, third paradigm, paradigmFirst paradigm, second paradigm, third paradigm, first paradigm If all the attributes of a relational model R are basic data items that cannot be divided, then R is 1NF (that is, R conforms to

Create a partition on the Oracle 11g virtual column, oracle11g On Oracle 11g, partitions can be performed on virtual columns. This feature is useful. Let's perform a test: SQL> select * from v $ version;BANNER ----------------------------------------

OpenCV basics-Mat data structure and opencv BasicsProcedure and Analysis /* * FileName : MatObj.cpp * Author : xiahouzuoxin @163.com * Version : v1.0 * Date : Thu 15 May 2014 09:12:45 PM CST * Brief : * * Copyright (C) MICL,USTB

The procedure of the test interview (Database-paradigm) and the test paradigm 1> related concepts and knowledge Data Dependency: reflects the constraint relationship between internal attributes of a relationship. It is an abstraction of the

Impdp import Materialized View (mv) error: ORA-31685: Object type MATERIALIZED_VIEW, impdpora-31685 This article is the original article, reprint please indicate the source: http://blog.csdn.net/msdnchina/article/details/38782657 Impdp import

Analysis of hang failures in the ndmcb database, ndmcbhang Problem description: When I arrived at the office in the morning, I received an email from the monitoring staff. The ndmcb407 database was restarted last night. Let me analyze the cause of

Table space Status (1). Table space status A few days ago, I asked a question about the table space status and exposed my weak basic knowledge. I summarized the following two blog posts to let myself calm down and fill in the relevant knowledge

MySql intercepts the DateTime field's date value, mysqldatetime Use DATE_FORMAT to format the Date Field SELECT DATE_FORMAT(crt_time,'%Y-%m-%d') FROM ad_n_advertise_t In mysql, how does one obtain the year and month of a date field? For example,

SQL Server lock queuing mechanism, SQL Server queuing mechanism 1. Create a new table and insert 1010000 data: create table test(id int identity(1,1) ,name varchar(600)) goinsert into testvalues(replicate('a',600));go 1010000create index