开发者

when Import into oracle 10g get error 6550

When I am trying to import a file to a 10g database, an Error message (given below) appears. Anybody can help me with this?

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 terminat开发者_运维百科ed unsuccessfully


Looks like it is a mismatch between the IMP version and database version. If you use the imp that is in the same oracle bin directory as the oracle executable, you may have better luck. That may mean copying the file to the database server.


I HAVE SIMILAR SITUATION .

But in my case we used to have oracle 9i and we used to use bat files to import data(database) due to client requirements we were asked to upgrade to 11gr2 and we did with no problem but when am trying to build a database from other client(we have all databases hosted on same server) i encountered

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

little bit of googling i found out as i have two oracle homes. i have to check environmental variables , you can check tat

To view or change environment variables: Right-click My Computer, and then click Properties. Click the Advanced tab. Click Environment variables. Click one the following options, for either a user or a system variable: Click New to add a new variable name and value. Click an existing variable, and then click Edit to change its name or value. Click an existing variable, and then click Delete to remove it.

i found out in the PATH section 11g home was before the 9i home path . i just copied the path of 9i home which looks like C:\oracle\ora92\bin and pasted infront of 11g home path and my import command worked.

this may be one of the solutions,

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