thanks to all for your reply
when i try to compile i got this error
SQL> alter view USER_2.VUE_JDD compile;
Warning: View altered with compilation errors.
in fact this user(USER_2) is a user that owns only views and synonyms on another schema( USER_1) that owns all tables
when i make import , the USER_2 is first import and then USER_1 . that
s why i got a warning when making import :
IMP-00041: Warning: object created with compilation warnings
i though if i compile these all of views , it will be ok but i got this
warning : View altered with compilation errors.
i think the best way is maybe to drop the USER_2 and re-import again
any advice is wellcom
thanks again
david..
Hans.[Email address protected]
06/10/2006 15:21
Pour : DAVID.[Email address protected]
cc :
Objet : RE: compile view...
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
SQL> set lines 130 pages 999
SQL> spool comp_my_views
SQL> select 'alter view '||owner||'.'||view_name||' compile;' from
dba_views where owner = 'XXXX';
SQL> spool off
SQL> [Email address protected]
Hans
-----Original Message-----
From: David NGUYEN
[Email address protected]
Sent: vrijdag 6 oktober 2006 15:17
To: LazyDBA Discussion
Subject: compile view...
hi experts
is there a way to compile all views of a schema ..? or i have to compile
view by view..? what is the query for that..?
thanks in advance.
david..
(See attached file: C.htm)
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.
Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------
(See attached file: C.htm)
Oracle LazyDBA home page