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
How can we find out the duplicate values in an oracle table?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What language does oracle use?
Explain the use of compress option in exp command.
How can we create the complete backup of data in the oracle.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is set verify off in oracle?
what are the default admin accounts in Oracle 10g ?
What is a schema in oracle?
Explain temporal data types in oracle
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is private procedure oracle?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What do you mean by cdb and pdb in oracle 12c?
