problem using SYS.DBMS_STREAMS_TABLESPACE

Links

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 Bobak, Mark

Reply: 1 2

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.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR>
<STYLE>@(protected) {
font-family: Tahoma;
}
@(protected) Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left>Um, does this file
/oracle10/oradata/P2P/P2P/datafile/SCOTT.ORA exist??</DIV>
<DIV dir=ltr align=left> </DIV>
<DIV dir=ltr align=left> </DIV>
<DIV> </DIV>
--
 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." 
<DIV> </DIV> 
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
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 </DIV>
<DIV></DIV>
<DIV class=Section1>
Hi , I wonder if any
succeed to copy tablespace from window (32bit ) to sun
(64bit)<o:p></o:p>
<o:p> </o:p>
We are tring to use
streams (which is very cool ).<o:p></o:p>
<o:p> </o:p>
The command we use is
:<o:p></o:p>
BEGIN  
DBMS_STREAMS_TABLESPACE_ADM     .PULL_SIMPLE_TABLESPACE
(      tablespace_name     =>
'SCOTT',     
database_link       =>
'E2E.MARVEL',      directory_object   
=> 'DBF_DIR',      conversion_extension =>
'windows' ); END;<o:p></o:p>
 <o:p></o:p>
<DIV>
And the output is
<o:p></o:p></DIV>
<o:p> </o:p>
<DIV>
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<o:p></o:p></DIV>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0in">
<o:p> </o:p>
<o:p> </o:p>
And ideas
?<o:p></o:p></BLOCKQUOTE></DIV>
<TABLE>
<TBODY>
<TR>
<TD bgColor=#ffffff>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. </TD></TR></TBODY></TABLE></BODY></HTML>