Database Administrator

Oracle Study -- RAW Device application in Oracle 1. What is a raw device) A bare device is a raw partition or raw logical volume that has not been created for a file system. An application accesses it directly through a character device driver. How

Restore A non-System File deleted by Oracle in archive ModeAs we all know, our core production databases usually run in archive mode, not to mention configuring the DG Environment. Enabling archiving and ensuring that all archives are not lost can

Insert if data does not exist in Oracle, insert or update if data exists, and oracleinsert The idea is to write a function that first queries data based on conditions. If data is queried, it is updated. If no data is queried, It is inserted: Create

Oracle to_date error caused by different language Environments I wrote a stored procedure and used a function in it. The function contains a to_date (dateFrom, 'yyyy/mm/dd'). After running the function, I found that the data was inserted incorrectly,

Common orcle statements and orcle statements -- 1. create temporary tablespace AUTOMONITORV5_temptempfile 'd: \ ORACLE \ KARL \ ORADATA \ ORCL \ automonitorv5_temp.dbf' size 50 m autoextend on next 50 m maxsize 10240 m extent management local; -- 2.

Add and read comments and ORACLE comments to tables and columns in oracle Add and read comments to tables and columns in ORACLE1. Add a comment to the table: SQL> comment on table name is 'table comment "; 2. Add a comment to the column: SQL>

Use Oracle DBLink to access objects between databases. Oracle comes with the DBLink function. It is used to logically think of multiple oracle databases as one database, that is, one database can operate on objects in another database, for example,

Oracle export and import under the DOS command, oracledos command Export The command running in DOS can also be run with parameters in the SQL/PLUS EnvironmentSimple ExampleSingle Table backup (the structure of the prerequisite database is the

ORACLE compilation failure object, oracle compilation failureInvalid ORACLE compilation objectsThere are many reasons for database object invalidation:1: when the structure of the referenced object is changed, the dependent object will be changed to

One-to-one relationship in Hibernate association relationship ing, one-to-one relationship in hibernate There is a typical one-to-one relationship between people and ID cards. One of the two ways to implement one-to-one association ing is based on

Combined Query BUG of the data room charging system and combined query of the Charging SystemDisclaimer: the following content only applies to queries on-board records (combined queries) of students, and queries on-board records only for operator

The crontab command automatically backs up the mysql database of the remote server, crontabmysql Today, I used the information collected on the Internet and my own practices to organize and use the crontab command to back up a database on a remote

DB2 uses the Hibernate Interceptor to implement dirty read (with ur) and db2hibernate Work needs: Recently, the development of the system to adapt to the underlying database to add support for DB2, although the use of DB2, but performance

Some Useful GoldenGate Commands, goldenw.commands 1. History Use History to view previously executed commands GGSCI (ogg1) 5> history GGSCI Command History 1: infoa2: inf3: info all4: show all5: history 2 ,! Use! You can run the last command

Practice: Create shell scripts and oracleshell scripts for oracle users #! /Bin/bash # ocpyang@126.com # create userif [$ #-ne 4]; then echo-e "\ e [1; 32 m ************************************** **************************************** * ** \ e [0

The 15th tip of DB Query Analyzer,   The 15th tip of DB Query Analyzer ----SQL Execute Schedule function is realized in 6.01 Ma Genfeng (Guangdong Unitoll Services ininitialized ated, Guangzhou 510300)   AbstractThe latest version of DB Query

Group by ALL, groupbyall Group by ALL. The difference between "ALL" and "no" is that after "ALL" is added, ALL groups and result sets are included, and even those groups and result sets whose rows do not meet the search conditions specified by the

Solve the Problem of 32-bit plsql client connection to a database without 64-bit Oracle11g, plsqloracle11gSince I installed 64-bit Oracle, plsql cannot be connected because it is 32-bit. There is a way to connect to the Internet; Download

Practice: oracle deletes shell scripts for tablespace, oracleshell #! /Bin/bash# Ocpyang@126.com# Drop tablespace If [$ #-ne 1]; thenEcho "Usage: $0 TABLESPACE_NAME"Exit 1Fi # Configure oracle env: about oracle envs, username and password ORACLE_SID

Trigger and trigger instance Although I have been familiar with triggers, I am not very thorough. Sometimes I still don't quite understand them. Now I want to add this blank space. The trigger content is basically as follows: Note: When a trigger