Database Administrator

In Windows, sqlplus is completely normal, but in Linux, there is a problem with sqlplus Chinese display, always displaying "?", How can this problem be solved? The solution is as follows: In fact, it is easy to set exit sqlplus and set the

Introduction Oracle Database 10 Gb provides five new flash back functions: Flash back version query, flash back transaction query, flash back deletion, flash back table and flash back database. Oracle Database 11gR1 provides an interesting new flash

The CASE expression is added to SQL in Oracle8i, and Oracle9i extends it so that the CASE expression and CASE statement can be used in PL/SQL. CASE expression for value matchingThe CASE expression is more flexible than the DECODE function. In its

Today, we can see the following problems in the daily response of data centers A and B: Renewal point 1 day: Tue Jul 31 03:02:50 2012 Errors in file/soft/Oracle/diag/rdbms/a1qzdb/a1qzdb1/trace/a1qzdb1_ora_5374100.trc: ORA-00245: control file backup

I saw an article in the forum today asking why the session id of the SQL Server system ranges from 1 to 50. I have read this article before, these sessions are used by SQL Server to run system activities such as (lazy writer, ghost record cleanup,

1. Error 1: the RBS and TEMP tablespaces cannot be created. IMP-00017: following statement failed with Oracle error 1119:"Create tablespace" RBS "DATAFILE 'd: \ ORACLE \ ORADATA \ ORCL \ RBS01.DBF 'size 5""45259520 autoextend on next 5242880 MAXSIZE

Developers have a requirement to move all objects in a schema to another shema. After thinking about it, simply change the schema name? In this way, you do not need to move the data. You are prepared to directly change the data using DDL statements:

Let's take a look at what powerful effects Oracle's auditing functions (including FGA fine-grained auditing) can bring to us.I will use this article to show you the audit functions of Oracle. Follow me.1. To use audit, you must first activate the

When Rman Recovers Data, it can restore the control file and spfile with the help of catalog. Today, we have specially configured the catalog Database: 1> Create a tablespace in the catalog Database for catalog Create tablespace rman_ts datafile '/u0

System Environment CPU info:Number of CPUs = 4Clock speed = 1595 MHzBus speed = 532 MT/sCPUID registersVendor information = "GenuineIntel"Processor serial number = 0x0000000000000000Processor version info = 0x0000000020000704Architecture revision:

Hostname IP address application serviceDB1 www.bkjia.com MGMDB2 192.168.6.160 NDBD, MYSQLDDB3 192.168.6.188 NDBD2, MYSQLDDB4 192.168.6.191 MYSQLD 1. DB1 management node MGM . /Configure -- prefix =/usr/local/mysql/-- with-charset = utf8 --

I was planning to conduct an in-depth study on Oracle Data dictionary this evening, but when I was about to finish the research, I received a message from a friend in Beijing saying that their database generation had a problem, let me take a look at

I. Overview of bacula 1. bacula ComponentsBacula is known as the best backup and restoration software in open-source software. It provides a backup solution for enterprise-level clients/servers, allowing you to manage file backup, recovery, and

On the Internet, I often ask what is the maximum length of Oracle varchar2? In fact, this name is not accurate. varchar2 is used in both oracle SQL and pl/SQL. oracle points out in the SQL reference manual and pl/SQL reference manual: the maximum

1. RMAN login and exit command: Method 1: $ rman nocatalog directly enters rman to back up data in a non-catalog mode. Do not use nocatalog.Rman> connect target/connect to the target database requires configuring the Oracle operating system login

Today, the partner of Fuzhou University said that our database login password has expired. They cannot log on to the platform now. Hope to be resolved. "ORA-28002: the password will expire in 7 days". Cause: In oracle11g, "default profile" is set by

Oracle constraints on database integrity: Three methods to maintain data integrity: ORACLE integrity constraints, database triggers, and application code. ORACLE integrity constraints should be used whenever possible, with high reliability and

1. Use EXPLAIN:PostgreSQL generates a query plan for each query, because selecting the correct query path has a critical impact on performance. PostgreSQL itself contains a scheduler for optimal planning. We can use the EXPLAIN command to view the

Oracle Server entry and oracle management routineI. Common oracle database management toolsOracle Universal Installer (OUI): used to install, upgrade, or delete Software ComponentsOracle Database Configuration Assistant (DBCA): a graphical user

How to generate WIP debug log files in ONLINE cases?For 11.5.10 and above, the WIP debug log files will be created if1. FND: Debug Log Filename = (Make sure this is null)2. FND: Debug Log Enabled = Yes3. FND: Debug Log Level = Statement4. FND: Debug