⟩ How will you force database to use particular rollback segment?
For perticular transaction Alter system set rollback segment 'name';
For database, we can set in pfile. Rollback_segment='name' .
For perticular transaction Alter system set rollback segment 'name';
For database, we can set in pfile. Rollback_segment='name' .
What is an Index in Oracle?
What is self-referential integrity constraint in Oracle?
Explain the different type of Integrity Constraints supported by ORACLE?
Tell me how to define Data Block size?
What are Schema Objects in Oracle?
What are the type of Synonyms in Oracle?
What are the advantages of Views in Oracle?
What is a Public Synonyms in Oracle?
What is a Private Synonyms in Oracle?
What are the Characteristics of Data Files in Oracle?