How to Export/import database dump correctly

原创 2005年02月28日 16:28:00

I export a database dump from oracle 8i. Drop all table in the target database and importthe database dump,  I found that all of the non-ASCII characters can not be displayed correctly.

The way to resolve it is before doing the export and import, try to execute this.

set NLS_LANG=american_america.UTF8 If all your character is stored with the UTF-8

Useful pl/sql

The way to delete the all  the tables without drop the user.

set termout off
set feedback off
set pagesize 0
set linesize 200
col object_name format a30
col object_type format a30
col owner format a30
set trimspool on
spool dropall.sql
select 'DROP ' || object_type || ' '|| owner||'.'||object_name|| ';' from all_objects where owner='&username';
spool off

@dropall.sql

相关文章推荐

How to Export and Import Oracle Database Statistics Information

Some times  not convenient to the database for analyisis when the database have a large mount of dat...

How to export/import data with LOB type from one user/schema to another

How to export/import data with LOB type from one user/schema to another? [ID 464558.1] ...

How to correctly translate an error code into an error message

When you need to get the message corresponding to a system (Win32) error code, use the following: //...

HOWTO: How to Use PeekMessage() Correctly in Windows

SUMMARY In the Windows environment, many applications use a PeekMessage() loop to perform backgrou...
  • js_gary
  • js_gary
  • 2011年11月07日 16:16
  • 774

csharp: Export DataSet into Excel and import all the Excel sheets to DataSet

/// /// Export DataSet into Excel /// /// /// private void Fo...

csharp: Export DataSet into Excel and import all the Excel sheets to DataSet

/// /// Export DataSet into Excel /// /// /// private void Fo...

How to Import ESSMSS Configuration in NWDI

  • 2011年11月10日 17:13
  • 326KB
  • 下载

How to Import a PST file into Outlook 2013

  • 2015年02月26日 17:52
  • 435KB
  • 下载

Export GridView with Images from database to Word Excel and PDF Formats

转自: http://www.aspsnippets.com/Articles/Export-GridView-with-Images-from-database-to-Word-Excel-and-...
  • lJean
  • lJean
  • 2011年10月18日 17:55
  • 790
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:How to Export/import database dump correctly
举报原因:
原因补充:

(最多只允许输入30个字)