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



1.     could not find java.dll C:\Users\admin>java Error: Registry key 'Software\JavaSoft\JavaRunt...
  • rchm8519
  • rchm8519
  • 2015年01月12日 15:40
  • 55704


This tutorial assumes you are starting fresh and have no existing Kafka™ or ZooKeeper data. Since Ka...
  • beitiandijun
  • beitiandijun
  • 2016年12月16日 15:01
  • 1284


先看我们最关心的问题 db2move用于快速导出/导入整个数据库的数据,操作过程: 1.数据导出: db2move DBNAME export -u userName -p password ...
  • pianzif
  • pianzif
  • 2014年03月30日 01:38
  • 4685

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...
  • sweethouse1128
  • sweethouse1128
  • 2012年01月12日 21:24
  • 646

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] ...
  • tswisdom
  • tswisdom
  • 2012年02月16日 18:13
  • 898

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
  • 809

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: //...
  • jdzfjfhnui
  • jdzfjfhnui
  • 2011年06月30日 20:09
  • 708

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

/// /// Export DataSet into Excel /// /// /// private void Fo...
  • geovindu
  • geovindu
  • 2015年07月10日 17:30
  • 396

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

  • lJean
  • lJean
  • 2011年10月18日 17:55
  • 820

How Can I Make it Faster to Import Data into MySQL Server

  • 2013年11月18日 13:37
  • 71KB
  • 下载
您举报文章:How to Export/import database dump correctly