Database Administrator

Oracle user password Problems Oracle users seldom pay attention to their passwords. Generally, the password expiration time is set to never expire after the database is installed, but an error occurs when autotrace is enabled, it attracted my

Troubleshooting of default temporary tablespace and redo log files in Oracle Problem: I want to synchronize Oracle Data to MySQL now. the ETL tool is used because the data volume is large and temporary tablespace is used for subqueries, resulting in

Actual RMAN Migration Operations-additional common commands Operation scenarios Source server OEL 6.3 11G R2 11.2.0.3Target Server OEL 6.3 11G R2 11.2.0.3The data storage path of the source server and target server is the same. Source Server[Oracle @

Use C language to operate MySQL Databases-General edition and general edition of mysql DatabasesUse C to operate MySQL Databases First look at the struct:The following code block is the communication process used to connect to the database. To

Check whether the SQL server has repeated values. Check whether the SQL server has repeated values.A string is "1; 2; 1; 1; 1 ".Excuse me:How to implement the following functions in SQL SERVER:1. check whether there are repeated numbers in the

InnoDB Insert (Insert) operation (II)-mysql technology insider, innodb-mysql I want to prove the relationship between the mysql innodb Storage engine, commit operations, and flush data to the disk. After talking with colleagues, he said, you

Oracle 11g R2 installation tutorial, oracle11g I, Note that Oracle is divided into two files. After downloading, extract the two files to the same directory. In the path name, it is best not to show Chinese characters or irregular characters such as

Column not found caused by mysql alias in SQL, mysqlcolumn Caused by: java. SQL. SQLException: Column 'btn _ ICON 'not found. The error message indicates that a field in the table cannot be found, but this field does exist in the table. This

SQL Script for select data from ebs and make a csv file to FTP, ebscsv Declare cursor cur_lcy_test is select rcta. customer_trx_id, rcta. trx_number, rcta. trx_date FROM ra_customer_trx_all rcta WHERE rcta. customer_trx_id = 11993; -- rec_lcy_test

Locate the problem of log file switch (checkpoint incomplete), incompletezipfile Today, in the test environment, the application is slow and an error occurs in the database. Report the error directly to AWR.Because it is a virtual machine, you do

Hive index, hive 1. Hive index Overview Hive indexes aim to improve the query speed of specified columns in Hive tables. If no index exists, a query similar to 'where tab1.col1 = 10', Hive loads the entire table or partition and processes all the

HBase cannot connect to ZooKeeper. hbase connects 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 shellSLF4J: Class path contains multiple

SQL queries the example of the table, stored procedure, trigger Creation Time, and last modification time. The creation time is modified. -- Query creation time -- table select * from sysobjects where id = object_id (n'table name ') and xtype = 'U'

Improvements to the Hive Optimizer, improvementshive LanguageManual JoinOptimization Improvementsto the Hive Optimizer Hive can be automatically optimized, and some optimization cases are improved in Hive 0.11. 1. The JOIN side is suitable for

SQL Study Notes (21) ---------- add Foreign keys and Study Notes ---------- I have been busy with exams recently! As soon as I saw the exam, I was covered! Completely blank brain, uncontrolled, coupled with abnormal invigilators, let alone how

MySQL is sorted by Chinese characters and Pinyin letters, and mysql is sorted by Chinese Characters If the MySQL encoding format is GBK character set, you can add Order by name asc; -- sort in ascending order If the utf8 character set is used,

Recent R learning overview and R learning OverviewI have been a little busy recently, and I am learning a little less. Previously, I learned the R language for a short period of time, mainly in R language practice. I read a part of it and practiced

Detailed configuration and deployment of SQLServer replication and database images, detailed configuration of sqlserver SQLserver can deploy images and copies at the same time, and combine the high availability of both parties to ensure better

MySQL updates Chinese columns: 1366 Incorrect string value solution, 1366 incorrect Environment: mysql-5.6.25-winx64, MySQL workbench Problem: An exception occurred during MySQL update: Warning (s): 1366 Incorrect string value: '\ xE8 \ x82 \ x96

Database Paradigm (normal form NF), normalnf 1. Currently, there are six paradigms: 1NF, 2NF, 3NF, BCNF (base-cod paradigm), 4NF, and 5NF (perfect paradigm ). 2. Various paradigms are progressive, backward compatible, that is, to meet the second