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
problem using SYS.DBMS_STREAMS_TABLESPACE_ADM

problem using SYS.DBMS_STREAMS_TABLESPACE_ADM

2006-02-09       - By Amihay Gonen

Reply:     1     2  


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



__ ____ ____ ____ ____ ____ ____

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





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)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@(protected)
  {font-family:Tahoma;
  panose-1:2 11 6 4 3 5 4 4 2 4;}
@(protected)
  {font-family:"Century Gothic";
  panose-1:2 11 5 2 2 2 2 2 2 4;}
@(protected)
  {font-family:"Californian FB";
  panose-1:0 0 0 0 0 0 0 0 0 0;}
/* 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;}
p
  {mso-margin-top-alt:auto;
  margin-right:0in;
  mso-margin-bottom-alt:auto;
  margin-left:0in;
  font-size:12.0pt;
  font-family:"Times New Roman";}
span.EmailStyle17
  {mso-style-type:personal;
  font-family:Arial;
  color:windowtext;}
span.EmailStyle18
  {mso-style-type:personal;
  font-family:Arial;
  color:navy;}
span.EmailStyle20
  {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'>Yes . the file pass ok , with the same
size.<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>

<div>

<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>

<hr size=2 width="100%" align=center tabindex=-1>

</span></font></div>

<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Bobak, Mark
[mailto:Mark.Bobak@(protected)] <br>
<b><span style='font-weight:bold'>Sent:</span></b> 09 February 2006 15:10<br>
<b><span style='font-weight:bold'>To:</span></b> Amihay Gonen;
oracle-l@(protected)<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: problem using
SYS.DBMS_STREAMS_TABLESPACE_ADM</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>

<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Um, does this file
/oracle10/oradata/P2P/P2P/datafile/SCOTT.ORA exist??</span></font><o:p></o:p><
/p>

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

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

<div>

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

</div>

<p><b><font size=2 face="Century Gothic"><span style='font-size:10.0pt;
font-family:"Century Gothic";font-weight:bold'><!-- Converted from text/rtf
format -->--</span></font></b>
<br>
<b><font size=2 face="Century Gothic"><span style='font-size:10.0pt;font-family:
"Century Gothic";font-weight:bold'>Mark J. Bobak</span></font></b> <br>
<b><font size=2 face="Century Gothic"><span style='font-size:10.0pt;font-family:
"Century Gothic";font-weight:bold'>Senior Oracle Architect</span></font></b>
<br>
<b><font size=2 color=black face="Century Gothic"><span style='font-size:10.0pt;
font-family:"Century Gothic";color:black;font-weight:bold'>P</span></font></b>
<b><font
size=2 face="Century Gothic"><span style='font-size:10.0pt;font-family:"Century
Gothic";
font-weight:bold'>ro<font color=red><span style='color:red'>Q</span></font>uest
Information &amp; Learning</span></font></b> <o:p></o:p></p>

<p><font size=3 face="Californian FB"><span style='font-size:12.0pt;font-family:
"Californian FB"'>&quot;There are 10 types of people in the world:&nbsp; Those
who understand binary, and those who don't.&quot;</span></font> <o:p></o:p></p>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></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 class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>

<hr size=2 width="100%" align=center tabIndex=-1>

</span></font></div>

<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma>
<span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font
></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Amihay Gonen<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, February 09, 2006
8:09 AM<br>
<b><span style='font-weight:bold'>To:</span></b> oracle-l@(protected)<br>
<b><span style='font-weight:bold'>Subject:</span></b> Q: problem using
SYS.DBMS_STREAMS_TABLESPACE_ADM</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'>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>

<table class=MsoNormalTable border=0 cellpadding=0>
<tr>
 <td bgcolor=white style='background:white;padding:.75pt .75pt .75pt .75pt'>
 <p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
 style='font-size:12.0pt;color:black'>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.</span></font><o:p
></o:p></p>
 </td>
</tr>
</table>

<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>

</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>