Database Administrator

Batch export table data from Oracle to CSV files Requirement: Import multiple NTS that meet the conditions in the oracledata database into a csv1_file and store them with the table name. CSV as the file name. Implementation: It is implemented

Configure the Oracle database environment using Python 1. download and install the cx_Oracle installation package To operate the Oracle database using Python, you must first install the cx_Oracle package as

Blocking blocked in RAC Environment) The blocking in the RAC environment is different from that in a single instance, because we need to consider the session in different instances. That is to say, the corresponding strain of the previously queried

Learning notes on Redis installation and deployment1 Overview Currently, most NoSql databases are essentially key-value pairs, and Redis is no exception. As a cache database, Memcached has the following advantages: (1) in terms of speed, Redis is

Install the MySQL5.6 service on the CentOS Virtual Machine of Win71. Download the installation package Mysql5.6: Http://dev.mysql.com/downloads/mysql/ Select the linux version here: -------------------------------------- Split line -----------------

Adjusting the size of Oracle sga causes ORA-00851 and ORA-00844 errors Today, I adjusted the size of Oracle sga. the following error is returned when I restart the database.SQL> alter system set sga_max_size = 1024 M scope = spfile;SQL> shutdown

Basic AWR knowledge Since Oracle began to support AWR for 10 Gb, in addition to more new content for reference, compared with Statspack, HTML saving format also provides a lot of convenience for viewing documents. I recently read the books of nimiek

TNS-01201: Listener cannot find executablen error resolution The TNS-01201: Listener cannot find executable... error message was recently received when the Listener was started. This error has never been encountered. I really don't know what it is.

Questions about Oracle Database Development I recently attended several interviews to summarize the most common questions about competing for Oracle development jobs: 1. What is the difference between delete and truncate? 1) truncate is a DDL

Kettle empty strings Today, Kettle is used to find some problems. The database is MySQL and you need to copy the data of a table to the local database. The table structure is as follows: Kettle is as follows: An error is reported for such a

Create index hang (row cache lock) for the partition table in the RAC Environment) Create a bitmap index on a large table (Partition Table) today. After a period of execution, hang will wait for the event to be row cache lock. Query: SQL> Select

Oracle tablespace growth exception solution: Another example Description: The temporary tablespace of a database in the customer environment increases abnormally (with a random date). It may be caused by the scheduled jobs of the following two

Oracle current_date and sysdate time are inconsistent Some time ago, it was found that the operating system time of a newly loaded Rac database was incorrect. When dbtimezone was queried, it was found to be-, indicating that the time zone was

Common oracle functions (1): oracle Functions 1. Return the decimal number corresponding to the specified character Select ascii ('A') A, ascii ('Z') A, ascii ('12') a dozen, ascii ('') kg from dual; 2. returns the character corresponding to the

Batch Data insertion in oracle and oracle Once a function was developed, tens of thousands of pieces of data provided by others need to be imported, There are about 80 thousand pieces of data in a *. SQL file. Insert into testtable (id, name) values

Oracle column merge, oracle Column In many cases, we need to use oracle column merge. oracle provides some methods to merge multiple rows of data in a column into one row.   1. Use WMSYS. WM_CONCAT before 10 GBWmsys. wm_concat separates the field

PostgreSQL code analysis, query optimization, pull_ands (), pull_ors (), pull_andspull_ors PostgreSQL code analysis and query optimization. Here, we have finished sorting out the part of the regular expression. The reading order is as follows: I.

Oracle TIMESTAMP processing, oracletimestampPublic class Test {Private static final SimpleDateFormat FORMAT = new SimpleDateFormat ("yyyy-MM-dd HH: mm: dd ");Public static void main (String [] args) throws SQLException {Oracle. SQL. TIMESTAMP temp =

[Translated from mos] explanation of the account_status column in The dba_users view, dbausers Description of the account_status column in The dba_users View Reference Original:How to Interpret the ACCOUNT_STATUS Column in DBA_USERS (Doc ID 260111.1)

Sap uses VMD_EI_API => MAINTAIN to create supplier master data, sapvmd_ei_apiFRM_VENDOR_CREATE.DATA: LV_FLG.DATA: LS_MAIN TYPE VMDS_EI_MAIN,LS_MESG TYPE CVIS_MESSAGE,LT_MSG TYPE BAPIRET2_T,LWA_MSG TYPE BAPIRET2,LT_VEND TYPE VMDS_EI_EXTERN_T,LWA_VEND