 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 : 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 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? What is the syntax of having a single statement perform the process of creating a copy of the table and have truncate operation preformed on the created table with data restore by using directload insert from the old table? Tags : Restore What is the area in which the information about the database which was in MOUNT mode is changed by using ALTER DATABASE statement into ARCHIVELOG mode and thus currently in ARCHIVELOG mode is stored?
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
