- we have two tables with same name under different schemas
- we want to imp these two tables.
exp.par looks like:
-----
file=test.dmp
tables=
system.t,
denis.t
-----
imp.par looks like:
-----
file=test.dmp
fromuser=system,denis
touser=system,denis
tables=
t
-------
Note: I only specified one table name 't' in the par file
The following is the screen output during imp:
$ imp denis/oracle parfile=imp.par
Import: Release 9.2.0.8.0 - Production on Fri Feb 27 09:22:39 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.8.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing SYSTEM's objects into SYSTEM
. . importing table "T" 1 rows imported
. importing DENIS's objects into DENIS
. . importing table "T" 1 rows imported
Import terminated successfully without warnings.
I verified that different table T created under desired schemas after imp.
No comments:
Post a Comment