.ora-code.com

Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
Q: problem using SYS.DBMS_STREAMS_TABLESPACE_ADM

Q: problem using SYS.DBMS_STREAMS_TABLESPACE_ADM

2006-02-09       - By Amihay Gonen


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 (See ORA-19624.ora-code.com): operation failed, retry possible
ORA-19625 (See ORA-19625.ora-code.com): error identifying file
/oracle10/oradata/P2P/P2P/datafile/SCOTT.ORA
ORA-27047 (See ORA-27047.ora-code.com): unable to read the header block of file
Additional information: 2
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_STREAMS_TABLESPACE_ADM", line 2092
ORA-06512 (See ORA-06512.ora-code.com): 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.
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft
-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http:
//www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@(protected)
  {font-family:Tahoma;
  panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
  {margin:0in;
  margin-bottom:.0001pt;
  font-size:12.0pt;
  font-family:"Times New Roman";}
a:link, span.MsoHyperlink
  {color:blue;
  text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
  {color:purple;
  text-decoration:underline;}
span.EmailStyle17
  {mso-style-type:personal;
  font-family:Arial;
  color:windowtext;}
span.EmailStyle18
  {mso-style-type:personal-reply;
  font-family:Arial;
  color:navy;}
@(protected) Section1
  {size:8.5in 11.0in;
  margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
  {page:Section1;}
-->
</style>

</head>

<body lang=EN-US link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi , I wonder if any succeed to copy
tablespace
from window (32bit ) to sun (64bit)<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>We are tring to use streams (which is very
cool ).<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The command we use is :<o:p></o:p></span><
/font></p>

<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>BEGIN<br>
&nbsp; DBMS_STREAMS_TABLESPACE_ADM<br>
&nbsp;&nbsp;&nbsp; .PULL_SIMPLE_TABLESPACE (<br>
&nbsp;&nbsp;&nbsp;&nbsp; tablespace_name&nbsp;&nbsp;&nbsp;&nbsp; =&gt; 'SCOTT',
<br>
&nbsp;&nbsp;&nbsp;&nbsp; database_link&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
=&gt; 'E2E.MARVEL',<br>
&nbsp;&nbsp;&nbsp;&nbsp; directory_object&nbsp;&nbsp;&nbsp; =&gt; 'DBF_DIR',<br>
&nbsp;&nbsp;&nbsp;&nbsp; conversion_extension =&gt; 'windows'<br>
);<br>
END;</span></font><o:p></o:p></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;<o:p></o:p></span></font></p>

<div>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>And the output is </span></font><o:p></o:p
></p>

</div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>BEGIN<br>
*<br>
ERROR at line 1:<br>
ORA-19624 (See ORA-19624.ora-code.com): operation failed, retry possible<br>
ORA-19625 (See ORA-19625.ora-code.com): error identifying file /oracle10/oradata/P2P/P2P/datafile/SCOTT.ORA
<br>
ORA-27047 (See ORA-27047.ora-code.com): unable to read the header block of file<br>
Additional information: 2<br>
ORA-06512 (See ORA-06512.ora-code.com): at &quot;SYS.DBMS_STREAMS_TABLESPACE_ADM&quot;, line 2092<br>
ORA-06512 (See ORA-06512.ora-code.com): at line 2</span></font><o:p></o:p></p>

</div>

<blockquote style='margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>

<p class=MsoNormal><font size=2 color=navy face=Tahoma><span style='font-size:
10.0pt;font-family:Tahoma;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>And ideas ?<o:p></o:p></span></font></p>

</blockquote>

</div>

</body>

</html>

<table><tr><td bgcolor=#ffffff><font color=#000000>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. <br>
If you have received this email in error, please notify us immediately by
replying to the message and deleting it from your computer.<br>
</font></td></tr></table>