Re: Chown for Oracle ?? Giving schema objects to other user ?

If your database is running in ARCHIVEMODE then this is a matter of "point-in-time" recovery.
Please let us know in which mode your database run...? to find that "select * from v$database;" as sys or internal.

Peter Gross wrote in message
<910196581.16229.0.nnrp-01.c1edb16f_at_news.demon.co.uk>...
>One of our developers has imported there work into the SYSTEM user by
>mistake. Before realising a number of changes have been made to the objects
>(meaning that I can't just drop and then re-import the objects).
>
>Can anyone suggest how I (selectively) copy the objects from the SYSTEM
user
>to the DEV user ?
>
>I was thinking that CREATE AS might be an option, but surely this wont be
of
>use for the other objects such as synonyms, constraints, indexes, etc.
>
>Any assistance greatfully received.
>
>
>
>

begin 666 Yassir Khogaly.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DMH;V=A;'D[66%S<VER#0I& M3CI987-S:7(@2VAO9V%L>0T*5$E43$4Z4V5N:6]R($]R86-L92!$0D$-"E1% M3#M(3TU%.U9/24-%.BLT-"@P*3$X,2 T-C T,#0R#0I414P[0T5,3#M63TE# M13HK-#0T,3$Y,#8W-S8-"D%$4CM(3TU%.CL[.SM+96YT.SM%;F=L86YD#0I, M04)%3#M(3TU%.T5.0T]$24Y'/5%53U1%1"U04DE.5$%"3$4Z2V5N=#TP1#TP M045N9VQA;F0-"E523#IH='1P.B\O=W=W+FMH;V=A;'DN9G)E97-E<G9E+F-O M+G5K#0I54DPZ:'1T<#HO+W=W=RYA965U+F]R9RYU:PT*14U!24P[4%)%1CM) M3E1%4DY%5#IY87-S:7) :VAO9V%L>2YF<F5E<V5R=F4N8V\N=6L-"E)%5CHQ <.3DX,3$P-%0Q-C0S,#%:#0I%3D0Z5D-!4D0-"@`` `
end Received on Wed Nov 04 1998 - 10:43:02 CST