I'm currently working on project to clean database services on oracle database.
Analyze first whats not needed and then drop.
I need to prepare backup of services data for rollback purpose.
(toad can export many types of object metadata, but there isn't option to export services metadata)
Someone know way to achieve that?
Best Answer
You can get the required data from DBA_SERVICES (or v$active_services)
You can get the DDL required to create them again using something like this: