Problem to import a file [message #133887] |
Mon, 22 August 2005 10:55 |
Philbzh
Messages: 3 Registered: August 2005
|
Junior Member |
|
|
When I try to import a file to a 10g database, I have this error message (see at the bottom). Anybody knows what it is ?
I'm using Windows 2000 et a 10g Client.
Thanks,
Phil.
D:\Oracle\product\10.2.0\client_1\BIN>imp
Import: Release 10.2.0.1.0 - Production on Mon Aug 22 17:37:05 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Username: euro@prod
Password:
IMP-00058: ORACLE error 6550 encountered
ORA-06550: line 1, column 33:
PLS-00302: component 'SET_NO_OUTLINES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
IMP-00000: Import terminated unsuccessfully
|
|
|
|
|
|
Re: Problem to import a file [message #136461 is a reply to message #135830] |
Thu, 08 September 2005 02:38 |
Wieldop
Messages: 1 Registered: September 2005
|
Junior Member |
|
|
I had the same problem. I was using the imp.exe from the 10.2.0 release (like you did) while the database in which I wanted to import the dump was in fact 10.1.0. So, stick to the imp.exe of 10.1.0 and everthing would be fine.
|
|
|
Re: Problem to import a file [message #145908 is a reply to message #133887] |
Mon, 07 November 2005 11:18 |
cynkaranicolas
Messages: 1 Registered: November 2005 Location: Calgary, Alberta
|
Junior Member |
|
|
I am having the same problem but I am trying to import a dmp file exported using Oracle V08.01.07. I am using the import exe from Oracle V10.2.0.1.0 (and it doesn't matter if I try to import the file to an Oracle 8i, Oracle9i or Oracle10g instance)
Please I need to import our client's db to see what is wrong with our application!
Thanks!!
Cynthia
PS:I get this error message:
IMP-00058: ORACLE error 6550 encountered
ORA-06550: line 1, column 33:
PLS-00302: component 'SET_NO_OUTLINES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
IMP-00000: Import terminated unsuccessfully
|
|
|
|
Re: Problem to import a file [message #151861 is a reply to message #145912] |
Mon, 19 December 2005 08:42 |
fmatz
Messages: 1 Registered: December 2005
|
Junior Member |
|
|
On my XP laptop there is a 9.2 DB and newly a Oracle XE DB.
Then I got this error trying to import into the 9.2. DB.
You must specify the imp of the right DB:
D:\oracle\ora92\bin\imp ...
and it works fine.
Best
Friedhold
|
|
|
Re: Problem to import a file [message #170918 is a reply to message #151861] |
Sat, 06 May 2006 04:07 |
cgosney
Messages: 1 Registered: May 2006
|
Junior Member |
|
|
I also had this problem. Thanks to some of the comments above, I found the fault. For reasons that are too boring to go into I need to have Oracle 9i and 10 on my laptop.
The reason for my error was that the imp.exe command being used was from v10 rather than v9. When I used teh v9 version, all worked fine. C:\Oracle\Ora92\bin\imp.exe.
May help someone.
|
|
|