(This topic applies only to release 21c or later; it does not apply to release 19c or earlier.)

To delete all WFS metadata from a schema, execute the following command:

execute mdsys.sdo_wfs_process.dropMetadata;

This removes the WFS instance associated with that database schema.