Search: For:
Browsing Single Category
www.dbatoolz.com ORACLE DBA Forums Forum › Topic Id: 2510 | Permalink

While Export one of our DB I've got the error

Topic ID: 2510
Created By: 2007-JUL-25 00:05:33 [Dba_Giri]
Updated By: 2007-JUL-25 09:11:04 [Vitaliy]
Status: Open
Severity: Normal
Read Only: No
8021
2007-JUL-25 00:05:33
User
 
 
Registered On: Jul 2007
Total Posts: 7
Hi..,
while
trying to Export one of our database I've got the following error:

EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 41:
PLS-00302: component 'SET_NO_OUTLINES' must be
declared
ORA-06550: line 1, column 15:
PL/SQL: Statement ignored
EXP-00000: Export terminated unsuccessfully

The Database Version is "10.1.0.3.0 and it is on Linux
OS", 
but am trying to export using the "export utility
Release 10.2.0.1.0"(which is on my local machine
Windows OS)
Is the problem might be the version change related, if
it is true, if I want to download the 10.1.0.3.0
export utility from where can I download it.
8025
2007-JUL-25 08:59:22
Moderator
 
 
Registered On: Mar 2006
Total Posts: 289
> The Database Version is "10.1.0.3.0 and it is on Linux OS", 
> but am trying to export using the "export utility
> Release 10.2.0.1.0"(which is on my local machine
> Windows OS)
> Is the problem might be the version change related, if
> it is true, if I want to download the 10.1.0.3.0
> export utility from where can I download it.

Yes you need to use the same version of export utility - your server is 10gR1 
and you are using an export utility which came with 10gR2 database on your PC - 
that's not going to work unless you upgrade your server's export views or use 
10gR1 version of export utility on your PC.

Here's where you can download ORACLE software:

   http://www.oracle.co...oracle10g/index.html

The problem is that there's no 10.1.0.3 for Windows so your closest bet would 
be to install 10.1.0.2 for Microsoft Windows (32-bit).

I wouldn't do this though ... if I were you I'd just get over to the server 
side (Linux) and run the export from there - it will complete much faster too.

- Vitaliy
[edited by: Vitaliy at 09:11 (CST) on Jul. 25, 2007]