Answer Posted / nishi
Oracle creates the index segment for an index or an index partition when you issue the CREATE INDEX statement. In this statement, you can specify storage parameters for the extents of the index segment and a tablespace in which to create the index segment.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why is oracle used?
Explain do view contain data?
Explain the use of ignore option in imp command.
How to create a new user account in oracle?
Design database draw er diagram for a certain scenario ?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is an oracle database?
Difference between oracle's plus (+) notation and ansi join notation?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Why should I use oracle database?
How many categories of data types?
What is oracle analytical function?
What are the predefined tablespaces in a database?
Explain temporal data types in oracle
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));