Need Help: Question on Export/Import

[Quoted] I'm a Oracle Developer which occassionally need to perform some simple DBA work.
[Quoted] Recently I'm trying to setup another PC with Oracle 8.1.5 and needed to export
a schema in the old DB to the new one. However, the data imported cannot seems
[Quoted] not correctly, specifically, those double-byte characters.

My export script is:

      exp file=c:\db_data.dmp userid=system/manager owner=busapp

where busapp is the schema containing all the data.

This export script runs well and data are exported with no warnings. The NLS_LANG of the old DB is AMERICAN_AMERICA.ZHT16BIG5.

When I import this to the new DB, it has error/warning as follows:

IMP-00017: following statement failed with ORACLE error 2437:
"ALTER TABLE "MY_TAB" ADD CONSTRAINT "TAB_PK" PRIMARY KEY ("BUS_N"
"O") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIA"
"L 802816 NEXT 147456 MINEXTENTS 1 MAXEXTENTS 300 PCTINCREASE 1 FREELISTS 1
"
"FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" ENABLE
NOVALIDAT"
"E"

[Quoted] Import terminated successfully with warnings.

Can anyone guide me to found a solution? As I mentioned before, I'm not the DBA,
[Quoted] so please let me know the concept towards solving the problem.

Thanks very much.
Mandy Received on Tue Feb 03 2004 - 18:21:59 CET