| Import problem [message #175630] |
Sat, 03 June 2006 12:28  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
A dump is created by taking 5 tables export,
i tried to import those tables as follows,
Parfile contains,
----------------
file=exp5tab.dmp
log=imp5tab.log
buffer=1024000
fromuser=system
touser=cw
commit=y
$ imp parfile=imp5tab.par
Import: Release 9.2.0.6.0 - Production on Sat Jun 3 22:00:55 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username: system
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 direct path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
Import terminated successfully without warnings.
---------------------------------------------------------------------
In log,nothing about the imported tables is displayed,why it is so?
Then,i checked the schema(cw),where no tables is created from the dump.
what type of problem it's?how i've to rectify it?
Please give me a solution as soon as possible.
I'm waiting for the reply....
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
