Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the pre-requisites to create a snapshot log ?

April 26, 2017create log pre-requisites Snapshot

0

Posted

What are the pre-requisites to create a snapshot log ?

1 Answer

0

Posted

We must be able to create a after row trigger on table (i.e. it should not be already available) After giving table previleges. We cannot specify snapshot log name because oracle uses the name of the master table in the name of the database objects that support its snapshot log. The master table name should be less than or equal to 23 characters.