Database Administrator

The primary key and index of data are usually required. Especially when a table has a large amount of data, the index and primary key are even more necessary, which can provide data query efficiency; I. Create a primary key constraint while creating

If your stored procedure is named PROC_RAIN_JM Write another Stored Procedure named PROC_JOB_RAIN_JM. Content: Create Or Replace Procedure PROC_JOB_RAIN_JM   Is   li_jobno Number;   Begin  

When you install or use cx_Oracle, you need to use the connector El library, such as libclntsh. so.10.1. Otherwise, there will be various error messages. After installing the Oracle Instant Client, you can get this link library to Avoid installing a

You can view the current configuration through dba_hist_wr_control. The current awr is a data snapshot every hour, and the retention time is 7 days. SYS @ peng SQL> select * from dba_hist_wr_control;     DBID SNAP_INTERVAL             RETENTION      

(1) Update the Ubuntu 10.04 LTS system to the latest version and install the following package: Sudo apt-get install alien binutils gcc ia32-libs lesstif2 lesstif2-dev lib32stdc + + 6 lib32z1 libaio1 libc6 libc6-dev libc6-dev-i386 libc6-i386

After installing a series of software development programs under Ubuntu 10.10 in the early stage, we have installed the final database MySQL 5.1.56. Basically, the environment for building the LNMJ or LAMJ Architecture Based on Java Web applications

Xwindow must be enabled for Oracle 10g installation in Linux. The installation interface is very ugly!The patch and Installer are generally large and daunting for the first time. Record the startup process: Su oracleExport ORACLE_BASE

// Construct a table that is the same as a known table. The common methods are as follows:// Create table t_name// Select col_name from t_exists// Where 1 = 0;// This construction method reduces our workload and brings great convenience;// But do

Create or replace procedure proc_query_prior_departmentIs Cursor department_list_nosub isSelect dep. id, dep. name, dep. parent from department dep where org_id = 7;Union_mc varchar2 (200 ); Begin Delete from ma_department_role;Commit;For varDep in

Configuration in Oracle 10 GBUse RMAN> show all;The following shows the RMAN configuration parameters: Configure retention policy to redundancy 1; # defaultConfigure backup optimization off; # defaultConfigure default device type to disk; #

1. USERENV (OPTION)Returns the current session information.OPTION = 'isdba ': TRUE if the current role is a DBA; otherwise, FALSE.OPTION = 'language' returns the character set of the database.OPTION = 'sessionid' is the current session

You may accidentally see a hidden mysql file named. mysql_history in the/root directory, because you have never noticed it before. Open it and see what it is. This file records all the operations on connecting to mysql, including creating a user and

Since the Oracle course design involves image processing, it took a long time to test and read a lot of information, and finally solved the problem. Here we will share with you: 1. Save images to the database In oracle, the image storage type is

(1) There are a lot of help information prompts in Oracle. How can we query such help prompts? You can use the following statement to query Select * from system. help; (2) There are four files under $ ORACLE_HOME/sqlplus/admin/help: Helpbld. SQL,

In the development of the CS structure system, the package variables in Oracle are often used as global variables of the session. When the operator logs on, the package variables are assigned a value, which can always be taken at any time after this

(1) Check the AIX packages required by Oracle10g according to the installation instructions: Bos. adt. base Bos. adt. lib Bos. adt. libm Bos. perf. libperfstat Bos. perf. perfstat Bos. perf. proctools XlC. aix50.rte: 7.0.0.4 or later XlC. rte: 7.0.0.

Install Oracle 10gR2 RAC on aix. If raw is used for storage, hacmp (PowerHA) is required for shared storage.For 10gR2, Oracle only supports hacmp 5.3 or later versions, and has different requirements for each specific version.1. hacmp 5.3.The

1. Change the password Because no password is used by default, you can change the password for security first: Stop mysql first /Etc/init. d/mysql stop -- Start in Safe Mode[Root @ mysql var] # mysqld_safe -- skip-grant-tables &[1] 10912[Root @

Create type char_table is table of varchar2 (4000); -- create a custom type script Create or replace function split_string (pi_str in varchar2, pi_separator in varchar2) -- create a functionReturn char_tableIsV_char_table char_table;-- Create type

Occasionally, a small BUG occurs when dbms_metadata.get_ddl () is used to capture the SQL statement for creating a TABLE with LOB.The version is 10204.When undo_management is AUTO, LOB storage uses the retention management method by default, but the