What Are Patch Files
Patch files are developer coded script files containing valid Oracle DDL statements. Patch files can contain any valid DDL or DML statements for example ALTER, CREATE, DROP, INSERT, etc. Patch files can also contain anonymous PL/SQL blocks.
The main differences between patch files and source files generated by Lure are:
Developers are responsible for maintaining patch files and for ensuring that they contain the correct DDL or PL/SQL to migrate an object.
The code in patch files are not compared with any object in the database to determine whether it should be installed. Instead each patch file has a corresponding source file that is generated by Lure and it is this generated source file that is compared with the database in order to determine if the statement(s) in the patch file should be executed.
Next: Why Are Patch Files Needed