Oracle

--Backup control file Rman target /rman> startuprman> configure controlfile autobackup  on; --Start automatic backup rman> show controlfile autobackup;  --show whether the control files are automatically backed up rman>

Viewing listening, using a grid user 11GRAC1:11grac1-> lsnrctl statuslsnrctl for linux: version 11.2.0.3.0 -  production on 14-aug-2015 00:30:26copyright  (c)  1991, 2011, Oracle.   all rights reserved. connecting to  (description= (address=

oracle11g The default password expiration limit when creating a user is 180 days (that is, 6 months) and the user cannot log on if the user password has not been modified for more than 180 days.Oracle Corporation has introduced this default feature

Toad for Oracle Chinese display garbledData storage When the Chinese display is normal, in Toad for Oracle client and page display are garbled!!!Cause: A problem that occurs when data is in storage.Solution:Increment in system variable: variable

Summary of reasons for slow Oracle query speedThe reasons for the slow query are many, and the following are common:1, no index or no index (this is the most common problem of slow query, is the defect of program design)The 2,i/o throughput is small,

Original address: http://www.cnblogs.com/liuxianan/archive/2012/08/05/2624300.htmlThe most basic Oracle database connection code (for oracle11g only):1, right-click Project, build path, configuration build path, select the third item "Library", then

Source: The item will be taken out of the database Amount (unit), the third party needs the amount of units in yuan, here is related to the question of retaining 2 decimal places First, the format of the function To_char Here I summarize these

Previously wrote an article about SQL Server access to the MySQL database, and recently just encountered the need to access Oracle, the configuration process is recorded for your reference.Preparatory workDo the following on the host that requires

Test the code in Windows environment:ImportJava.io.File;Importjava.io.FileNotFoundException;ImportJava.io.FileWriter;Importjava.io.IOException;ImportJava.io.InputStream;ImportJava.io.PrintWriter;ImportJava.util.Scanner; Public classTesttimer {/**

I. Change Password1) Change Password sql>alter user User01 identified by password;2) Change Password and unlocksql>alter user User01 account unlock identified by P Assword;3) Unlocking operationSql>alter User User01 Account unlockTwo. Set Password

1. What is TNS?TNS is part of Oracle NET, a tool dedicated to managing and configuring Oracle Database and client connections, and in most cases the client and database must be configured for TNS, but in rare cases, you can connect to an Oracle

Modifying the 1521, 8080 ports used by Oracle XE Listener today, when helping developers demon install Oraclexe, there is a hint: [SQL] Destination folder:d:\oraclexe\ Port for ' Oracle Database Listener ': 1521 Port for ' Oracle

Recently, because of the need for work, understand the subtle relationship between PowerDesigner and Oracle, special to share their own summary of the small partners.First, export the physical data model in Oracle1, the process of export, is to do a

How to start OracleOne of the services in Windows system Services is called: "Oracleservice[sid]" SID is your instance name when you install Oracle XE, and if you do not change the default is "XE",Oracleservicexe and Oraclexetnslistener

With Oracle installed on this machine, when using Sqlplus and Plsqldev connections, Tnsname.ora in the host write is localhost, at this time to connect Oracle no problem, but the external machine connected to the machine, and Tnsname.ora in the host

Creation of the Oracle database starts and closesObjective:(1) master the creation and deletion of Oracle 11g database. (2) mastering The start-up and shutdown of an Oracle db instance. Content:First, create a database1. Planning Database2. to

The Windows operating system (whether 32bit or 64bit) is not supported by the Db_32k_cache_size parameter for Oracle DB.As follows:F:\oracle\product\10.2.0\db_1\bin>sqlplus/as sysdbasql*plus:release 10.2.0.4.0-production on Tue 19 09:03:23 2

Data dictionary table for Oracle users, roles, and permissions (System and object permissions), and oracle dictionary 1. Three dictionary tables 1.1 users Select * from dba_users; Select * from all_users; Select * from user_users; 1.2 roles Select *

Oracle -- Windows cannot start OracleDBConsoleorcl on the local computer. Error Code 1 After the database is installed, it can be started. After the computer is restarted, an error will be reported when it is manually started. Symptom:Windows

Why is Oracle expdp faster than exp? What is the principle? First read the official oracle 10g documentation: Database Utilities Data Performance Improvements for Data Pump Export and ImportThe improved performance of the Data Pump Export and Import