Database Administrator

Security Products Advantages Disadvantages Oracle Database Vault 1. Privileged users such as DBAs can be protected2. Internal Implementation of Oracle, no need to change the application, and flexible installation3. Good control

After installing Oracle in the notebook, you can use the OEM console normally. However, after logging out, log on again or restart the system, or change the network environment of the notebook, problems may occur. The solutions to these problems

1.Dynamically create auto-increment Sequences: DeclareV_ SQL varchar2 (1000 );V_num number (20): = 1;BeginV_ SQL: = 'create sequence sqbs ';Select max (sqb. id) + 1 into v_num from sqb;If v_num is null then v_num: = 1;V_ SQL: = v_ SQL | 'maxvalue 999

Hierarchical Query -- Auto-join: treats the same table as a different table using the table alias, and then uses the equivalent and non-equivalent join. Self-connectionSQL> selecte. ename | 'The Boss is '| d. ename 2 from emp e, emp d 3 where e. mgr

1) STARTUPStartup open: the default parameter of STARTUP is OPEN. OPEN the database and allow access to the database. All files described in the control file of the current instance have been opened.Startup mount: MOUNT the database. only DBA is

Oracle analysis function over and Window Function I. analysis function overOracle provides analysis functions starting from 8.1.6. analysis functions are used to calculate a group-based aggregate value. What is different from aggregation

This problem is a headache. If you find that the previous solution is not working, you can find a new solution from the Internet.: InUbuntu 10.04 (Or a little earlier)Start, UBuntuUseUpstartReplace the traditional/sbin/initRun the service and set

Create and manage Oracle Partition tables I. Create a partition table Partition tables are divided into four types: 1. Range Partition Table 2. List Partition Table 3. Hash Partition Table 4. Combined Partition Table The following table creates four

SQL> select name, value $ from props $ where name like '% NLS % '; Name value $------------------------------------------------------------NLS_LANGUAGE AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $NLS_ISO_CURRENCY AMERICANLS_NUMERIC_CHARACTERS

Sqoop is a tool used to transfer data between Hadoop and relational databases. It can import data from a relational database (such as MySQL, Oracle, and S) to HDFS of Hadoop, you can also import HDFS data to a relational database. Sqoop User Guide

Because of the different versions of DB2, The Script File Syntax is also different. Even redundant spaces may cause runtime errors. In recent experiments, DB2 v9.5 and v9.7 encountered many strange problems when running the SQL files created by

This morning, the alert. log of erp db suddenly ran out of N multi-ORA-1693 error. ARC1: Completed archiving log 1 thread 1 sequence 343118 Fri Sep 9 09:52:55 2011 ORA-1693: max # extents 505 reached in lobsegment APPLSYS. SYS_LOB0001182584C00040

When I arrived at the company, I received a friend's message saying that one node of RAC had crashed. Because he re-built an index at last night and ran for more than two hours before it was over, then he manually canceled it. At, one of the nodes

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

This often happens in Oracle, where ORA-02291: violates the full constraints (*)-parent keywords not found The following describes the possible causes: Scenario: A field in Table A is A foreign key associated with A field in Table B. This

A bug occurred in the test. I checked the logs printed by the application and found that the data of the previous day was correct, and the data of the next day was incorrect, the only possibility is that someone directly updates the database during

For more information about how to modify the database name in Oracle, see step by step. My friend asked me how to change the database name over the past two days, so I made a test and recorded it to illustrate the problem.How to modify the Database

I. handling process 1. Find the locked database table and related sid, serial # And spid: Select object_name as object name, s. sid, s. serial #, p. spid as system process numberFrom v $ locked_object l, dba_objects o, v $ session s, v $ process

Sun Microsystems sun4u Sun Fire E6900 Oracle 11.1.0.7.0 ASM Database The system time is modified, causing the Oracle 11g database instance to go down. Both the ASM and ORACLE instances are unmounted. Tue Jul 14 20:11:00 1970Errors in

Paging Query format: SELECT * FROM(Select a. *, ROWNUM RNFROM (SELECT * FROM TABLE_NAME)Where rownum )Where rn> = 21 SELECT * FROM TABLE_NAME indicates the original query statement that does not flip pages. ROWNUM = 21 control the range of each