Click here to Skip to main content
15,919,358 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have oracle DB with Roles Resource and DBA.I can't create dump file of this Database

I got following message

"Export done in AR8MSWIN1256 character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)

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

I can create dump file of oracle db .but it has no DBA role.

how can create Dump file of oracle DB, it has DBA Role
Updated 15-Jan-14 22:00pm
Jörgen Andersson 17-Jan-14 3:11am    
At the row "User to be exported: (RETURN to quit) >" it's asking you for which schema to export, simply supply that info.

Note that you're not using the same character set on your client as on your server, the probability that you will be exporting garbage is very large.
Run the export from the server instead. Or install a client with the same character set as on the server.
Member 8470112 22-Jan-14 2:29am    
thank you..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900