Discussion Board

DIFFERENCE BETWEEN PFILE AND SPFILE PFILE is parameter file. SPFILE is server parameter file. first we have to create pfile . from that pfile we will create SPFILE by using syntax create spfile from pfile. pfile is in readable format and it is physical. spfile is dynamic and it is not in readable format.if we want to open the spfiel it will be corrupted. mainly in SPFILE we will changes any parameters in running database time based on 3 conditions; 1)scope,2)memory,3)both whenver pfile and spfile is there ayutomatically oracle takes spfile. SHAIK RAHEEM 05-2-2017 02:45 AM

RECYCLE BIN You can turn on or off the recycle bin feature for an instance in the instance parameter file with "recyclebin=on/off". RECYCLE BIN is used to control whether the Flashback Drop capability is turned on or off. If the parameter is set to OFF then dropped tables do not go into the recycle bin. If this parameter is set to ON, dropped tables go into the recycle bin and can be recovered. Prajakta Pandit 02-13-2017 03:54 AM

oracle dba please any one tell me . what is difference between parameter file and pfile. anil singh 05-20-2016 04:28 AM

whats the difference between PFILE and parameter file? are they both not same? whats the difference between PFILE and parameter file? are they both not same? Nagaraj 05-6-2016 11:25 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*