I Export a Database Dump from Oracle 8i. Drop All Table in Target Database and Importthe Database Dump, i Found That All of The Non-ASCII Characters Can NOTBE 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-8useful pl / sql
The Way to delete the all the table without drop the user.
set termout offset feedback offset pagesize 0set linesize 200col object_name format a30col object_type format a30col owner format a30set trimspool onspool dropall.sqlselect 'DROP' || object_type || '' || owner || '' || object_name || ';.' from All_Objects where = '& username'; spool off@dropall.sql
