Re: How to export a number of tables from a tablespace

Moe wrote:

> I did the export and was successfull. Now i wanted to import my dump to
> another schema. When i do that i get:
> Connected to: Oracle Database 10g Release 10.1.0.2.0 - Production
> Master table "MOE"."SYS_IMPORT_FULL_02" successfully loaded/unloaded
> Starting "MOE"."SYS_IMPORT_FULL_02": moe/******** DIRECTORY=dumpref
> DUMPFILE=seq.dmp
> ORA-39125: Worker unexpected fatal error in
> KUPW$WORKER.DISPATCH_WORK_ITEMS while calling
> SYS.DBMS_INTERNAL_SAFE_SCN.SCN.SET_SESSION_STATE
> [TABLE_DATA:"MOE"."SYS_IMPORT_FULL_02"]
> ORA-00439: feature not enabled: Streams Capture
> ----- PL/SQL Call Stack -----
> object line object
> handle number name
> 563E0B50 13460 package body SYS.KUPW$WORKER
> 563E0B50 5810 package body SYS.KUPW$WORKER
> 563E0B50 6459 package body SYS.KUPW$WORKER
> 563E0B50 1208 package body SYS.KUPW$WORKER
> 54CC1F70 2 anonymous block
> Job "MOE"."SYS_IMPORT_FULL_02" stopped due to fatal error at 15:44
>
> Any idea of what is causing this?
>

Is the target schema for import in the same database as the export?

You are obviously using Data Pump, not traditional exp/imp. Based on your error message, you should probably read up on the following Data Pump parameters as well as the Streams documentation:

STREAMS_CONFIGURATION
STREAMS_INSTANTIATION -Mark Bole Received on Sun Sep 04 2005 - 20:01:54 CDT