The Linux server uses the system crontab to regularly execute Backup files and save the backup results by date to achieve the backup purpose. 1. Create the path to save the backup file my
The Linux server uses the system crontab to regularly execute
The Table Partitioning function of Oracle brings great benefits to various applications by improving manageability, performance, and availability. In general, partitions can make certain queries and maintenance operations
The Table Partitioning
Df-h to view disk space, found that devsda11app100 % file system capacity used available % mount point devsda99.5 g
Df-h: view the disk space and find that/dev/sda11/app 100% file system capacity has been available in use % mount point/dev/sda9 9.5G
A colleague deleted an important Oracle table and failed to run the project! Fortunately, a DBA friend of mine suggested that oracle's flashbacktable can restore data
A colleague deleted an important Oracle table and failed to run the project!
This is because the database of the other party is Oracle during project creation, and the identity () cannot be the same as that of MSSQL during auto-increment. Creates
This is because the database of the other party is Oracle during project
* Environment: windowsXP + Oracle10gR2 * AutoTRACE is a simple and convenient tool for analyzing SQL Execution plans. * AUTOTRACE is an SQL * Plus
* Environment: windowsXP + Oracle10gR2 * AutoTRACE is a simple and convenient tool for analyzing SQL
PLSQL is a block structure language. The block consists of the definition part, execution part, and Exception Handling part. Syntax structure: declare ** definition: used to define
PL/SQL is a block structure language. The block consists of the
You can achieve this by executing selectNUM_ROWS, table_namefromuser_tableswhereNUM_ROWSgt; 0. However: Sometimes the data is inaccurate, because
By executing select NUM_ROWS, table_name from user_tables where NUM_ROWSgt; 0, you can achieve the
SQLgt; createtablespacetestdatafile
SQLgt; create tablespace test datafile
SQL> create tablespace test datafile 'y: \ test. dbf' size 20 M;
The name of the actually created tablespace is TEST.
Execute the following three commands to delete
Software environment: Ubuntu10.10, Java1.6u22 hardware configuration: Core dual-core 7200CPU, 2 GB memory, 4 GB swap partition, GB hard disk 1. Before installation preparation, it is best to first
Software environment: Ubuntu 10.10, Java1.6u22
Oracle10g simplifies CLOB-type operations to a considerable extent. Generally (no more than 32,765 bytes), you can use the new version of ojdbc14.jar driver in Java code
Oracle 10 Gb simplifies CLOB operations to a considerable extent. Generally (no
The following problems are encountered in the project. A url is sent from the page. Search for records based on the url. The key is that the url address contains special characters. Such as single quotes
The following problems are encountered in
Bulkcollect can be used to load the query results to collections at a time, instead of processing the query results one by one Using CURSOR. In selectinto, fetchinto,
Bulk collect can be used to load the query results to collections at a time,
I. Preparation of the development environment 1. First install Linux. Here we use Ubuntu10.102 and install the MySQL software package. Here, the 10.10 System Warehouse contains MySQL.
I. Preparation of the development environment 1. First install
A database trigger is a storage subroutine associated with a data table, view, or event in a database. For example, we can make the Oracle database INSERT, UPDATE, or DE
A database trigger is a storage subroutine associated with a data table, view,
LinuxOracle9i maintenance personnel reflect that the database cannot be connected. The phenomenon is: tnsping can be connected, but sqlplus cannot be connected. If no error is reported, it is always on there.
Linux Oracle 9i maintenance personnel
I recently re-installed the Ubuntu10.10 system and needed to re-compile and install Mysql. The source code version is 5.1.34. I don't know what the 10.10 system has changed.
I recently re-installed the Ubuntu 10.10 system and needed to re-compile
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service