You can use RDMBS replication technology - Oracle Golden Gate, Oracle Data Guard, SQL Server Always On, PostreSQL Slony, then you can keep the dev in sync with prod, but do you really want that? you could simply restore a database backup of prod into dev every week or so, your database administrator can help choose the best solution and even automate the process.
| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "About: In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 33 years, my passion for Spatial Databases and GIS data has become a central part of my career.." | “ The mountains are calling and I must go.” – John Muir |