1, sys and system user differences
The system user can only log on em with normal status.
SYS user has "SYSDBA" or "sysoper" permission, landing em can only use these two identities, can not use normal.
"Sysoper" permissions, which are database
--Logging mode (LOGGING, FORCE LOGGING, nologging)
--==================================================
First, logging mode (LOGGING, FORCE LOGGING, nologging)
1. Meaning of the three
LOGGING: Log information is logged to the online redo log
Since 10g, Oracle has provided more efficient data Pump (i.e., EXPDP/IMPDP) for the import and export of imports, and old exp/imp can be used, but is not recommended. Note: EXPDP/IMPDP and Exp/imp are incompatible, that is, exp exported files can
Hint (hint) is undoubtedly the most basic way to control the implementation of the plan; by embedding the optimizer directive directly in the SQL statement, and then making the optimizer select hint specified execution path when executing the
Oracle autonomous transactions are stored procedures and functions that can handle internal transactions themselves and are not affected by external transactions and are declared with pragma autonomous_transaction. To create an autonomous
First, the need for database upgradesDatabase upgrades are a common problem for database administrators, if your application uses new features of the new version of the database, and if the database is overloaded, there can be no fundamental
The Oracle tutorials that are being looked at are the facets of Oracle data security.
Oracle Data Security aspectsAuthor: づ★sl Ares with the popularization of computers and the development of the network, the database is no longer just the topic
The Oracle tutorial you are looking at is that Oracle uses Pl/sql to manipulate COM objects. The Pl/sql is extended by Oracle company to standard SQL, dedicated to programming in Oracle databases, and is a third-generation process programming
(1) DES encryption function
Create or Replace function
encrypt_des (p_text varchar2, P_key varchar2) return varchar2 is
v_text varchar2 (4000) ;
V_ENC varchar2 (4000);
Raw_input RAW (128);
Key_input RAW (128);
Decrypted_raw Raw (2048);
Begin
Recently, the company leader told the next product, may involve Oracle database, formerly used most is MSSQL, some time ago learned MySQL is also a little used. Oracle has not been contacted. Should have done for me before. NET development, so data
This error frequently occurs in Oracle data after an illegal shutdown:
Exp-00056:oracle Error 1033 appears
Ora-01033:oracle initialization or shutdown in progress
User:
Password:
This is obviously the database does not have the means to start,
(1) Select the most efficient table name order (valid only in the Rule-based optimizer):
The Oracle parser processes the table names in the FROM clause in Right-to-left order, the last table (driving table), which is written in the FROM clause, is
If the required archive is lost during recover datafile, the recover cannot be made, and the bbed tool can skip the lost archive for recover datafile.
The experimental process is as follows:
Sys@orcl>select * from V$version;
BANNER
--------------
Parallel: Divide a work into several pieces and divide it into different processes and process them simultaneously. Process level
Concurrency: Multiple sessions are accessed at the same time, which is usually the number of concurrent numbers.
Redhat9.0 is a very good Linux distribution, with good Chinese support and rich application software, so that the author, including a lot of Linux with the home fondle admiringly. However, due to the high Redhat9.0 version of GCC, some compatibility
It is very important to develop database applications and choose a good database. This article compares SQL Server with Oracle, DB2 three kinds of database from some aspects, provides some reference for you to choose the database.
Open
SQL Server
From: http://2843678.blog.51cto.com/2833678/951331Original works, allow reprint, please be sure to use hyperlinks in the form of the original source of the article, author information and this statement. Otherwise, the legal liability will be
Today, a development library can not start, sent over an error to see the log file is damaged (see), and then said the cause and the cause. Said the server was out of power and then did not start up again. Today someone used to think about dealing
During routine maintenance of Oracle databases, we may often encounter errors that we have never seen before, or even inexplicably. In many cases, you cannot even search for related content through metalink, baidu, or google. This is not the case.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service