Database Administrator

Create a log file in Oracle The syntax for creating a log file in Oracle is as follows: Alter database database_name add logfile [group group_number] (File_name [, file_name [,...]) [SIZE number] [reuse];The syntax is described as follows;Group

Oracle tablespace recovery If the test. dbf data file of test in a tablespace is deleted by mistake, and the database cannot be opened the next time you restart the database ),Always reports an error: SQL> alter database open;Alter database open

MongoDB Study Notes (2)-basic connection example between Node. js and MongoDBPrerequisites Node. js and MongoDB have been installed. The node. js used in this article is v0.12.0 and MongoDB is 3.0.0. MongoDB Study Notes (1)-install MongoDB on

Ms SQL Server, mssqlserver /* BY Dylan SUN */ In SQL server when you want to make an existing column to be auto-incremented. The following code is not working: ALTER TABLE [dwh].[ExchangeRate]ALTER COLUMN [ExchangeRateId] Int Identity(1, 1) What

Basic MySQL operationsReprinted please indicate Source: http://blog.csdn.net/u012637501 (embedded _ small J of the sky)I. Create a MySQL database1. Create a database and a table■ Create database statement: create database [database name]; ■ database

What is a cursor? For the table structure in this instance, see the document "Create a table, insert an id column, and automatically generate an id ". Use yuyongTest; Declare @ tot int; Set @ tot = 0; Declare @ name nvarchar (50 ); Set @ name = '';

CentOS 6.5 mysql installation, centosmysql 1. Uninstall the original mysql Mysql databases are too popular in Linux, so the mainstream Linux system versions currently downloaded are basically integrated with mysql databases, run the following

Are you still worried about database garbled Characters ?, Database garbled troubles 1. First, you need to modify the mysql database configuration file my. ini, This file is stored in the mysql root directory. Search for the default-character-set

Database Upgrade Code learning and Database Upgrade Code Business scenarios and requirements:After the product is launched at each banking outlet [in cooperation with the Company] in China, you must upgrade your business to meet new functional

Study database notes 3. Database notes I Select query model? Very important! Determines whether you can write powerful query statements! Model [columns are variables (variables can be calculated, so columns can be computed) After where is an

SQL Server database image (2) complete image script configuration in the domain environment, SQL Server Image SQL Server database image (1) image script configuration without witness on a single server SQL Server database image (2) complete image

MySql time processing and mysql Processing Many times, we want to process the time when querying the Mysql database, such as formatting or other operations. This avoids further processing, mysql also has many time-related processing functions. Today,

Oracle unique constraints and oracleunique ConstraintsA unique constraint is a unique constraint that specifies that duplicate values are not allowed in column types. You can add a unique constraint for a single column or a unique constraint for

Rhel6 versions with intel xeon processors, rhel6xeon A few days ago, in the general "oracle O & M advanced group", BBQ said a RHEL bug, which is included in the following URL:Https://access.redhat.com/solutions/433883 This problem does not occur on

Bcp sqlcmd bulkinsert unicode problem, Unexpected EOF encountered in BCP data-file, sqlcmdbulkinsert Senario Go to sqlcmd to generate a data file with: out xxx. The-u (unicode) switch is used because sqlcmd export to file is garbled with Chinese

Connect to the mysql database in JAVA and javamysql Database Last week, I designed the database course, using java and mysql databases, which involves the knowledge of connecting to the database using java. package entity;public class user {

Let your eclipse implementation write JAVA code, HTML, CSS, JAVASCRIPT code prompts, eclipsejavascript 1. Open eclipse → Windows → Preferences → Java → Editor → Content Assist Modify Auto Activation triggers for java to: zjava click apply 　　 　　 2

Redhat6.3: redhat6.3oracle10gVersion description: Operating system version: redhat6.3 x64 Oracle version: 10.2.0.1 Experience: Some problems are encountered during version matching today. This is mainly caused by missing packages. Let's summarize it

PostgreSQL dropdb connection not closed, postgresqldropdb For example: Solution: 1. select * from pg_stat_activity where datname = 'lnarterydb' // query sessions in the database The query result has two PIDs. 2. SELECT pg_terminate_backend

Using GoldenGate EVENTACTIONS to customize processing, goldengate EVENTACTIONS can specify some keywords to trigger some events. The keywords include IGNORE, DISCARD, ABORT, STOP, SHELL, TRACE, and LOG. For Example：GGSCI (zbdba1) 6> view param