Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to export a number of tables from a tablespace

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 04 Sep 2005 15:34:32 -0700
Message-ID: <1125873232.202906@yasure>


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?

Did you export objects owned by SYS?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sun Sep 04 2005 - 17:34:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US