Database Administrator

Create table a (content clob ); Select content from; The displayed content is part of the cotent content and garbled characters. Because a is of the clob type, it cannot be displayed directly from the select result. You need to use the Oracle

All these operations are performed in Linux and the root permission is required. Installation start: Shell> groupadd mysql Shell> useradd-g mysql Shell> gunzip | mysql-VERSION.tar.gz | tar-xvf- Shell> cd mysql-VERSION Shell>./configure -- prefix

1. Because orcale10 does not support RHEL5, you need to change/etc/redhat_real.pdf to Red Hat Enterprise Linux Server release 5 (Tikanga) to Red Hat Enterprise Linux Server release 4 (Tikanga) 2. Modify the/etc/hosts file and change 127.0.0.1 to

If you want to import EXCEL or CSV data to MySQL, MySQL's CSV engine is no longer suitable. MySQL CSV engine is provided after 5.0, but does not support WINDOWS. It is only supported by 5.1. The version I tested today is 5.0.45. I. Notes:1. No index.

First, install the ODBC driver unixODBC on Linux. Www.unixodbc.org After the download, you can also select the graphical interface for installation. Relevant documents are also available on this website. UnixODBC can connect to SQL 2000. mssql and

The following is in Windows, not in Linux. When querying data using the MySQL command line, screenshots are often used to send posts, such: In this way, the display is not convenient, and the display speed is slow. How to extract data into text:

In some cases, the stored procedure in Oracle becomes invalid. A Red Cross is displayed in the upper left corner of the stored procedure icon in PL/SQL Developer. For example, if the objects referenced in the stored procedure are invalid, dblink may

I am familiar with MongoDB because I recently tested MongoDB. MongoDB is still simple, and I have mastered a lot of content in just one week. It is much easier than other databases. I installed: MongoDB version 2.0.8 System: 64-bit Ubuntu

Most of the steps to use hive for data analysis are to use hive to export the statistical results to a local file or other Hive tables, import the local file to mysql or use sqoop to import the Hive table to mysql. Today, my colleague recommended a

Data files in the UNDO tablespace are directly deleted from the OS, and the database has not been shutduwn, and UNDO needs to be restored. 1. The database is running normally; 2. rm-fundotbs02.dbf: the database runs without knowing it until there is

Many people know that LOGMNR is used to analyze logs, but few use DUMP to analyze logs. This is because the information analyzed by LOGMNR is easy to read and understand. But sometimes we still need to DUMP to analyze the log file, because it

This section briefly introduces flashback database, which can be executed in RMAN or SQL * PLUS. Sometimes it is quite practical. Prerequisites: 1: The Archive mode is required. 2: The flash recovery area must be specified. SQL> show parameter

1. I carefully read the Flush syntax and often use the Flush command at work. Here I will summarize it. MySQL FLUSH syntax (clear or reload internal cache) FLUSH flush_option [, flush_option]. If you want to clear some MySQL instances using internal

1. Functions of statistical information The CBO-based optimizer in Oracle relies heavily on statistics when generating execution plans. You can understand CBO as a complex mathematical model, statistics are the most important input, and execution

For the sake of database data security, the exp command is no stranger to most Oracle users (especially database administrators). This exp command can complete various backup of database data, for example, full database, specific user, and specific

Oracle 11g installation prerequisite check all failed, unable to install, display the reason for NA and SolutionWhen installing Oracle, even if the Java environment has been installed in advance, run the installation as Administrator to enable the

1. Source Code download and preparationPostgreSQL uses the flex and yacc scripts respectively for lexical and Syntax Parsing, that is, the. l and. y files in the source code are generated by them. c and. H files.For more details,

Variable declaration in PL/SQL programmingCreate the first program hello worldbegindbms_output.put_line ('Hello World'); end;/set serveroutput on; (output statement to dos window command) begindbms_output.put_line ('Hello World'); end; /You can see

I used SUSE10 SP3 to install Oracle 11g R2, but when I logged on to EM, I found that the buttons such as "cancel" were all small boxes, and google found a solution later, the EM garbled code is caused by java, and the EM button is a graph generated

To access MySQL on CentOS from a Windows client, you need to disable the firewall on CentOS, grant the database user remote access permission, and clear the permission cache. The specific configuration is as follows: [Root @ mysql ~] # Service