Examples of Specifying a Discard File Name

The following list shows different ways you can specify a name for the discard file from within the control file:

  • To specify a discard file with file name circular and default file extension or file type of .dsc:

    DISCARDFILE  circular 
    
  • To specify a discard file named notappl with the file extension or file type of .may:

    DISCARDFILE notappl.may 
    
  • To specify a full path to the discard file forget.me:

    DISCARDFILE  '/discard_dir/forget.me'