CONTENT parameter is used in expdp or impdp, to load/unload data only, metadata only or both.

CONTENT
Specifies data to unload.
Valid keyword values are: [ALL], DATA_ONLY and METADATA_ONLY.

 

CONTENT=ALL is the default value

CONTENT=METADATA_ONLY:

It will take export only the metadata, i.e skeleton/DDL on the object/schema. It won’t export any of the data/rows.

CONTENT=DATA_ONLY:

It will take export only the ROWS/DATA of the tables, by excluding the DDL(i.e metadata)

Before importing the dump into another database, make sure that the table exists in that table, as we have taken export using DATA_ONLY,
which don’t contain the DDL. Else import will fail with an error as below.

Here we tried to load this dump into a database, where table doesn’t exist.

So it failed.

NOTE – NEVER USE TABLE_EXISTS_ACTION=REPLACE