Database Administrator

Df-h to view disk space, found/dev/sda11/app 100% File System capacity used available % mount point/Dev/sda9 9.5 GB 539 M 8.5G 6%//Dev/sda11 99G 94G 766 M 100%/app/Dev/sda8 9.5G 151 M 8.9G 2%/home/Dev/sda7 9.5G 151 M 8.9G 2%/tmp/Dev/sda6 9.5G 4.2G 4.

When developing a database, you may sometimes need to read data of the clob type in the Oracle database. For the purpose of code reuse, I wrote the following stored procedure: Read the data of the clob field in the database. I hope to share with you.

Both primary key and unique key are uniqueness constraints. But there is a big difference between the two: 1. One or more columns of the primary key must be not null, If this column is set to NULL during table creation, the column is automatically

1. Create a database:Create database database_name;Two methods for creating a database in php: mysql_create_db (), mysql_query ())$ Conn = mysql_connect ("localhost", "username", "password") orDie ("cocould not connect to localhost ");1.Mysql_create_

I. Define substitution Variables 1. Set the exact value through DEFINE Define myv = 'King '; The value of the variable myv is King. 2. Define a variable using ACCEPT and prompt you to enter its value Accept myv char prompt 'enter a last name :' The

Download and install navicat 9.0 Premium (Advanced English version) and connect to mysql normally. We can see that it supports both Oracle, sqlite and postgresql, and want to connect to oracle for centralized management. 1. However, a listener error

Method 1:SELECT 'create SEQUENCE '| SEQUENCE_NAME | 'crement BY' |INCREMENT_BY | 'start with' | LAST_NUMBER | 'maxvalue' |MAX_VALUE | 'cache' | CACHE_SIZE | 'order NOCYCLE ;'FROM user_SEQUENCES;The result is similar:Create sequence ARTCOMMENT_SEQ

Oracle10 Client installation 1. First, go to www.oracle.com to download oracle10g linux client name 10201_client_linux32.zip. Size: 467 M. Register and download it. 2. because I am using Remote Installation, and I do not use remote operations like

Fault Handling when the web server cannot connect to the Oracle database at one time This morning, the maintenance staff called to say that a mobile web server could not connect to the database. The web server reported a lot of jdbc errors and

1. Install unixODBC Download the installation package.UnixODBC-2.2.11-1.RHEL4.1.i386.rpmUnixODBC-devel-2.2.11-1.RHEL4.1.i386.rpmUnixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm InstallRpm-Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpmRpm-Uvh

When learning Oracle date functions, there are several examples in the Tutorial: Months_between ('01-sep-95 ', '11-jan-94 ') Result: 19.6774194 Add_months adds the expected month to the specified month. For example: Add_months ('11-jan-94 ',

I am not quite familiar with the related RAC structure. Now let's see what it means. Oracle clusterware has the following main components:CSS: Cluster Synchronization ServiceIt mainly manages the situation between nodes in the entire cluster,

If Oracle uses a file system, the file system must have the write through cache capability to ensure that data consistency is not affected by sudden downtime. Write through cache is only one level to ensure the consistency between cache and memory,

Select f. TABLESPACE_NAME,(T. TOTAL_SPACE-F. FREE_SPACE) "USED (MB )",F. FREE_SPACE "FREE (MB )",T. TOTAL_SPACE "TOTAL (MB )",(ROUND (F. FREE_SPACE/T. TOTAL_SPACE) * 100) | '%' PER_FREEFROM (SELECT TABLESPACE_NAME,ROUND (SUM (BLOCKS *(Select value/1,

Recently, an Oracle 10 Gb database was installed. When dbca created the database, the character set was not selected or the database was incorrectly selected. After the data was imported, all Chinese characters were garbled (funny, chinese garbled

What should I do if the exported file is too large to be stored in the file system? An effective solution on Unix is to create a named pipe. Export data files through pipelines Root@www.bkjia.com ~ $ Mknod exppipe p Root@www.bkjia.com ~ $ Exp

I often encounter "Why is my query garbled ?" Or "Why do Chinese characters become garbled after I import it ?" If you want to thoroughly understand the cause, you need to study the Oracle Character Set and the conversion relationship between them,

When I was working, I was very happy to build a RAC learning environment by using three broken PC machines, I have also created a learning environment for myself. I'm so happy! An error is reported on a host, such: I thought it was over. So I

When you use Experimenter in Weka to connect to a Mysql database, the default link is: Jdbc: idb = experiments. GP Change it: Jdbc: mysql: // 222.35.250.58: 3306/labin_ultimate_original (Mysql host and database names need to be set according to the

There is still a rollback segment in Oracle10g named system, which was created by Oracle when the database was created, and the rollback segment exists in the SYSTEM tablespace. It is used to roll back system events. That is to say, the modified