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.
	




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