Database Administrator

[Translated from mos] How to check whether Oracle Advanced Security Option is installed ?, Mosoracle How can I check whether Oracle Advanced Security Option is installed? Source:How To Check if Oracle Advanced Security Option is Installed?

[Translated from mos] When sec_case_sensitive_logon = true, how can I enable a password with a mix of upper and lower cases ?, Sensitive When sec_case_sensitive_logon = true, how can I enable a password with a mix of upper and lower

Oracle (5) --> advanced subquery (2), oracle -- Query1. Related subqueriesRelated subqueries are executed in the order of one row and one row. each row of the primary query performs a subquery.For example, if the number of employees with the same id

In the Oracle11g database, dba_users has the password_versions column while oracle11gdba_users   Reference:11g R1 New Feature: Case Sensitive Passwords and Strong User Authentication (Document ID 429465.1)   The view DBA_USERS has new column

Create external table in oracle and create in oracle Oracle db allows you to query External tables in read-only mode. External tables can be stored on any storage device that can be read by oracle databases. The content of external tables is not

MySQL view log, mysql Log 1. View MySQL logs mysql> show global variables like '%log%';+-----------------------------------------+-------------------------+| Variable_name | Value |+-----------------------

Oracle redo management, oracleredo1. Category Several types of log files in Oracle Redo log files-> online Redo log Archive log files-> Archive log Alert log files-> alarm log Trace files-> Trace logs User_dump_dest-> User tracking log

Mysql storage engine and Selection Method0x00 common storage engines for Mysql Databases Mysql database is an open-source database that supports multiple storage engines, such as MyISAM, InnoDB, and Memory.MyISAM storage engine MyISAM is the default

Combined Query of Data room charging systems-inheritance of forms and Combined Query of charging systems Do you still remember the combined query function when I first performed the data center? At that time, I started to judge one by one. At the

OLAP engine-Kylin introduction, olap engine kylinKylin is an OLAP system developed by ebay. Unlike Mondrian, Kylin is a MOLAP system mainly used to support data analysis services in the big data ecosystem, it caches User-Defined multi-dimensional

Restart uard method and restart uard Method-- DG restart procedure-- 1. Shut down the master databaseShutdown immediate;-- 2. Disable the standby DatabaseAlter database recover managed standby database cancel;Shutdown immediate;-- No listener. If

[Translated from mos] visit the well-known ODBC driver list of Oracle Database, mosoracle Source:List of Well Known ODBC Drivers For Accessing An Oracle Database (Document ID 1932774.1) Applicable:Oracle ODBC Driver-Version 8.0.5.1 and

Use ORACLE online redefinition to change a common table to a partitioned table and an oracle partitioned table1. First create a test table and insert the test data: create table myPartition(id number,code varchar2(5),identifier varchar2(20));insert

Multidimensional modeling (4): Multidimensional Modeling Enable SqlServer and AnalysisService Open Visual Studio and createAnalysisServiceMulti-dimensional data mining projectAnd solutions. Create a data source:

The database generates scripts with frameworks and data, and restores the database. The framework scriptWe certainly need to maintain or reconstruct the project. At this time, we need to face other people's systems. If our predecessor was a very

Databases in SQL Server are transplanted to each other ., Port sqlserver When sorting out BS template materials a few days ago, Shi Ge asked us to publish several websites on the server. I was responsible for the background release of Yonghe cash

Steps and notes for SQL * Net trace on the Oracle client, oracletrace Steps and notes for SQL * Net trace on the Oracle clientReferences:How to Perform Client-Side Tracing of Programmatic Interfaces on Windows Platforms (Document ID 216912.1) My

MySQL foreign key insertion and MySQL key insertionAdd a foreign key to the added data table:Syntax: alter table name add constraint FK_ID foreign key (your foreign key field name) REFERENCES External table name (corresponding table's primary key

JDBC calls stored function stored procedures and jdbc stored proceduresJDBC call Stored ProcedureSteps:1: Use the prepareCall () method of the Connection object to create an instance of the CallableStatement object,When using the prepareCall ()

JPQL and jpql statements5. JPQL JPQL (JavaPersistence Query Language) is an object-based Query. The queried content is an object or an object attribute.5.1. query objects SELECT c FROM Customer c JPQL statements are similar to SQL statements, but