| Exp/Imp Problem - Urgent Thanks Plz [message #136247] |
Wed, 07 September 2005 00:23  |
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 system/test file=t1.dmp grants=y ROWS=y CONSTRAINTS=y INDEXES=y
and then imporing
db2
>imp system/test file=t1.dmp fromuser=u1 touser=u1
then i login into db2
u1/u1
select * from tab;
40 rows selected
Dont know why its missing few tables from db1 export.
Thanks
|
|
|
|
| Re: Exp/Imp Problem - Urgent Thanks Plz [message #136254 is a reply to message #136247] |
Wed, 07 September 2005 02:11  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Can u post the entire result of the export/import command,
Anyways are you trying a user level export if yes,
| Quote: |
exp system/test file=t1.dmp grants=y ROWS=y CONSTRAINTS=y INDEXES=y
|
then where did u specify the OWNER parameter in the export command. The above command exports system's schema rather than u1's schema.
and if anything else then do post with the command line results.
regards,
tarun
|
|
|
|
| Re: Exp/Imp Problem - Urgent Thanks Plz [message #136256 is a reply to message #136254] |
Wed, 07 September 2005 02:20 |
mymot
Messages: 225
Registered: July 2005
|
Senior Member |
|
|
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
|
|
|
|
| Re: Exp/Imp Problem - Urgent Thanks Plz [message #136257 is a reply to message #136256] |
Wed, 07 September 2005 02:23 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
hey can u post the output like this
| Quote: |
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
D:\>exp rajesh/rajesh file=c:\t1.dmp grants=y rows=y constraints=y indexes=y
Export: Release 9.2.0.1.0 - Production on Wed Sep 7 12:37:11 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user RAJESH
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user RAJESH
About to export RAJESH's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export RAJESH's tables via Conventional Path ...
. . exporting table BONUS 0 rows exported
. . exporting table DEPT 4 rows exported
. . exporting table EMP 14 rows exported
. . exporting table SALGRADE 6 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
D:\>imp system/manager file=c:\t1.dmp fromuser=rajesh touser=tanu
Import: Release 9.2.0.1.0 - Production on Wed Sep 7 12:48:41 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
Warning: the objects were exported by RAJESH, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing RAJESH's objects into TANU
. . importing table "BONUS" 0 rows imported
. . importing table "DEPT" 4 rows imported
. . importing table "EMP" 14 rows imported
. . importing table "SALGRADE" 6 rows imported
About to enable constraints...
Import terminated successfully without warnings.
|
then it would be easier to interpret.
thanks & regards,
tarun
|
|
|
|
| Re: Exp/Imp Problem - Urgent Thanks Plz [message #136275 is a reply to message #136257] |
Wed, 07 September 2005 05:11 |
mymot
Messages: 225
Registered: July 2005
|
Senior Member |
|
|
Thanks Tarun,
Actually i have checked the exp/imp oprations again on my schema
u1/u1 on db1
and checked those five tables which were not imported on db2 and found out that those 5 tables have NCLOB datatype in their schema defition and rest of tables , procedures,indexes were imported very well.
I think problem is with NCLOB column type.
If you have any tables with NCLOB then u can try exp and imp let me know how it goes.
Thanks
|
|
|
|
 Re: Exp/Imp Problem - Urgent Thanks Plz [message #136397 is a reply to message #136275] |
Wed, 07 September 2005 21:11 |
mymot
Messages: 225
Registered: July 2005
|
Senior Member |
|
|
Thanks Folks.
I have solved the problem.
I was using incorrect version of exp/imp with Oracle 9i db .
I have used the Oracle 9i Export/Import : Release 9.2.0.1.0 and it worked fine with NCLOB datatype tables.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
