Exp/Imp Problem - Urgent Thanks Plz [message #136258] |
Wed, 07 September 2005 02:25 |
mymot
Messages: 225 Registered: July 2005
|
Senior Member |
|
|
HI,
I am trying to exp and imp data from one db to another db using
u1 and u1 both with the same name available in db1 and db2
db1
select * from tab;
45 rows selected
>exp u1/u1 file=t1.dmp grants=y ROWS=y CONSTRAINTS=y INDEXES=y
and then imporing
db2
>imp u1/u1 file=t1.dmp fromuser=u1 touser=u1
then i login into db2
connect u1/u1
select * from tab;
40 rows selected
Dont know why its missing few tables from db1 export?
i am expecting 45 tables , some procedures, indexes....etc should be exported
and same thing should be imported but i cant see all the tables...
===================================
Export: Release 9.2.0.1.0 - Production on Wed Sep 7 17:25:31 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user U1
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user U1
About to export U1's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export U1's tables via Conventional Path ...
.
.
.
.
xporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.
Its not importing table with NCLOB column type.
Thanks
|
|
|
|
Re: Exp/Imp Problem - Urgent Thanks Plz [message #136382 is a reply to message #136296] |
Wed, 07 September 2005 18:18 |
mymot
Messages: 225 Registered: July 2005
|
Senior Member |
|
|
Hi,
Import is not giving me an error while importing.
But when i check both source and destinatin DBs, then i could see that destination db hasnt imported table with NCLOB Datatype.
Is there any solution to this problem?
Thanks
|
|
|
|