Database Administrator

Q: SYBASEStored ProcedureWhy is this sentence not executed? Select @ nSerialNo = serialno from schedule where phonenum = @ strPhoneNum and type = @ nTypeIf @ rowcount = 0Begin...EndElseBegin...EndThe aboveSelectThe result is an empty record set.

Due to work needs, I set Oracle Intermedia on HP UX And sortium to implement full-text search. It is currently in use. There are many problems and experiences in the setup process. This article is based on Oracle 8.1.6 and 8.1.7, and cannot be

Differences: 1. the length of CHAR is fixed, while the length of VARCHAR2 can be changed. For example, the storage string "abc", for CHAR (20 ), it indicates that the characters you store will occupy 20 bytes (including 17 null characters), while

ORA-01650: unable to extend rollback segmentname by NUM intablespace NAMECause: the preceding ORACLE error is caused by insufficient tablespace In the rollback segment, which is also the most common ORACLE error message of the ORACLE Data

Some netizens on the Internet said that svrmgr30 (svrmgrl in unix) was canceled at oracle9i and replaced with sqlplus. I am not very clear about this problem, however, svrmgr * cannot be found in window2000 *.. Let's talk about how to start it. 1.

Basic concepts: 1. Multi-dimensional dataset: a multi-dimensional dataset is the main object in Online Analytical Processing (OLAP) and a technology that allows quick access to data in a data warehouse. A multi-dimensional dataset is a collection

Define data tables Assume that a computer manufacturer stores the product information of the whole machine and accessories in its database. The table used to save the product information of the entire machine is called pc; the table used to save

The ORACLE Database Log File $ ORACLE_BASE/admin/orasid/bdump/alert_orasid.log records the conversion of logs,Database startup and shutdown, database structure change, rollback segment modification, deadlock, internal errors, and other

Iii. Remote Backup We know that FTP commands are usually used to transmit data between two hosts, but they are generally implemented through interaction, that is, you need to manually enter the IP address, user name, and password of the target host.

4. Start the backup process Cron is a permanent process started and executed by/etc/rc. local. Cron check/var/spool/cron/crontabs /? Lined up with ke Jia machinery Nai ?, Find the task to be executed and the time when the task is executed. Each row

Oracle databases are favored by more and more enterprises for their high reliability, security, and compatibility. Many database administrators are concerned about how to maintain excellent performance of Oracle databases. Based on my experience, we

There are many sources that affect ORACLE performance, including: Database hardware configuration: CPU, memory, and network conditions 1. CPU: In any machine, the CPU's data processing capability is often a sign of computer performance measurement.

Based on practical experience, I will talk about the automatic backup of Oracle databases in UNIX environments. We plan to allow the database to perform export backup at a.m., copy the backup file to the tape at a.m., and copy the backup file to

1 Introduction ORACLEA database is a large-scale relational database that can be stored for storage.TBSo how to ensure the security of such data is particularly important.1991Use in yearsORACLEDatabase, we have developed a complete setORACLEDatabase

Step 1: Download ids 9.4 for linux Ftp://ftp.youngcow.net/Special/Database/DatabaseServer/Informix/InformixDynamicServerVersion9.4/IIUG-IDS-9.4-linux.zip This thread has limits on http: // 202.96.110.20./ informix/ids9.4/IIUG-IDS-9.4-linux.zipCsdk

Aggregate functions Avg, calculate the average valueCount, count the number of recordsMax, calculate the maximum valueMin, minimum valueRange: calculates the difference between the maximum and minimum values of the selected row.Stdev: calculates the

The Informix dynamic server adopts a multi-clue architecture, which means that a process can complete multiple tasks at the same time using multiple clues of its own, therefore, the entire system requires only a small number of processes to complete

I have some experiences with data migration and hope to share with you. 1. Import or export data using the DTS designer The DTS designer is powerful and supports multi-task operations. It is also a visual interface and easy to operate. However,

At present, the competition in the retail market is becoming increasingly fierce, and it is increasingly important for systems that can quickly reflect market changes. In an era when services become crucial, mobile and remote systems play an

The products developed by the company basically use ORACLE databases. In addition, the data stored and used in the business system is large, and many users use the business system. When the system is busy, about one thousand user colleagues visit