Two steps for importing Oracle Data

The following article describes how to import Oracle data and how to grant users the permission to import Oracle data, the following is a detailed description of the article. I hope you will gain some benefits after browsing.

1. import data from D: daochu. dmp to the TEST database.

Imp system/manager @ TEST file = d: daochu. dmp

Imp aichannel/aichannel @ HUST full = y file = d: datanewsmgnt. dmp ignore = y

The above may be a problem, because some tables already exist, and then it will report an error, the table will not be imported.

Add ignore = y to the end.

2. Import table 1 in d: daochu. dmp

Imp system/manager @ TEST file = d: daochu. dmp tables = (table1)

The preceding import and export operations are sufficient. In many cases, you must first completely delete the table and then import it.

Note:

If the operator has sufficient permissions, a prompt is displayed.

Databases can be connected. You can use tnsping TEST to obtain whether the database TEST can be connected.

Appendix:

Add Oracle Data Import permissions to users

First, start SQL * puls

Second, log in with system/manager

Third, create user username identified by password. If you have already created a user, skip this step)

Fourth, grant create user, drop user, alter user, create any view,

Drop any view, EXP_FULL_DATABASE, IMP_FULL_DATABASE,

DBA, CONNECT, RESOURCE, create session to Username

Fifth, run-cmd-to enter the directory where the dmp file is located,

Imp userid = system/manager full = y file = *. dmp

Or imp userid = system/manager full = y file = filename. dmp

Example:

F: WorkOracle_Databackup> imp userid = test/test full = y file = inner_policy.dmp

Screen Display

Import: Release 8.1.7.0.0-Production on Thursday February 16 16:50:05 2006

(C) Copyright 2000 Oracle Corporation. All rights reserved.

Connect to: Oracle8i Enterprise Edition Release 8.1.7.0.0-Production

With the Partitioning option

JServer Release 8.1.7.0.0-Production

EXPORT the files created by EXPORT: V08.01.07 in the normal path

The ZHS16GBK Character Set and ZHS16GBK NCHAR character set have been imported.

The export server uses the UTF8 NCHAR character set (possible ncharset conversion)

Importing AICHANNEL object to AICHANNEL

Importing table "inner_policy" 4 rows

Prepare to enable constraints...

Import is terminated successfully, but a warning is displayed.

The above is an introduction to Oracle Data Import. I hope you will gain some benefits.