OTN Discussion Forums : PLS-00302: component 'SET_NO

Reply to this Thread

Search Forum

Back to Thread List

Replies: 11 - Pages: 1 - Last Post: Jan 5, 2010 11:32 AM Last Post By: Anantha R

petermonica

Posts: 173
Registered: 04/17/02

PLS-00302: component 'SET_NO_OUTLINES' must be declared on EXP
Posted: Aug 9, 2005 3:14 AM

Hey all,
Not sure why I'm getting this. Any ideas where to start?

C:\>exp userid=me/me@mine owner=me file=c:\temp\me.dmp
 
Export: Release 10.2.0.1.0 - Production on Tue Aug 9 11:14:00 2005
 
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
 
C:\>sqlplus me/me@mine
 
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 9 11:16:02 2005
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Jens Petersen

Posts: 4,745
Registered: 05/13/99

Re: PLS-00302: component 'SET_NO_OUTLINES' must be declared on EXP
Posted: Aug 9, 2005 3:43 AM

in response to: petermonica

Why don't you use 10g R1 exp utility to export from a 10 R1 database?

Export: Release 10.2.0.1.0 - Production on Tue Aug 9

Connected to:
Oracle Database 10g Enterprise Edition Release
10.1.0.4.0 - 64bit Production

petermonica

Posts: 173
Registered: 04/17/02

Re: PLS-00302: component 'SET_NO_OUTLINES' must be declared on EXP
Posted: Aug 9, 2005 4:04 AM

in response to: Jens Petersen

I've got 10gR2 client on my machine. I was unaware that there were compatability issues, as I've been able in the past to export and import to and from 9i with a 10g utility, and to and from 10g with a 9i utility. Are there known compatibility issues?

rlister

Posts: 2
Registered: 03/17/98

Re: PLS-00302: component 'SET_NO_OUTLINES' must be declared on EXP
Posted: Sep 16, 2005 12:24 PM

in response to: petermonica

This is to bump the thread. We recently migrated from 9i to 10g and we have the same problem with EXP.

DB: 10.1.0.2.0 (on MS Windows)

Client: 10.2.0.1.0 (on MS Windows)

Jens Petersen

Posts: 4,745
Registered: 05/13/99

Re: PLS-00302: component 'SET_NO_OUTLINES' must be declared on EXP
Posted: Sep 16, 2005 12:33 PM

in response to: rlister

Still the same rules:

1. Export the data with the Export utility of the lowest database version involved.

2. Import the data with the Import utility of the target database.

vetervgolove

Posts: 4
Registered: 02/14/06

Re: PLS-00302: component 'SET_NO_OUTLINES' must be declared on EXP
Posted: Jul 31, 2006 6:44 AM

in response to: Jens Petersen

Hi !

I met the same problem with "SET_NO_OUTLINES".

If Your versions of IMP/EXP utilities satisfy following rules:
1. Export the data with the Export utility of the lowest database version involved.
2. Import the data with the Import utility of the target database.

CHECK ALSO that db_block parameters of both databases are same !!!

If its not - add RECORDLENGTH= parameter for EXP and IMP with value of target database.

Sergey

abhi.deshpande

Posts: 2
Registered: 01/08/02

Re: PLS-00302: component 'SET_NO_OUTLINES' must be declared on EXP
Posted: Aug 22, 2008 1:51 PM

in response to: vetervgolove

Please check if you are using correct vesion of import / export utility.

ayubfkhan

Posts: 4
Registered: 08/31/00

Re: PLS-00302: component 'SET_NO_OUTLINES' must be declared on EXP
Posted: Jul 17, 2009 2:27 PM

in response to: abhi.deshpande

The reason why you are getting this error is: You have installed Oracle 10g or 11g on the same machine where 9i is installed.

Now You are trying to access 9i export from 10g/11g home.

Solutions is

Go to 9i Oracle Home and run the same command.

1. cd D:\oracle\ora92\bin

2. D:\ exp hr/hr file=c:\myfile.dmp owner=hr

3. to import this schema in 11g/10g database go to different directory

4. C:\ imp scott/tiger file=c:\myfile.dmp fromuser = hr touser= scott

Hope this helps
Ayub

oradba_76

Posts: 66
Registered: 06/06/08

Re: PLS-00302: component 'SET_NO_OUTLINES' must be declared on EXP
Posted: Jul 17, 2009 6:31 PM

in response to: petermonica

Change the order of $ORACLE_HOMEXXX\bin in enviroment variable PATH. Put first the home of 0racle 9i

user1160380

Posts: 2
Registered: 10/14/09

Re: PLS-00302: component 'SET_NO_OUTLINES' must be declared on EXP
Posted: Oct 21, 2009 6:45 AM

in response to: oradba_76

Yes, It is true that if we have two oracle homes we encounter such issue.We need to select the right oracle home and the fire the import .

Regards,
Vish Deepak

user3112517

Posts: 1
Registered: 01/05/10

Re: PLS-00302: component 'SET_NO_OUTLINES' must be declared on EXP
Posted: Jan 5, 2010 11:28 AM

in response to: user1160380

Some of the answers are not very clear. I have a situation: Databases 9i. Desktops (2) client 10g. Two situations, one desktop is MS XP, the other MS Vista. There is no problems with EXP from the XP client while the Vista client errors with 'Set_No_Outlines'. The only difference is in the Windows versions of the client desktops. Anyone has similar experiences? Thanks.

Anantha R

Posts: 3,033
Registered: 08/02/07

Re: PLS-00302: component 'SET_NO_OUTLINES' must be declared on EXP
Posted: Jan 5, 2010 11:32 AM

in response to: user3112517

I think you're trying to export using 10g exp utility into a 9i database. Use 9i exp utility instead.

You have to use lower version of export utility for source and target databases.

HTH
-Anantha

Pages: 1

Back to Thread List

Legend
	Guru : 2500 - 1000000 pts
	Expert : 1000 - 2499 pts
	Pro : 500 - 999 pts
	Journeyman : 200 - 499 pts
	Newbie : 0 - 199 pts
	Oracle ACE Director
	Oracle ACE Member
	Oracle Employee ACE
	Helpful Answer (5 pts)
	Correct Answer (10 pts)