Re: Oracle 7.3.4 exp problem

When I do the following:
1. select owner, object_name, object_type

     from sys.dba_objects where object_name = 'SYS'
     There is an object named SYS and the owner is visit.

2.  select USER#,NAME,TYPE from sys.user$
     I got the result : USER# is 11,  NAME is visit

3. drop the object:

    delete from sys.obj$ where name='SYS and owner#=11

After that, I rerun the exp, but everything still the same. ...
Finally I use the system/manager to do the exp, it succeed. Why? Quit strange?

Lawrence Lu

Bruno Jargot wrote:

> >> llr wrote:
> >> > svr:/users/data> exp data/data file=data.dmp compress=y indexes=y
> >> > log=data.log
> >> >
> >> > Export: Release 7.3.4.0.1 - Production on Tue Oct 3 18:06:51 2000
> >> > Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
> >> > Connected to: Oracle7 Server Release 7.3.4.0.1 - Production
> >> > PL/SQL Release 2.3.4.0.0 - Production
> >> > Export done in ZHT16BIG5 character set
 (...)
> >> > EXP-00008: ORACLE error 6550 encountered
> >> > ORA-06550: line 1, column 25:
> >> > PLS-00302: component 'DBMS_EXPORT_EXTENSION' must be declared
> >> > ORA-06550: line 1, column 8:
> >> > PL/SQL: Statement ignored
>
> You have a object named SYS. You have to drop it.
>
> Do the following :
>
> select owner, object_name, object_type
> from sys.dba_objects
> where object_name = 'SYS'
  Received on Thu Oct 05 2000 - 21:57:31 CDT