| Export error in log [message #259115] |
Tue, 14 August 2007 07:56  |
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
|
Senior Member |
|
|
Hello sir
When i was run the export script the following error would occur
in export log.
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
help i need your valuable suggestion.
-Thanx
[Updated on: Wed, 15 August 2007 07:53] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
| Re: Export error in log [message #259289 is a reply to message #259115] |
Tue, 14 August 2007 23:17  |
kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore
|
Member |
|
|
Hi Vasu,
It is because if you try to export from 10g to 9i, these error will occurs.
It is nothing but the compatability error.
So, you have to export within the 9i server and import it on the 10g server.
Regards
Magesh
|
|
|
|
|
|
| Re: Export error in log [message #259785 is a reply to message #259294] |
Thu, 16 August 2007 09:05 |
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
|
Senior Member |
|
|
Thanx for all reply
I am really confused i dont know how it is possible when 9i and 10g are in same oracle server.
The server shows below information:
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 16 09:58:52 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
Please anybody give good solution for this, the export always failed.
-Thanx.
|
|
|
|
|
|
| Re: Export error in log [message #259799 is a reply to message #259790] |
Thu, 16 August 2007 09:29 |
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
|
Senior Member |
|
|
Thank u sir
Hello sir
Please can you explain me what is binary export
Actually i have used the following script command to export the datas.
>exp $login file=$expfile log=$logfile filesize=2048M statistics=none full=y
-Thanx
|
|
|
|
|
|
| Re: Export error in log [message #259835 is a reply to message #259805] |
Thu, 16 August 2007 11:36 |
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
|
Senior Member |
|
|
I have used the below export command for 9i i dont know difference between 9i export command and 10g export command
if 10g have any new export command means please help me.
9i server command:
>exp $login file=$expfile log=$logfile filesize=2048M statistics=none full=y
-Thanx
|
|
|
|
|
|
|
|
| Re: Export error in log [message #259898 is a reply to message #259843] |
Thu, 16 August 2007 15:12 |
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
|
Senior Member |
|
|
Hello sir
Its shows the same error for oraenv HOME also
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
ORA-06550: line 1, column 41:
ORA-06550: line 1, column 15:
If there is any option please inform me.
-Thanx
|
|
|
|
|
|
|
|
|
|
| Re: Export error in log [message #260635 is a reply to message #259115] |
Mon, 20 August 2007 09:39 |
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
|
Senior Member |
|
|
sir
It shows the following below error
[oracle@sadb 9.2.0]$ exp system/best@best file=exp.dmp log=testexp filesize=2048m statistics=none full=y
Export: Release 10.2.0.1.0 - Production on Mon Aug 20 10:35:13 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
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
[oracle@sadb 9.2.0]$
-Thanx
|
|
|
|
|
|
| Re: Export error in log [message #260663 is a reply to message #260636] |
Mon, 20 August 2007 11:29 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | [oracle@sadb 9.2.0]$ exp system/best@best file=exp.dmp log=testexp filesize=2048m statistics=none full=y
|
9i
| Quote: | Export: Release 10.2.0.1.0 - Production on Mon Aug 20 10:35:13 2007
|
10g
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
