Q: problem using SYS.DBMS_STREAMS_TABLESPACE

From: Amihay Gonen <AmihayG_at_ectel.com>
Date: Thu, 9 Feb 2006 15:09:21 +0200
Message-ID: <5A841A20A9085A4C984EADD0FF97BF3754B9AB@ectilex.ectel.com>

Hi , I wonder if any succeed to copy tablespace from window (32bit ) to sun (64bit)

We are tring to use streams (which is very cool ).

The command we use is :

BEGIN
DBMS_STREAMS_TABLESPACE_ADM
.PULL_SIMPLE_TABLESPACE (

     tablespace_name     => 'SCOTT',
     database_link       => 'E2E.MARVEL',
     directory_object    => 'DBF_DIR',
     conversion_extension => 'windows'

);
END; And the output is

BEGIN
*
ERROR at line 1:
ORA-19624: operation failed, retry possible ORA-19625: error identifying file
/oracle10/oradata/P2P/P2P/datafile/SCOTT.ORA ORA-27047: unable to read the header block of file Additional information: 2
ORA-06512: at "SYS.DBMS_STREAMS_TABLESPACE_ADM", line 2092 ORA-06512: at line 2

And ideas ?

IMPORTANT: The contents of this email and any attachments are confidential and proprietary to ECtel Ltd. They are intended for the named recipient(s) only. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, use, distribution or copying of this communication is strictly prohibited and may be unlawful. If you have received this email in error, please notify us immediately by replying to the message and deleting it from your computer.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 09 2006 - 07:09:21 CST

Q: problem using SYS.DBMS_STREAMS_TABLESPACE_ADM