Friday, February 27, 2009

Table mode import - same table name scenario

I have tested the folloiwng scenario in a 9i database:
- 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: