Answer Posted / madhoosapre
An index cannot be defined on a view. Because view is
virtual table, which consists of a subset of columns from
one more tables.
The Restrictions imposed on views are as follows:
1. A view can be created only in the current database.
2. A view can be created only if there is a SELECT
permission on its base table
3. A Trigger or an Index cannot be defined on a view.
4. A view cannot be derive its data from temporary tables.
5. The CREATE VIEW statement cannot be combined with other
SQL statements in a single batch.
| Is This Answer Correct ? | 144 Yes | 67 No |
Post New Answer View All Answers
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How to use "in out" parameter properly?
Explain the use of consistent option in exp command.
What do you understand by a database object?
How to connect ms access to oracle servers?
How can we delete duplicate rows in a table?
What is the maximum limit on the number of columns in a table?
Explain what are the type of synonyms?
How to drop a tablespace?
Explain the use of grant option in imp command.
How to write a query with a right outer join in oracle?
What is a read only transaction in oracle?
How to create a table interactively?
What are the system predefined user roles?
How to declare a local variable?
