- SEGMENT_ATTRIBUTES: by default value is y which will copy the objects as it is in the export dump with all segment attributes. If you specify the value as n the import job will omit the segment_attributes in the dump file and it will use the tablespace/user default values.
- STORAGE: by default the value for this parameter is y which will include all storage clauses during the import job. If you specify the parameter value as n then it will omit the storage clause in the dump file and it will follow the default values in the tablespace.
- PCTSPACE: it is the percent multiplier for the extent allocations and size of the datafiles during the import.
- OID: object id (OID) mainly used for the TYPE objects. Each and every type is identified by OID which will be unique. If you create a type without specifying the OID the RDBMS itself will create and assign unique OID to the new TYPE object. See below examples for more details.