RE: problem using SYS.DBMS_STREAMS_TABLESPACE

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

Yes . the file pass ok , with the same size.

From: Bobak, Mark [mailto:Mark.Bobak_at_il.proquest.com] Sent: 09 February 2006 15:10
To: Amihay Gonen; oracle-l_at_freelists.org Subject: RE: problem using SYS.DBMS_STREAMS_TABLESPACE_ADM

Um, does this file /oracle10/oradata/P2P/P2P/datafile/SCOTT.ORA exist??

--

Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

"There are 10 types of people in the world: Those who understand binary, and those who don't."

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Amihay Gonen Sent: Thursday, February 09, 2006 8:09 AM To: oracle-l_at_freelists.org
Subject: Q: problem using SYS.DBMS_STREAMS_TABLESPACE_ADM

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.

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:15:04 CST