Import and export of Oracle data (SID service.msc)

One: Release Notes:

(1) (Oracle11 32-bit system) oracle-oradb11g_home1;

(2) After successful installation, the following is displayed: The first diagram is the management tool, creating the connection, creating the table, and the second is the database creation tool;

(3)Oracle database creation is not like MySQL first establish a connection (localhost 3306), and then right-click on the connection interface to create the database, and then create the table, a connection to multiple databases Oracle is the opposite: Create a Database First (by the second graph is the database creation tool), then establish the connection (by the first graph is the management tool, create the connection, create the table), create the table on the basis of the connection, a database can correspond to multiple connections ;

(4) In fact, the simple process of creating a database is: 1 fill in the database naming and SID 2 All users Unified password 3 Click the "Save as HTML File" button, the creation process (only three steps), plus a password management (due to the introduction and export of Oracle data explained here, create Will not be explained in detail)

(5) Data import and export in the third item of this article, you need to open the service in item fourth.

Two: the establishment of data connection

(1) Establishing a connection in SYS

(2) Create a new user create a new connection

(3)

(4)

Three: Import and export

(1) Import: Smartcity is the SID number when creating the Tju.cs.smartcity database

(2) Exporting a database

Four: Oracle services that need to be opened under Service.msc:

Import and export of Oracle data (SID service.msc)