Oracle Data import Full __oracle

Quote Your friends blog: http://www.blogjava.net/amigoxie/archive/2010/05/21/321542.html

one. Oracle Server Installation

Recently Ann mm asked me 2 years ago to write a simple Oracle data import the entire document, afraid to find out later, or put a blog.
Click on 10g_win32_db "Disk1 under Setup.exe to enter the Welcome interface for Oracle installation, as shown in Figure 1

As shown:

Figure 1 oracle10g installed Welcome interface

After selecting "Advanced Installation" in Figure 1, click the "Next" button to eject the "Specify File path" interface, as shown in Figure 2:

Figure 2 Specifying the file path

In Figure 2, select the path to the file installation, where you can make no changes, and then click Next (N) to enter the "Select Installation Type Interface", as shown in Figure 3:

Figure 3 "Select installation Type" interface

The installation type in Figure 3 Select Enterprise, click Next (N), and go to the "Select Database Configuration" interface, as shown in Figure 4:

Figure 4 "Select Database Configuration" interface

Select "General" in Figure 4 and click Next (N) to enter the "Specify Database configuration Options" interface, as shown in Figure 5:

Figure 5 "Specify Database configuration Options" interface

In Figure 5, both the global database name and SID are set to ORCL and the database character set is selected as "Simplified Chinese _ZHS16GBK", click the next (N) button to enter the database management options interface, as shown in Figure 6:

Figure 6 "Select database management Options" interface

In Figure 6, select Use database control to manage databases, and click the next (N) button to enter the "Specify Database File storage Options" interface, as shown in Figure 7:

Figure 7 "Specify Database File storage Options" interface

Select File system in Figure 7 and specify the location of the database file where the reader does not make changes, click Next (N) and go to the "Specify Backup and Restore Options" interface, as shown in Figure 8:

Figure 8 "Specify Backup and restore Options" interface

If you do not need to start automatic backup, the reader can choose the "Do not enable automatic backup" option, the author selected is this option, and then click the "Next (N)" button, into the "Specify Database scheme password" interface, as shown in Figure 9:

Figure 9 "Password for the specified database scheme" interface

In Figure 9, select "All accounts are using the same password" and enter the password, such as ecity after clicking the "Install" button, into Oracle processing, after processing, click the "Next (N)" button to enter the installation profile interface, as shown in Figure 10:

Figure 10 Installation Profile interface

Click the "Install" button in Figure 10 to complete the Oracle installation.

two. Create a table space

After the Oracle server is installed, the next thing you need to do is to create a table space.

Enter the "program"-> "oracle-oraclient10g_home1"-> "Enterprise Manager Console" and enter the Enterprise management console, as shown in Figure 11:

Figure Enterprise Manager Console's initial interface

In Figure 11, the "Add Data to Tree" window is popped, the port number can use the default port number of 1521, the host name can be entered 127.0.0.1, or the Ora configuration file in the D: "Oracle" Product "10.1.0" db_1 "network" admin is turned on. Locate the corresponding host name and put it in the "host name" line, as shown in Figure 12:

Figure 12 "Adding a database to a tree" interface

Figure 12 When the setup is complete, clicking on the "OK" button will bring up the "Database connection information" setting interface, as shown in Figure 13:

Figure 13 "Database connection Information" settings interface

In Figure 13, enter the connection information, the user name is system, the password is the reader set in Figure 9 password (the author is ecity), after the setup is complete, click "OK" button, will pop up Figure 14 interface, can see the corresponding database information:

Figure 14 Database connection Setup Successful interface

In Figure 14, the reader can see the "tablespace" option in the menu on the left, which is used to set the tablespace, select it, right-click "Create", and go to the "CREATE Table Space" interface, as shown in Figure 15:

Figure 15 The "Set Table Space" interface

In Figure 15, enter the name and size information, such as name: Ecity, and then click "Create" when the size is set to 500. Completes the creation of the table space.

three. Create a user

After the table space was successfully created, the user needed to create the ecity, the Ecity database has four users, namely: Ecity_zh, Ecity_en, Ecity_common, and map. In Figure 14, the "security" point of the left menu is opened to see the submenu below: The user, as shown in Figure 16:

Figure 16 "Set User" interface

After clicking "User", right click "Create" and go to "Create user" interface, as shown in Figure 17:

Figure 17 "Set User" interface

Because the steps to create a user are the same, the reader will only demonstrate the creation of the user Ecity_common, and enter the password in the General Information tab, for example, where the author is set to: Ecity_common, and the name is also: Ecity_common, then select the Role tab, As shown in Figure 18:

Figure 18 Setting the user's role

In Figure 18, set the Ecity_common user's role as DBA, and when the setup is complete, click the "Create" button to complete the creation of the user.

The "hint" Ecity_zh, ecity_en, and map users are created similar to this and are no longer to repeat.

Four. Import Data

Finally, one step is to import Ecity_common. DMP, Ecity_en. Data in DMP, Ecity_zh.dmp, and Map.dmp. The process of importing data is almost the same, where the data in ECITY_ZH.DMP is imported as an example.

First copy the four DMP files to a directory without Chinese, such as f: ".

Enter "cmd" to enter the command line and enter IMP command, the interface prompts for a username and password, as shown in Figure 19:

Figure 19 Input database username and password interface

In Figure 19, enter the username and password for the data you want to import, in this case, Ecity_zh. After successfully linking to Oracle, prompt to import the file, set the path of the import file, and press "enter" until you have "import the entire export file" (yes/no): No, enter Yes to begin ECITY_ZH.DMP the import of the data, as shown in Figure 20:

Figure 20 Importing Oracle Data

After the import is successful, enter IMP and use the appropriate data to complete the import of Ecity_common.dmp, Ecity_en.dmp, and map.dmp data.