How to correctly import table 1 in Oracle daochu. dmp

If you want to import Table 1 from Oracle daochu. dmp to imp system/manager @ TEST file = d: \ daochu. dmp tables = (table1), there is no problem. However, there are still many problems that may occur in actual operations. The following describes how to solve the problem.

Appendix 1:

Add 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, import table 1 in Oracle daochu. dmp-cmd-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: \ Work \ Oracle_Data \ backup> 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.

Appendix 2:

Oracle cannot directly change the table owner. Export/Import can be used to achieve this purpose.

First create import9.par,

The command is as follows: imp parfile =/filepath/import9.par

The content of import9.par is as follows:

FROMUSER = TGPMS

TOUSER = TGPMS2 Note: Change the table owner from FROMUSER to TOUSER. Users of FROMUSER and TOUSER can be different)

ROWS = Y

INDEXES = Y

GRANTS = Y

CONSTRAINTS = Y

Buffer= 409600

File =/backup/ctgpc_20030623.dmp

Log =/backup/import_20030623.log

The above is for Oracle daochu. table 1 in dmp imports imp system/manager @ TEST file = d: \ daochu. dmp tables = (table1) some difficult problems will be solved during import and export, and you will be expected to gain some benefits.