Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: help on view constraint and plsql scripts
deb,
I think you have to recreate the view using the
clause CREATE OR REPLACE VIEW.
By using OR REPLACE all grants and privs get preserved.
Of course you will have to specify the whole clause when recreating the view.
Regards
Dante
In article <Zyp_2.31326$134.345469_at_tor-nn1.netcom.ca>,
"deb" <dnanda_at_netcom.ca> wrote:
> 1) I tried to drop the constraint from a view with the check
option but
> could
> not do so...
> The command that I used was :
>
> Alter view s_r
> drop constraint c_ck;
>
> 2) The other thing that I wanted to know was how do we create
scripts..do
> we create them in sqlplus editor especially the ones
containing 'ACCEPT' and
> 'PROMPT'commands ...cause when we do not use the editor the accept and
> prompt commands immediately ask us for the value and do not let us
complete
> the script...I hope I am clear...
>
> thanks/
>
>
--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 13 1999 - 06:07:35 CDT