Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

exp or imp command

Mohammed TajNov 30 2006 — edited Nov 30 2006
hello all

sir i was take export from oracle 10.1.3 on linux server.

during export operation i got "EXP-00091" error.

for this i was used "STATISTICS=NONE" and error is gone.

but when i was export "WITHOUT" "STATISTICS=NONE" clause my dmp file size is "659.1" MB. and when i export "WITH STATISTICS=NONE" clause my dmp file size is 631.9 Mb.

my first question why sir it is bcoz of "STATISTICS" parameter ?

________________________________________________________

after that i am import above dmp file ( WITH STATISTICS=NONE) parameter mean ( 631.9) size...on Windows Oracle Ver: 10.1.0

during import operation i am getting "IMP-00041" error.

bcoz of "STATISTICS=NONE" that is why i am getting "IMP-00041" error in import operation ?

during my export operation is got message like

During Export ....


Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)



During Import

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses US7ASCII character set (possible charset conversion)



sir waiting reply from oracle expert.....

thank in advance....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2006
Added on Nov 30 2006
8 comments
870 views