Answer Posted / sachin
we can switch from init.ora file to a sp file with the help
of the command
create spfile from
pfile='c:\oracle\database_name\pfile\init.ora'
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
When system tablespace is created?
How do I manually uninstall oracle client?
Why do we use coalesce function in oracle?
What is the usage of merge statement?
What is the usage of control file in oracle?
How to connect to a local oracle 10g xe server?
what is the use of system.effective.date variable in oracle?
How can I see all tables in oracle?
Explain the use of analyse option in exp command.
What is the implicit cursor in oracle?
why dont we assign not null constraint as table level constraint.
What is columnar storage what is the advantage?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How view is different from a table?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?