Database Administrator

SQL Server 2016: Row-level security A common criticism for SQL Server is that its security model can only recognize tables and columns. If you want to apply security rules to behavior units, you need to use stored procedures or table value functions

Configure ASM process on Red Hat Linux 6.5 ASM (Automatic Storage Management) is a software Storage solution officially recommended by Oracle. Since the 10g version was officially launched, the position of ASM in the software architecture is

GoldenGate Extract process hang solution example The normal extract process suddenly hang. At first, I suspected that the Archive was not found. However, after careful check, all the archives required by extract are still there, and no error is

ORA-28001: the password has expired. (password expired) ORA-28001: the password has expired. (password expired), a new feature of Oracle 11g, default user password only valid for 180 days. 1. plsql logs in as an administrator, and system/admin

Transaction design strategies for MongoDB, Cassandra, and HBase NoSQL databases (such as MongoDB, Cassandra, Hbase, DynamoDB, and Riak) make application development easier. They provide quite flexible data models and rich data types, and are easier

Batch update names separated by commas (,) (multiple IDs separated by commas (,) in a department are converted into names separated by commas (,) (mysql) and comma (,) mysqlUpdate dept B, (select group_concat (t. deptId), group_concat (d. deptName

Tomcat _ configure jdbc (small example) and tomcat configure jdbc  Original works, from "Deep Blue blog" blog, deep blue blog: http://blog.csdn.net/huangyanlong/article/details/47043975   Example of jdbc configuration under tomcat When you use

PL/SQL connection to the Oracle database -- no connection is required, ploracleZookeeper The 64-bit Oracle database installed on Win 7 is then installed with a 32-bit Oracle client. When you connect to Oracle using PLSQL, only the username, password,

Oracle442 application scenarios ---------- basic application scenarios and application scenarios   /// // Basic knowledge //////////////////   Application Scenario 178: the simplest select statement SELECT * FROM Employees; Use Case 179: Specify the

MySQL Optimization-permission management and mysql permission management Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46763767 In the mysql database, the mysql_install_db script initialization permission

PL/SQL smart call stack analysis, plsql PL/SQL smart call stack AnalysisOriginal article: http://www.oracle.com/technetwork/issue-archive/2014/14-jan/o14plsql-2045346.html The three DBMS_UTILITY functions(DBMS_UTILITY.FORMAT_CALL_STACK,

Reconstruction of the charging system for vb.net Data Center-Summary (iii) software engineering document 2. vb.net Charging System In the previous article, I wrote the requirement specification to add an IPO diagram. What is an IPO diagram? I have

ERROR 1160 (08S01): Got an error writing communication packets, 116008s01 The application encounters an error message: MySQLNonTransientConnectionException: Got an error writing communication packets. It is related to packet and has never

Principle of SHA-1 algorithm and programming implementation in Redis source code, redissha-1Guide The SHA-1 algorithm is short for the first generation of "Security Hash algorithm", and is essentially a Hash algorithm. SHA standards are mainly used

PostgreSQL tutorial (II): Schema description, postgresqlschema A database contains one or more naming modes. The schema also contains tables. The schema also contains other named objects, including data types, functions, and operators. The same

Win64-bit Oracle_11gR2 database installation + PL \ SQL Developer, win64oracle_11gr2 Download required software: Oracle_11gR2 and instantclient-basic-nt-11.2.0.3.0 and plsqldev9 Download link: http://pan.baidu.com/s/1gdH53IN Step 1: Install Oracle_11

PL/SQL _ Developer import official documents, pldeveloper Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for

OGG-03510 troubleshooting, ogg-03510 Processing OGG migration, the target end has been upgraded to 12C, so with the 12 version of OGG, the parameter is still using the previous 11g, but when starting the application process prompts OGG-03510 error,

[Translated from mos] The Alter Database Add Supplemental Log Data command is suspended, mossupplemental Alter Database Add Supplemental Log Data command suspendedSource:Alter Database Add Supplemental Log Data Hangs (Document ID

OGG extract process checkpoint time back to 00:00:00 troubleshooting, checkpoint1. Fault The Extract process (SEXTR01) status is running, but the Lag at Chkpt has reached more than five hours, and the time has been increasing. No new logs are