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
Is This Answer Correct ? | 39 Yes | 16 No |
Post New Answer View All Answers
How to execute the package in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to define a data field as not null?
How to sort output in descending order in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
How many data types are supported?
What do you mean by merge in oracle?
Is oracle a language?
Explain what are clusters?
What is the difference between a user and a schema in oracle?
How to invoke the data pump export utility?
How to connect ms access to oracle servers?
How to connect asp pages to oracle servers?
What are the uses of a database trigger?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.