Database Administrator

Create table test(Id int unsigned not null PrimaRY KEY AUTO_INCREMENT,Username VARCHAR (15) NOT NULL)AUTO_INCREMENT = 100; In database applications, we often use unique numbers to identify records. In MySQL, The AUTO_INCREMENT attribute of the data

The Oracle stored procedure consists of three parts: Process Declaration, execution process, and stored procedure exception. Oracle stored procedures can contain parameter stored procedures and parameter stored procedures. I. No parameter program

Compile the M LibraryThe CUSTOM database is an OracleForms Developer PL/SQL database that allows you to use Oracle Forms Developer to integrate yourCodeTo OracleApplicationProgramInstead of changing the Oracle Application code.When to use the M

1. Configure listenerA. $ Oracle_HOME/network/admin/listener. oraLISTENER1 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = rac1-vip.oracle.com) (PORT = 1521) (IP = FIRST ))(ADDRESS = (PROTOCOL = TCP) (HOST = rac1.oracle.com) (PORT = 1521) (IP =

Without AUTHID CURRENT_USER, The definer permission (definer rights) is executed as the definer identity. With AUTHID CURRENT_USER, the caller permission (invoker rights) is executed as the caller identity. Example: 1. Create two users: xxpo and

Restore data files in the system tablespaceThe system tablespace stores the data dictionary information. When the database is in the open state and the data file corresponding to the system tablespace fails, the database will automatically shut down

In exp and imp, there is no syntax for exporting only stored procedures. If a user's data is exported, all objects (tables, views, indexes, sequences, functions, stored procedures, triggers, etc.) of the user will be exported ). If only all stored

When defining an Oracle scheduled task, the interval is defined as the end time of a task to the start time of another task. Example: select (TRUNC (sysdate, 'mi') + 1/(24*60), (sysdate + 1/(24*60) from dual Error: sysdate + 1/(24*60) is used as

Shopxx adopts spring + jpa hibernate without hbm files, and adopts hbm2dllauto default update Update means that when hibernate is loaded for the first time, the table structure will be automatically created based on the model class (the premise is

According to my recent study on Oracle databases, I have learned more about Oracle and hope to help some new Oracle users. Oracle provides several simple data types, Unlike SQL server. Common Oracle data types include char, varchar2, clob, number,

Note that in Linux bash, this is certainly not supported in Windows .. However, you can try to write a bat batch file to achieve the same effect! To run the mysql file,If you have logged on to mysql, you can directly run: source filename. SQL In the

How to enable and view the Oracle EBS diagnostic Log (Dialogic Log) O Set profile options at USER level: FND: Debug Log Enabled: Yes FND: Debug Log Level: Statement FND: Log Module: % O Run: Select max (log_sequence) from

1.Queries the current tablespace of a database. Select tablespace_name, file_name, sum (bytes)/1024/1024 table_size from dba_data_files group by tablespace_name, file_name;   2.Create a tablespace Create tablespace data01 DATAFILE

This is a simple function, that is, using auto-increment columns and triggers. 1. First create a simple table users -- Create table users Create TableSystem. users ( Userid varchar2 (20)Primary Key, UsernameVarchar(20)Not Null, Userpassword

Linux: RedHat Enterprise Linux 5.6 Oracle version: 10 GB 1. Modify the/etc/oratab File Set orcl:/home/oracle/product/10.2.0/db_1: N Changed to orcl:/home/oracle/product/10.2.0/db_1: Y. 2. Modify the $ ORACLE_HOME/bin/dbstart file under the oracle

I. Description A netizen asked me to store a query result set to the temporary table. If I estimated the size of the temporary table, I wanted to calculate it through the statistical block. Later I thought that this method was not very operational.

1. Start the NAS + SERVER (fully started) Check whether the NFS service starts the service nfs status. 2. Start RAC1 and RAC2 (it is best to start RAC1 separately and start RAC2 after it is fully started) Check whether the mount is correct

1. The following describes the Oracle stored procedure! 2. Focus on the preparation, debugging, and application of stored procedures, rather than the introduction of too many syntaxes! 3. As long as you know the SQL statement, you can continue

The test is successful between two Oracle databases. The following is a summary: Requirements:There are two Oracle database servers A and B (A and B can be on the same Intranet or two independent machines on the Internet ). Both A and B have

The task is very simple. Copy the virtual machines in Beijing to a machine on the site, let them run, and simulate the real environment for users to perform exercises. In this case, if the production database fails, O & M personnel can switch