-
Import Error
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....
-
why are you trying to put systems objects into another users schema?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|