How do we switch from init.ora file to asp file?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
How to delete multiple rows from a table in oracle?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
Why cursor variables are easier to use than cursors?
What is pragma autonomous transaction in oracle?
How to define and use table alias names in oracle?
What is OCI. What are its uses?
What is the parameter mode that can be passed to a procedure?
How to import one table back from a dump file?
which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help
Explain the use of full option in exp command.
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?