Step1, first know that you want to import the DMP files in the database (such as AA.DMP) is that version of the export (export imported version to be consistent, of course, 11g files can export 10g dmp files).
Step2, in the Sqlplus command box with
Method 1: Yesterday in order to manage some information of the database, the first time with Toad for Oracle this software. Did not expect to encounter the first use: "Can" T initialize OCI. Error-1 ".
This error is identified because there is no
(1) Loading and registering the JDBC driver for the database
Load JDBC Driver:
Class.forName ("Oracle.jdbc.driver.OracleDriver");
Register JDBC Driver:
Java.sql.DriverManager.registerDriver (New Oracle.jdbc.driver.OracleDriver ());
(2)
oracle10g RAC Shutdown and Boot Step 1: db (all instances), OS and server need to be shut down. A. First stop oracle10g Environment $ lsnrctl Stop (stops listening on each node, also can operate with Srvctl)
Or
$ srvctl Stop listener-n host1 (Stop
When you modify a field type for a table that already has data, Oracle prompts: ORA-01439: To change the data type, the column to be modified must be empty. You can create a new table, fill in the original table data, and then rename it, or create
If the table contains hierarchical data, you can use the Hierarchy query clause to select the row-level order. 1. The grammar of the hierarchy query clause
Hierarchy query clause syntax:
{CONNECT by [nocycle] condition [and condition] ... [START
Using the JDBC-ODBC bridge to connect to the Oracle database and JDBC driver is almost the same, so we don't have to set the environment variable. There are two key statements for connecting to the database in JDBC:
Class. forname ("oracle. JDBC.
The password file of Oracle is located in the $ ORACLE_HOME/DBS directory. The naming rule is orapw . If sid = linuxdb, the file name is orapwlinuxdb. The file is encrypted, if you use the text editing tool to open it, you will see Garbled
1. GSD global services daemonDescription of Oracle official documentation
The global services daemon (GSD) runs on each node with one GSD process per node. the GSD coordinates with the Cluster Manager to receive requests from clients such as the
1. SYS. audses $ sequence description 1.1 MOS description
Mos document: How sessions get their audsid identifier [ID 122230.1]
Sessionsconnecting to an Oracle database have a number of identifiers assigned to themwhich can be found in the V $
1. Internal Connection is simpleSelect a. *, B. * from a, B where a. ID = B. IDSelect a. *, B. * from a inner join B on A. ID = B. IDThe above two statements are completely equivalent.
2. left Outer JoinSelect * from EMP a left join dept D on A.
■ Xinmei, Ningbo Electric Power Bureau
Database Backup is the premise and basis for data recovery. If there is no data backup, it will be difficult to recover in the event of database problems or disasters. Common Oracle Database faults include
(I) direct path loading and buffer cache
Data inserted in the direct path is directly formatted as an oracle block from PGA without passing through the buffer cache.
Then, a common ORACLE Server process writes data blocks to data files.
Dbwn is not
The page number in the notes for ORACLE Advanced Training Course 2nd learning notebook corresponds to Oracle9i Database Management Basics II ed 1.1 vol.1.pdf
Guide: http://blog.csdn.net/magus_yang/archive/2006/10/10/1328283.aspx Author: jackyang
Oracle Advanced Training Course 5th learn the pages in the notes of the notebook and Oracle9i Database Management Basics II ed 1.1 vol.2.pdf correspondence guide: http://blog.csdn.net/magus_yang/archive/2006/10/10/1328283.aspx Author: jackyang
Database Name (db_name), Instance name (instance_name), and operating system environment variable (oracle_sid)
In oracle7 and 8 databases, only the Database Name (db_name) and database instance name (instance_name) are available ). A new parameter
CHAR and NCHAR are common types in Oracle databases, but the two data types are incompatible with each other. Here we will briefly discuss these two data types.
In Oracle, the CHAR type is a fixed-length string type with a maximum length of 2000
1 Overview
The monitoring and management of the Oracle SGA area is an important part of routine database maintenance. This article describes the basic concepts of SGA, the SGA running status check, and the parameter setting principles of SGA.
2
Virtual Machine: VirtualBox
(1)
To use full screen, shared functions, and other functions, you need to install enhanced functions for the Virtual Machine>
Click "device" --> "Install enhancement"
The optical drive icon appears on the desktop,
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