Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am trying to export the user from database, but its showing

export done in we8mswin1252 character set and al16utf16 nchar character set

But if i am trying to export entire database then its successfully completing. I want to export only one user. How to fix the problem with this Oracle character set.

process which i followed:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\user>exp

Export: Release - Production on Fri Jun 29 10:12:51 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Username: jbar

Connected to: Oracle Database 10g Express Edition Release - Productio
Enter array fetch buffer size: 4096 >

Export file: EXPDAT.DMP > rampro.dmp

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 2

Export grants (yes/no): yes > y

Export table data (yes/no): yes > y

Compress extents (yes/no): yes > y

Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified users ...
User to be exported: (RETURN to quit) >

Thanking you!

share|improve this question
Is it producing an actual error? I thought the message you quoted was just for information purposes? –  Phil Jun 28 '12 at 15:26
Actually it is not an error. but after the export done message, there is no export files created. So but if am trying to export entire database, then its working successfully. So what is the problem for user export? –  A.D Jun 29 '12 at 4:45
Did you actually type in a username to export when prompted with User to be exported: (RETURN to quit) >, or did you press RETURN? –  Phil Jul 4 '12 at 9:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.