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 10.2.0.1.0 - Production on Fri Jun 29 10:12:51 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. Username: jbar Password: Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Productio n 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) >