 Related Questions Latest Answer : Locally Managed Tablespaces Include the following Benefits:1.Free extents are managed in the Tablespace.2.Bitmap is used to record free extents.3.Each bit corresponds to a block or a group of block.4.Bit value indicates free or used. ... Latest Answer : In adddition to the answers given earlier.In a technology like Orcale one should always remember there is nothing absolute everything is optimum.There is nothing actual advantage of using Locally Managed Tablespace over System Managed Tablespace. The ... Latest Answer : The automatic space management is enabled by using SEGMENT SPACE MANAGEMENT AUTO clause in create tablespace statement. It uses the bitmap segments to keep track of used and free space in segments for particular tablespace. So whenever space is ... Latest Answer : The syntax for creating OMF tablespace is:sql>create tablespace ;The tablespace will get created through OMF and its default size is 100mb. ... Latest Answer : Default scope is "both" means the changes applicable to the current instance as well as future instance. ... What are the steps needed to perform an incomplete recovery of a data file belonging to the tablespace on a database in ARCHIVELOG mode? What is the system privilege possessed by RMAN user to connect and execute RMAN commands on a target What is the system privilege possessed by RMAN user to connect and execute RMAN commands on a target database for the process of backup and recovery? Tags : Backup What is the sequence of commands to restore and recover the data file which occurred as a result of disk failure on the disk where data file belonging to the USER_DATA tablespace is stored on the database currently kept opened? Tags : Restore What are the steps for dropping the tablespace from database along with corresponding data files automatically?
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
