Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help: Can't drop table! (REPOST)

Re: Help: Can't drop table! (REPOST)

From: FredM <fredmotta_at_centurytel.net>
Date: Mon, 21 Jan 2002 08:10:42 -0800
Message-ID: <A4X28.20401$Xs4.4170140@feed.centurytel.net> 





I'm new at this but I would think that this should be pretty straight
forward.  The 'USER_DEPENDENCIES, ALL_DEPENDENCIES, and DBA_DEPENDENCIES
views don't have any reference to the tables I'm trying to drop.



Attached is the html report showing dependencies for one of the tables.  If
you can help, please post a suggestion.  I'll keep tyring.  Thanks.



"Fergus" <sinhask_at_swbell.net> wrote in message
news:csr28.8175$st7.3097491523_at_newssvr30.news.prodigy.com...


> As Daniel Morgan proposed below - see if there are any dependencies on

> the table being drop - if there is one or more - ORACLE will not let you

> drop the table - irrespective of grants.

>

> "FredM" <fredmotta_at_centurytel.net> wrote in message

> news:GQp28.20196$Xs4.4015748_at_feed.centurytel.net...

> > I finished granting in these tables to DBA role and a special user, but

> > still get the same error message.  There must be something wrong if SYS

> can

> > create a table but not drop it.

> > Any help is appreaciated.  Thanks.

> >

> > Fred***

> >

> >

> > >Look in the data dictionary view USER_DEPENDENCIES, ALL_DEPENDENCIES,

or


> > >DBA_DEPENDENCIES.


> >

> > >Daniel Morgan

> >

> >

> >

> > >>FredM wrote:

> >

> > >> I'm getting this error when trying to drop a table:

> > >>

> > >> ORA-00604: error occurred at recursive SQL level 1

> > >> ORA-04052: error occurred when looking up remote object

> > >>

> > >> Someone here mentioned having the same problem, but didn't post a fix

> > >> (something about missing components and rebuilding??).

> >

> >

> >

>

>








begin 666 SYS.AADELTEME1_DEPENDENCY_REPORT.html
M/$A434P^#0H\2$5!1#X-"CQ-151!(&AT=' M97%U:78](D-O;G1E;G0M5'EP
M92(@8V]N=&5N=#TB=&5X="]H=&UL(CX-"CQ4251,13X_at_1&5P96YD96YT(&%N
M9"!$97!E;F1E;F-Y(')E<&]R="!O9B!365,N04%$14Q414U%,3PO5$E43$4^
M#0H\+TA%040^#0H\0D]$62!"1T-/3$]2/2)W:&ET92(^#0H\24U'(&%L:6=N
M/71O<"!H96EG:'0]-S(@<W)C/2)O96TN9VEF(B!W:61T:#TS,C ^/$)2($-,
M14%2/2)!3$PB/@T*/%1!0DQ%(&)O<F1E<CTP(&-E;&Q0861D:6YG/3 @8V5L
M;%-P86-I;F<],"!W:61T:#TB,3 P)2(^/%12/@T*/%12/@T*(" \5$0_at_86QI
M9VX](FQE9G0B(&)G0V]L;W(](S,S-C8V-B!H96EG:'0],C$@=D%L:6=N/2)T

M;W B('=I9'1H/3D^/$E-1R!H96EG:'0],2!S<F,](G-P86-E+F=I9B(@=VED
M=&@],3X\+U1$/@T*(" \5$0_at_86QI9VX](FQE9G0B(&)G0V]L;W(](S,S-C8V

M-B!H96EG:'0],C$@=D%L:6=N/2)T;W B('=I9'1H/3(P/CQ$258_at_86QI9VX]
M;&5F=#X\24U'(&AE:6=H=#TQ('-R8STB<W!A8V4N9VEF(B!W:61T:#TQ/CPO
M1$E6/CPO5$0^#0H@(#Q41"!B9T-O;&]R/2,S,S8V-C8@:&5I9VAT/3(Q('=I

M9'1H/3<S.#X\1$E6(&%L:6=N/2)L969T(CX\1D].5"!C;VQO<CTC9F9F9F9F
M(&9A8V4](D%R:6%L+"!(96QV971I8V$L('-A;G,M<V5R:68B(&-O;&]R/2-F
M9F9F9F8@<VEZ93TB*S(B/CQ"/D1E<&5N9&5N="!A;F0_at_1&5P96YD96YC>2!R
M97!O<G0@;V8_at_4UE3+D%!1$5,5$5-13$\+T(^/"]&3TY4/CPO1$E6/CPO5$0^
M#0H@(#Q41"!B9T-O;&]R/2,S,S8V-C8@:&5I9VAT/3(Q('=I9'1H/3$U,#X\


M1$E6(&%L:6=N/2)R:6=H="(^/$9/3E0_at_8V]L;W(](V9F9F9F9B!F86-E/2)!
M<FEA;"P_at_2&5L=F5T:6-A+"!S86YS+7-E<FEF(B!C;VQO<CTC9F9F9F9F/CQ"
M/B9N8G-P.SPO0CX\+T9/3E0^/"]$258^/"]41#X-"B @/%1$(&%L:6=N/2)L


M969T(B!B86-K9W)O=6YD/2)R:'-H861O=RYG:68B('9!;&EG;CTB=&]P(B!W

M:61T:#TU/CQ)34<@:&5I9VAT/3$@<W)C/2)3<&%C92YG:68B('=I9'1H/3<^
M/$1)5B!A;&EG;CUL969T/CQ)34<@:&5I9VAT/3$@<W)C/2)S<&%C92YG:68B
M('=I9'1H/3$^/"]$258^/"]41#X-"CPO5%(^/%12/@T*(" \5$0_at_86QI9VX]

