What is the use of SHOW option in IMP command?

The SHOW option specifies when the value of show=y, the DDL within the export file is displayed.

In Oracle, the SHOW option in the IMP (Import) command is not a valid or recognized option. The IMP command is typically used for importing data into an Oracle database, and it doesn’t have a SHOW option.

If you’re looking for information on valid options for the IMP command, you might want to refer to the official Oracle documentation or use the imp help=y command to see the available options and their descriptions.

Here’s an example of how you can check the available options:

imp help=y

This command will display a help message with a list of available options and their explanations. Look for options related to the specific import operation you are trying to perform.