Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> ** SQL for DDL question
Yes. MV on MV works. Just wanted to know if any issue or risks with it.
Another question :
For getting sql being executed by a session I generally use v$sqlarea.sql_text by joining it with v$session. However, I see that sometimes if a session is doing DDL like create I cannot get the SQL being executed. Is there some other way of getting ddl sql being executed. It is needed specially in case of heavy load and trying to find out what a long running session is doing.
Thanks for help.
"Michael W. Fontana" <m.fontana_at_ntta.com> wrote:
I don't think you can create an MV based upon another MV.
Michael Fontana
Sr. Database Administrator
NTT America
P:214.853.7405
M:214.912.3705
Hi,
NUMBER
A decimal number with up to 38 significant digits.
When I specify DECIMAL in the create table and then look at describe table I see it creates it as NUMBER. On 9i. So is it synonymous or is there something DECIMAL can do that NUMBER cannot or vice versa.
5) I have schema schemaA which has a table tableA, tableB. Another schema schemaB has a view viewA selecting from these tables. There is user userC who needs to select from view viewA. I gave grant on schemaA tables to schemaB with "grant option". Then select on viewA was granted to userC. Did not work. : error :
ORA-01031: insufficient privileges
Then after long struggle I gave select any table select any dictionary to userD. It works with just those two privs. Howver if I grant select on viewA to userC it does not work. STrange.
Please help on any of the above items. Sorry about too many Q. Thanks for help.
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 19 2007 - 20:20:05 CST
![]() |
![]() |