Region, DFO | RĂ©gion des Maritimes, MPO
E-Mail: [EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, August 27, 2002 6:49 PM
To: Multiple recipients of list ORACLE-L
Subject:Getting view definitions
I did an import into a database and have one view that is invalid
Also it helps to use create or replace instead of drop and create. First it's
one statement vs two and second it retains any grants.
Dick Goulet
Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 8/27/2002 2:24 PM
Eric
set long 2000
alter view XXX compile;
if this fails, then you can
SQL set long 5000
SQL select * from user_views where ...
SQL select * from user_tab_columns where ...
hth
connor
--- Eric Richmond [EMAIL PROTECTED] wrote: I
did an import into a database and have one view
that is invalid. How can I
:Getting view definitions
I did an import into a database and have one view that is invalid. How
can I
get the definition for the view out of database so that I can drop it and
recreate it?
Might there be any issues with just dropping and recreating it? How do
other
people handle
Eric
set long 2000
select text from user_views where view_name = 'MYVIEW';
There are probably more elegant methods, but this works.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, August 27, 2002 4:49 PM
To: Multiple recipients of list
Usually I try to create the view using a CREATE or REPLACE VIEW option.
This saves me the trouble of dropping the view. If the view is invalid,
right after trying to create the view , issue the command show errors.
(You can get the view definition from the log file.) This will usually
give