Home » RDBMS Server » Backup & Recovery » Exp/Imp Problem - Urgent Thanks Plz
icon9.gif  Exp/Imp Problem - Urgent Thanks Plz [message #136258] Wed, 07 September 2005 02:25 Go to next message
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 #136296 is a reply to message #136258] Wed, 07 September 2005 07:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You need to post your import session.

>>Its not importing table with NCLOB column type
If you are using LOBs it is expected.
Please see here.
See it the suggested methods work. Else post again.
http://www.orafaq.com/forum/t/27126/0/#msg_num_9
Re: Exp/Imp Problem - Urgent Thanks Plz [message #136382 is a reply to message #136296] Wed, 07 September 2005 18:18 Go to previous messageGo to next message
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
Re: Exp/Imp Problem - Urgent Thanks Plz [message #136510 is a reply to message #136382] Thu, 08 September 2005 08:00 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I cannot reproduce your case.
It is working good for me.
Post your export / import sessions ( that shows the concerned table is exported).
Previous Topic: Dynamically Increase Flash Recovery
Next Topic: need a script to backup ..??
Goto Forum:
  


Current Time: Fri Mar 29 02:01:30 CDT 2024