Re: Oracle 7.3.4 exp problem

Just a warning: it seems you are on the way to hell. You should *NEVER EVER* update the datadictionary tables *DIRECTLY* most likely you will leave an inconsistent datadictionary from which even OTS will not be capable to recover you. Officially, you loose support when you do so.
Actually the pointers from Bruno were adequate. You should have
used 'drop '||object_type||' '||owner||'.'||object_name||'; '
from dba_objects where object_name = 'SYS'

In article <39DD428C.9BE3FFA7_at_iii.org.tw>,   llr <llr_at_iii.org.tw> wrote:
> 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'
>
>

Regards

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.