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 |
what is candidate key & super key
How to get a create statement for an existing table?
Explain oracle instance.
Can we connect to ORACLE db using Windows Authentication?
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?
How to best split csv strings in oracle 9i?
can any one help me with import/export options in oracle............
How to name query output columns in oracle?
How do I limit the number of oracle database connections generated by weblogic server?
How do you handle duplicate records in a database?
Where is the export dump file located?
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?