M(FQE9G0B(&)G0V]L;W(](S,S-C8V-B!H96EG:'0],38@=D%L:6=N/71O<"!W
M:61T:#TY(#X\24U'(&AE:6=H=#TQ('-R8STB<W!A8V4N9VEF(B!W:61T:#TQ
M/CPO5$0^#0H@(#Q41"!A;&EG;CTB;&5F="(@8F=#;VQO<CTC,S,V-C8V(&AE
M:6=H=#TQ-B!V06QI9VX]=&]P('=I9'1H/3$Q/CQ)34<@:&5I9VAT/3$@<W)C
M/2)S<&%C92YG:68B('=I9'1H/3$^/"]41#X-"B @/%1$(&%L:6=N/2)L969T
M(B!B86-K9W)O=6YD/2)B;W0N9VEF(B!B9T-O;&]R/2-F9F9F9F8@:&5I9VAT


M/3$V('9!;&EG;CUT;W @=VED=&@]-S P(&-O;'-P86X],CX\1$E6(&%L:6=N
M/6QE9G0^/$E-1R!A;&EG;CUT;W @:&5I9VAT/3$V('-R8STB=&]P87)C:"YG
M:68B('=I9'1H/3(V/CPO1$E6/CPO5$0^#0H@(#Q41"!A;&EG;CTB<FEG:'0B


M(&AE:6=H=#TQ-B!V06QI9VX](G1O<"(@=VED=&@]-3X\1$E6(&%L:6=N/2)L
M969T(CX\24U'(&AE:6=H=#TX('-R8STB<F5N9"YG:68B('=I9'1H/3@^/"]$
M258^/"]41#X-"CPO5%(^/%12/@T*(" \5$0_at_86QI9VX](FQE9G0B(&AE:6=H


M=#TX('9!;&EG;CTB=&]P(B!W:61T:#TY/CQ$258_at_86QI9VX]<FEG:'0^/$E-
M1R!H96EG:'0]."!S<F,](FQE;F0N9VEF(B!W:61T:#TQ,#X\+T1)5CX\+U1$
M/@T*(" \5$0_at_86QI9VX](FQE9G0B(&)A8VMG<F]U;F0](F)O="YG:68B(&AE


M:6=H=#TX('9!;&EG;CUT;W @=VED=&@],3$^/$1)5B!A;&EG;CUR:6=H=#X\

M24U'(&AE:6=H=#TQ('-R8STB<W!A8V4N9VEF(B!W:61T:#TQ/CPO1$E6/CPO

M5$0^#0H@(#Q41"!A;&EG;CTB;&5F="(@8F=#;VQO<CTC9F9F9F9F(&AE:6=H
M=#TX('9!;&EG;CUT;W @=VED=&@]-S P(&-O;'-P86X],CX\24U'(&AE:6=H
M=#TX('-R8STB87)C:&-O<FXN9VEF(B!W:61T:#TV/CPO5$0^#0H@(#Q41"!A


M;&EG;CTB<FEG:'0B(&AE:6=H=#TX('9!;&EG;CUT;W @=VED=&@]-3X\24U'
M(&AE:6=H=#TQ('-R8STB<W!A8V4N9VEF(B!W:61T:#TQ/CPO5$0^#0H\+U12
M/CPO5$%"3$4^/% ^#0H\5$%"3$4_at_8F]R9&5R/3 @8V5L;%!A9&1I;F<],"!C
M96QL4W!A8VEN9STP('=I9'1H/2(Q,# E(CX-"CQ40D]$63X-"CQ44CX-"CQ4

M1"!W:61T:#TB,R4B/B9N8G-P.SPO5$0^#0H\5$0_at_86QI9VX]<FEG:'0@=D%L
M:6=N/71O<"!W:61T:#TB.3<E(CX-"CQ0/CQF;VYT(&9A8V4](D%R:6%L+"!(
M96QV971I8V$L('-A;G,M<V5R:68B(&-O;&]R/2(C,S,V-CDY(CX\8CX\9F]N
M="!S:7IE/2(R(CY$871A8F%S93I63UE!1T52/"]F;VYT/CPO8CX\+V9O;G0^

M/"]0/CPO5$0^/"]44CX-"CQ44CX-"CQ41"!W:61T:#TB,R4B/B9N8G-P.SPO

M5$0^#0H\5$0_at_86QI9VX]<FEG:'0@=D%L:6=N/71O<"!W:61T:#TB.3<E(CXM"
CQ0/CQF;VYT(&9A8V4](D%R:6%L+"!(96QV971I8V$L('-A;G,M<V5R:68B

M(&-O;&]R/2(C,S,V-CDY(CX\8CX\9F]N="!S:7IE/2(R(CY$871E.DIA;G5A
M<GD@,C L(#(P,#(@-#HP-#HQ."!033PO9F]N=#X\+V(^/"]F;VYT/CPO4#X\
M+U1$/CPO5%(^#0H\5%(^#0H\5$0@:&5I9VAT/3$@=VED=&@](C,E(CX\24U'


M(&AE:6=H=#TQ('-R8STB4W!A8V4N9VEF(B!W:61T:#TQ/CPO5$0^#0H\5$0@

M8F%C:V=R;W5N9#US97!E<F%T;W(N9VEF(&AE:6=H=#TQ('=I9'1H/2(Y-R4B

M/CQ)34<@:&5I9VAT/3$-"G-R8STB4W!A8V4N9VEF(B!W:61T:#TQ/CPO5$0^
M/"]44CX\+U1"3T19/CPO5$%"3$4^#0H\4#X-"CQ!($A2148](B,Q(CX\1$0^
M1&5P96YD96YC:65S/"]A/@T*/$$@2%)%1CTB(S(B/CQ$1#Y$97!E;F1E;G1S


M/"]A/@T*/$$@3D%-13TB,2(^/"]!/@T*/$@R/B \1D].5"!#3TQ/4CTB(S,S

M-C8Y.2(^1&5P96YD96YC:65S("T_at_3G5M8F5R(&]F(&1E<&5N9&5N8VEE<R!F
M;W5N9"!I<R Z-CPO1D].5#X\+T_at_R/@T*/%1!0DQ%($)/4D1%4B @0T5,3%!!
M1$1)3D<],CX-"CQ42"!"1T-/3$]2/2-C8V-C.3D@/CQ"/CQ&3TY4($9!0T4]
M(D%224%,(B!#3TQ/4CTB(S,S-C8Y.2(@4TE:13TR/D]B:F5C="!.86UE/"]"

M/CPO1D].5#X\+U1(/@T*/%1(($)'0T],3U(](V-C8V,Y.2 ^/$(^/$9/3E0@

M1D%#13TB05))04PB($-/3$]2/2(C,S,V-CDY(B!325I%/3(^3V)J96-T(%1Y

M<&4\+T(^/"]&3TY4/CPO5$@^#0H-"CQ44CX-"CQ41"!"1T-/3$]2/2-F-V8W
M93<^/$9/3E0_at_1D%#13TB05))04PB(%-)6D4],CY365-414T\+T9/3E0^/"]4
M1#X-"CQ41"!"1T-/3$]2/2-F-V8W93<^/$9/3E0_at_1D%#13TB05))04PB(%-)
M6D4],CY404),15-004-%/"]&3TY4/CPO5$0^#0H\+U12/@T*/%12/@T*/%1$

M($)'0T],3U(](V8W9C=E-SX\1D].5"!&04-%/2)!4DE!3"(@4TE:13TR/E-9
M4SPO1D].5#X\+U1$/@T*/%1$($)'0T],3U(](V8W9C=E-SX\1D].5"!&04-%

M/2)!4DE!3"(@4TE:13TR/E5315(\+T9/3E0^/"]41#X-"CPO5%(^#0H\5%(^

M#0H\5$0_at_0D=#3TQ/4CTC9C=F-V4W/CQ&3TY4($9!0T4](D%224%,(B!325I%

M/3(^1#I<3U)!5D]97$]2041!5$%<5D]904=%4EQ365-414TP,2Y$0D8\+T9/
M3E0^/"]41#X-"CQ41"!"1T-/3$]2/2-F-V8W93<^/$9/3E0_at_1D%#13TB05))
M04PB(%-)6D4],CY$051!1DE,13PO1D].5#X\+U1$/@T*/"]44CX-"CQ44CXM"

CQ41"!"1T-/3$]2/2-F-V8W93<^/$9/3E0_at_1D%#13TB05))04PB(%-)6D4]
M,CY$149!54Q4/"]&3TY4/CPO5$0^#0H\5$0_at_0D=#3TQ/4CTC9C=F-V4W/CQ&

M3TY4($9!0T4](D%224%,(B!325I%/3(^4%)/1DE,13PO1D].5#X\+U1$/@T*

M/"]44CX-"CQ44CX-"CQ41"!"1T-/3$]2/2-F-V8W93<^/$9/3E0_at_1D%#13TB
M05))04PB(%-)6D4],CY414U0/"]&3TY4/CPO5$0^#0H\5$0_at_0D=#3TQ/4CTC
M9C=F-V4W/CQ&3TY4($9!0T4](D%224%,(B!325I%/3(^5$%"3$534$%#13PO
M1D].5#X\+U1$/@T*/"]44CX-"CQ44CX-"CQ41"!"1T-/3$]2/2-F-V8W93<^


M/$9/3E0_at_1D%#13TB05))04PB(%-)6D4],CY$.EQ/4D%63UE<3U)!1$%405Q6
M3UE!1T527%1%35 P,2Y$0D8\+T9/3E0^/"]41#X-"CQ41"!"1T-/3$]2/2-F
M-V8W93<^/$9/3E0_at_1D%#13TB05))04PB(%-)6D4],CY$051!1DE,13PO1D].
M5#X\+U1$/@T*/"]44CX-"CPO5$%"3$4^#0H\02!.04U%/2(R(CX\+T$^#0H\

M2#(^(#Q&3TY4($-/3$]2/2(C,S,V-CDY(CY$97!E;F1E;G1S("T_at_3G5M8F5R

M(&]F(&1E<&5N9&5N=',@9F]U;F0@:7,@.C$\+T9/3E0^/"](,CX-"CQ404),
M12!"3U)$15(@($-%3$Q0041$24Y'/3(^#0H\5$@@0D=#3TQ/4CTC8V-C8SDY

M(#X\0CX\1D].5"!&04-%/2)!4DE!3"(@0T],3U(](B,S,S8V.3DB(%-)6D4]
M,CY/8FIE8W0_at_3F%M93PO0CX\+T9/3E0^/"]42#X-"CQ42"!"1T-/3$]2/2-C

M8V-C.3D@/CQ"/CQ&3TY4($9!0T4](D%224%,(B!#3TQ/4CTB(S,S-C8Y.2(@

M4TE:13TR/D]B:F5C="!4>7!E/"]"/CPO1D].5#X\+U1(/@T*#0H\5%(^#0H\

M5$0_at_0D=#3TQ/4CTC9C=F-V4W/CQ&3TY4($9!0T4](D%224%,(B!325I%/3(^

M)FYB<W [/"]&3TY4/CPO5$0^#0H\5$0_at_0D=#3TQ/4CTC9C=F-V4W/CQ&3TY4
M($9!0T4](D%224%,(B!325I%/3(^)FYB<W [/"]&3TY4/CPO5$0^#0H\+U12
M/@T*/"]404),13X-"CQ404),12!B;W)D97(],"!C96QL4&%D9&EN9STP(&-E

M;&Q3<&%C:6YG/3 @=VED=&@](C$P,"4B/@T*/%12/@T*(" \5$0_at_8F%C:V=R
M;W5N9#TB<W!A8V4N9VEF(B!A;&EG;CTB;&5F="(@=D%L:6=N/2)B;W1T;VTB

M('=I9'1H/3_at_R-SX\24U'(&AE:6=H=#TQ('-R8STB<W!A8V4N9VEF(B!W:61T
M:#TQ/CPO5$0^#0H@(#Q41"!B86-K9W)O=6YD/2)S<&%C92YG:68B(&%L:6=N
M/2)L969T(B!V06QI9VX](G1O<"(@=VED=&@]-C ^/$1)5B!A;&EG;CUR:6=H


M=#X\24U'(&AE:6=H=#TQ."!S<F,](F)T86EL=&]P+F=I9B(@=VED=&@]-#4^

M/"]$258^/"]41#X-"B @/%1$(&%L:6=N/2)L969T(B!B86-K9W)O=6YD/2)R
M:'-H861O=RYG:68B(&AE:6=H=#TQ."!V06QI9VX]8V5N=&5R('=I9'1H/34^
M/$E-1R!H96EG:'0],2!S<F,](G-P86-E+F=I9B(@=VED=&@],3X\+U1$/@T*


M/"]44CX-"CQ44CX-"B @/%1$(&%L:6=N/2)L969T(B!B9T-O;&]R/2,S,S8V

M-C8@:&5I9VAT/3$U('9!;&EG;CTB8V5N=&5R(B!W:61T:#TX,C<^/$E-1R!H
M96EG:'0],2!S<F,](G-P86-E+F=I9B(@=VED=&@],3X\+U1$/@T*(" \5$0@
M86QI9VX](FQE9G0B(&)G0V]L;W(](S,S-C8V-B!H96EG:'0],34@=D%L:6=N


M/2)C96YT97(B('=I9'1H/38P/CQ)34<@:&5I9VAT/3$@<W)C/2)S<&%C92YG
M:68B('=I9'1H/3$^/"]41#X-"B @/%1$(&%L:6=N/2)L969T(B!B86-K9W)O

M=6YD/2)R:'-H861O=RYG:68B(&AE:6=H=#TQ-2!V06QI9VX]8V5N=&5R('=I
M9'1H/34^/$E-1R!H96EG:'0],2!S<F,](G-P86-E+F=I9B(@=VED=&@],3X\
M+U1$/@T*/"]44CX-"CQ44CX-"B @/%1$(&%L:6=N/2)L969T(B!B86-K9W)O
M=6YD/2)B;W0N9VEF(B!V06QI9VX](G1O<"(@=VED=&@].#(W/CQ)34<@:&5I
M9VAT/3@@<W)C/2)L96YD+F=I9B(@=VED=&@],3 ^/"]41#X-"B @/%1$(&%L
M:6=N/2)L969T(B!B86-K9W)O=6YD/2)B;W0N9VEF(B!H96EG:'0],3 @=D%L
M:6=N/71O<"!W:61T:#TV,#XF;F)S<#L\+U1$/@T*(" \5$0_at_86QI9VX](FQE


M9G0B('9!;&EG;CTB=&]P(B!W:61T:#TU/CQ)34<@:&5I9VAT/3$P('-R8STB
M<F5N9"YG:68B/CPO5$0^#0H\+U12/@T*/"]404),13X-"CPO0D]$63X-"CPO
'2%1-3#X-"@``


`


end
Received on Mon Jan 21 2002 - 10:10:42 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US