Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / itishree chhotray
View should be Schema binding,before creating index on view.
We can create Unique Clustered index on view after that we
can create non clustered index but we should have at least
one unique clustered index on view.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a static data dictionary in oracle?
What are oracle functions?
Can we use bind variables in oracle stored procedure?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Explain an index segment?
How to write an inner join with the where clause in oracle?
Why do you use stored procedures and state some of its disadvantages?
what are the default admin accounts in Oracle 10g ?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How to get a create statement for an existing table?
What is the data type of dual table?
How to synchronize 2 schema's objects?
What is the scope of a local variable?
How a tablespace is related to data files?
Whether any commands are used for months calculation? If so, what are they?
