Answer Posted / md sajjad

No We cannot create index on view:
e.g
1* create view emp_view as select * from emp where
deptno=20
SQL> /

View created.


1* create index indx_emp on emp_view(empno)
SQL> /
create index indx_emp on emp_view(empno)
*
ERROR at line 1:
ORA-01702: a view is not appropriate here

How to do clean up if create database failed?

1022

---

What is Data Dictionary Cache in Oracle?

1160

---

What is data type in oracle?

1111

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1037

---

What privilege is needed for a user to create views in oracle?

1036

---

What is an Oracle index?

1647

---

How to set a transaction to be read only in oracle?

1089

---

What are the common oracle dba tasks?

1137

---

material view and view disadvantages?

1057

---

How many types of tables are there in oracle?

1053

---

Define oracle database

1039

---

How different is ms access and oracle?

1032

---

Is oracle a language?

934

---

What is a cognitive schema?

957

---

is there a tool to trace queries, like profiler for sql server?

1137

---