Database Administrator"

The common thing about a database is that it stores data in a warehouse, and our operations on the database can be the same as what we store or take out in a warehouse. If we need to access things from a warehouse, first we need to know where the

Oracle Database Remote Access through DBLINK

Oracle Database Remote Access through DBLINK What is DBLINK? A Database Link is a Database Link, just like a telephone line. It is a channel. When we want to access data in another Database table across local databases, you must create a dblink for

Oracle reconstruction control file-Rebuild controlfile

Oracle reconstruction control file-Rebuild controlfile The DBA needs to know when recreating the control file, but it may not be able to reproduce the system throughout his career. First of all, it is emphasized that backup is the safest, quickest,

Hive UDF, UDTF, and UDAF

Hive UDF, UDTF, and UDAF This topic describes the basic knowledge of Hive udfs, UDTF, and UDAF. To get started, first create a table "apache_log" in Hive" Create table apachelog (Host STRING,Identity STRING,User STRING,Time STRING,Request

GreenPlum database fault recovery test

GreenPlum database fault recovery test This article describes gpdb master fault and recovery testing and segment fault recovery testing. Environment Introduction:Gpdb version: Binary version 5.5.0OS: CentOS linux 7.0Master segment: 192.168.1.225/24

HBase cannot assign permissions to users

HBase cannot assign permissions to users HBase cannot assign permissions to users and reports an error. Problem background description: In the test environment, hdfs is formatted. Many hdfs-based environments are affected. Hbase is also affected.

The SEGMENT_SIZE does not change after the TRUNCATE TABLE

The SEGMENT_SIZE does not change after the TRUNCATE TABLE In the test environment, historical transaction tables can be cleared and only the table structure needs to be retained. Therefore, we wanted to clean up the space through TRUNCATE. We found

OGG synchronizes Oracle Data to Kafka

OGG synchronizes Oracle Data to Kafka Environment:Source: Oracle12.2 ogg for Oracle 12.3Target: Kafka ogg for bigdata 12.3Synchronize Oracle Data to Kafka through OGG Source Configuration:1. Add additional logs to the table to be synchronizedDblogin

Install and use the MySQL Performance Testing Tool sysbench

Install and use the MySQL Performance Testing Tool sysbench We need to use AWS and Azure MySQL services at work. We need to test and compare the performance of the two cloud services. As a result, Baidu + google began to search for performance

Ambari Hive cannot be properly queried

Ambari Hive cannot be properly queried 1. An error occurred today. After connecting to hive, no command can be executed. $ Beeline-u "jdbc: hive2: // hostname.domain.cn: 10000/default; principal = hive/_ HOST@domain.com ;"Connecting to jdbc: hive2: /

How to scale up a MySQL shared tablespace

How to scale up a MySQL shared tablespace 1. What are shared and exclusive tablespaces? Shared and exclusive tablespaces are used for data storage. Shared tablespace: All table data of a database is stored in one file. By default, the file path of

Export the table creation statement in the MySQL database to a file using Python

Export the table creation statement in the MySQL database to a file using Python To control the version of Data Objects, You need to export the table structure in the MySQL database to a file for version management. After a try, you can completely

Test the hash index and principles of MySQL

Test the hash index and principles of MySQL 1. hash index: (hash index) is implemented based on the hash table. Only queries that precisely match the index column can achieve the effect. For each row of data, the storage engine calculates a hash

Write DMP files to aws rds Oracle using Python scripts

Write DMP files to aws rds Oracle using Python scripts RDS (Oracle) does not directly support SSH or FTP (based on security factors). Therefore, the dmp files from the original system expdp or exp cannot be directly imported into RDS. In the

Detailed description of the Length Value of the mysql int type

What is the length of the int type after mysql creates a table? Is this column the maximum width allowed to store values? Why can I set it to int (1) and save 10,100,100 0.At that time, although I knew int (1), the length of 1 does not mean that the

JDBC small instance tutorial

Public class Base {public static void main (String [] args) throws Exception {// TODO Auto-generated method stubtemplate ();} static void template () throws Exception {Connection conn = null; Statement st = null; ResultSet resultset = null; try {// 2

JDBC database API comparison instance learning

/* Function: batch process data in the database. For example, enter one thousand data records, it is obviously a waste of time to insert a record after each operation, such as creating a connection, and then disconnecting and then creating an insert,

Use shell scripts to access the mysql database

Link: http://www.vpsee.com/2009/08/use-shell-script-to-access-mysql/ In the afternoon, I wrote a simple bash script to test the program and input a test case file, Output the test cases and results that fail the test and save the results to the

EXP, how to fix the garbled comment during database migration by IMP

The reason is that the client character set is not set during the export, or the settings are incorrect. It's okay to change it to DB.Check the character set (select userenv ('language ') from dual ;)The exported character set is SIMPLIFIED

Create Table space, user, resize, and move data files

2 logging3 datafile '/opt/oracle/oradata/bisal/test_data_01.dbf'4 size 10 M5 autoextend on6 next 10 m maxsize 2000 m7 extent management local;Tablespace created. Total 1.5 GB-Rw-r ----- 1 oracle oinstall 11 M Sep 27 22: 56 test_data_01.dbf 2

Total Pages: 1013 1 .... 4 5 6 7 8 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.