| Problem in Import [message #178213] |
Tue, 20 June 2006 02:38  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
I've to do a schema level import from the dump created using schema level
export.
Due to lack of space in tablespace,while import level schema,some of the tables
is not imported,so after freeing the space,i tried to import those tables using the
following script,
file=CRM_15June06.dmp
log=impCRMerrtables1_19June2006.log
tables=(MODEL,
MODEL_BKP,
MODEL_SCORE_TYPE,
MODEL_SCORE_TYPE_BKP,
MODEL_TMP,
MOTOR_INSURANCE,
MVIEW_COMMON_JOIN)
buffer=1024000
commit=y
Then i started the import as follows,i've started it half an hour before,but
still this activity standing at this line . importing SYSTEM's objects into CRM,without reporting any error & progress.At the background,i checked whether tables
are created or not in CRM schema,but they're not created.
$ imp parfile=impCRMerrtables1_20June2006.par
Import: Release 9.2.0.6.0 - Production on Tue Jun 20 12:37:28 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username: crm
Password:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
Warning: the objects were exported by SYSTEM, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
. importing SYSTEM's objects into CRM
Please help me in this problem,What i've to do to avoid this error?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
