RE: problem using SYS.DBMS_STREAMS_TABLESPACE_ADM

  • From: "Amihay Gonen" <AmihayG@xxxxxxxxx>
  • To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • Date: Thu, 9 Feb 2006 15:15:04 +0200

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



________________________________

From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxxxxx]
Sent: 09 February 2006 15:10
To: Amihay Gonen; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Amihay Gonen
Sent: Thursday, February 09, 2006 8:09 AM
To: oracle-l@xxxxxxxxxxxxx
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.

Other related posts: