Database Administrator

1. Create a tableCreate table cj_jt_nscpdmdy(ID VARCHAR2 (40) not null primary key,CPBH VARCHAR2 (80) not null,Nsbh VARCHAR2 (80) not null,BZ VARCHAR2 (80)); 2. Test Data Insert into cj_jt_nscpdmdy values (1,001,001, 'enabled ');Insert into

Oh, when you create a stored procedure, you can directly create it in the form of "create or replace procedure stored procedure name" without any problems, in the past two days, I tried the inventory package in the project. During the storage

In Ubuntu Linux, MySQL table names are case-sensitive by default, while in Windows, MySQL tables are case-insensitive by default.The specific method for modifying MySQL is as follows:Java code Sudo vi/etc/mysql/my. cnf  It means to first find

We know that Oracle will switch logs when the current online logs are full or some conditions are met, or when logs are manually switched, even if the current online log group is from this log group to another log group, the log loop mechanism is

Today, we need to uninstall Oracle 10.2.01 in the lab room, and then install Oracle 10.1.03. It took a long time to unmount the database because of lack of experience. At last, we had a great sense of accomplishment. Log on to the system as the

If you need to directly operate the database and write SQL scripts to create a spatial database, you must note that you need to write some necessary metadata information into the corresponding table after creating the database, then insert row data

When you use PLSQL Developer to connect to Oracle9i, you only need to configure the Net Configuration Assistant and test it successfully. Then, you can use it on the PLSQL Dev connection. However, when you connect to Oracle10g, the following error

To improve the performance of the Rsyslog + MySQL + LogAnalyzer system, we made a partition table for MySQL. The results showed that the problem could not be solved fundamentally. A feasible solution may be like a storm: one table per day. A system

* Environment: windowsXP + Oracle10gR2* AutoTRACE is a simple and convenient tool for analyzing SQL Execution plans and execution efficiency.*/ AUTOTRACE is an SQL * Plus function that automatically generates an execution plan for an SQL statement

Preparations: Create user and user group Groupadd mysql Useradd-g mysql 1: Download: Bison-2.4.2.tar.bz2 Cmake-2.8.3.tar.gz Make-3.82.tar.gz Bzr-2.3b5.tar.gz Mysql-5.5.8.tar.gz 2: decompress and install the first three packages Tar zxvf

In Oracle, it is a Long type. How to obtain, insert, and modify it in Java: Reader reader = rs can be used online. getCharacterStream (1); get Long data, but I use ds directly. no error is reported when getString () is obtained, and the database is 9

Recently developed a J2EE project, using the database is Oracle, the test process found that occasionally there is a ORA-01461 can bind a LONG value only for insert into a LONG column exception thrown, at first, an exception was thrown because the

When Oracle 11G is exported using EXPORT, empty tables cannot be exported. There is a new feature in 11G. When the table has no data, no segment is allocated to save space. Solution: 1. insert a row and then roll back to generate a segment. This

Some things can only be exposed during long stress tests. The MongoDB cluster has been in use for several months, but after a long-running stress testing program is written, the primary server cannot be started for a few days. View MongoDB log error

It is estimated that you are not familiar with the Oracle user creation process. You can do this step either by yourself or by using your own exercises. Some people are familiar with this step, some people still like to copy and paste the script of

08:29:43 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rep_app.prm: No unique key is defined for table 'C '. all viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.08:2

Environment: linux x86 64 10.2.0.1 Error: sqlplus/as sysdba ORA-01031 insufficient privileges while sqlplus sys/password as sysdba can login Check: Once you rename the orapwd file, sqlplus sys/password Logon also fails, proving that the password

MySQL is an open-source small-scale associated database management system. The developer is MySQL AB in Sweden. MySQL is widely used in small and medium websites on the Internet. Because of its small size, fast speed, and low total cost of ownership,

Run Eclipse, create a new Java project "HBaseClient", right-click the project root directory, select "Properties"-> "Java Build Path"-> "Library"-> "Add External JARs ", after HBase is decompressed, all the jar packages under the

1. Create a table with an empty eygle 2. Create a user's eygle, which belongs to the eygle tablespace; grant the user the DBA permission 3. log on to the database as an egyle user and create the table test_egyle. 4. rman backup the egyle