SQL> show parameter max_string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
max_string_size                      string      EXTENDED

expdp system/pwd SCHEMAS=mydbowner DIRECTORY=/my/exp/dir DUMPFILE=sid.dmp CONTENT=METADATA_ONLY

SQLFILE
Default: none
Purpose
Specifies a file into which all of the SQL DDL that Import would have executed, based on other parameters, is written.

Syntax and Description
SQLFILE=[directory_object:]file_name

The file_name specifies where the import job will write the DDL that would be executed during the job. The SQL is not actually executed, and the target system remains unchanged. The file is written to the directory object specified in the DIRECTORY parameter, unless another directory_object is explicitly specified here. Any existing file that has a name matching the one specified with this parameter is overwritten.
Note that passwords are not included in the SQL file. For example, if a CONNECT statement is part of the DDL that was executed, it will be replaced by a comment with only the schema name shown. In the following example, the dashes indicate that a comment follows, and the hr schema name is shown, but not the password.

-- CONNECT hr
Therefore, before you can execute the SQL file, you must edit it by removing the dashes indicating a comment and adding the password for the hr schema (in this case, the password is also hr), as follows:

CONNECT hr/hr
For Streams and other Oracle database options, anonymous PL/SQL blocks may appear within the SQLFILE output. They should not be executed directly.

Example
The following is an example of using the SQLFILE parameter. You can create the expfull.dmp dump file used in this example by running the example provided for the Export FULL parameter. See FULL.

> impdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=expfull.dmp SQLFILE=dpump_dir2:expfull.sql

 ALTER PROFILE "DEFAULT"
    LIMIT 
         COMPOSITE_LIMIT UNLIMITED 
         SESSIONS_PER_USER UNLIMITED 
         CPU_PER_SESSION UNLIMITED 
         CPU_PER_CALL UNLIMITED 
         LOGICAL_READS_PER_SESSION UNLIMITED 
         LOGICAL_READS_PER_CALL UNLIMITED 
         IDLE_TIME UNLIMITED 
         CONNECT_TIME UNLIMITED 
         PRIVATE_SGA UNLIMITED 
         FAILED_LOGIN_ATTEMPTS 20 
         PASSWORD_LIFE_TIME UNLIMITED 
         PASSWORD_REUSE_TIME UNLIMITED 
         PASSWORD_REUSE_MAX UNLIMITED 
         PASSWORD_VERIFY_FUNCTION NULL 
         PASSWORD_LOCK_TIME 86400/86400 
         PASSWORD_GRACE_TIME 604800/86400 ;

 CREATE USER "MYSCOWNER" IDENTIFIED BY VALUES 'S:aBrAkAdAbRa'
      DEFAULT TABLESPACE "USERS"
      TEMPORARY TABLESPACE "TEMP";

 CREATE USER "anyusername" IDENTIFIED BY VALUES 'S:000000000000000000000000000000000000000000000000000000000000'
      DEFAULT TABLESPACE "USERS"
      TEMPORARY TABLESPACE "TEMP"
      PASSWORD EXPIRE
      ACCOUNT LOCK;

exec dbms_stats.unlock_schema_stats('MYSCOWNER');

SELECT * FROM nls_session_parameters;

PARAMETER	VALUE
NLS_LANGUAGE	AMERICAN
NLS_TERRITORY	RUSSIA
NLS_CURRENCY	?
NLS_ISO_CURRENCY	RUSSIA
NLS_NUMERIC_CHARACTERS	.
NLS_CALENDAR	GREGORIAN
NLS_DATE_FORMAT	DD.MM.YYYY
NLS_DATE_LANGUAGE	AMERICAN
NLS_SORT	BINARY
NLS_TIME_FORMAT	HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT	DD.MM.RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT	HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT	DD.MM.RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY	?
NLS_COMP	BINARY
NLS_LENGTH_SEMANTICS	BYTE
NLS_NCHAR_CONV_EXCP	FALSE

select * from nls_database_parameters where parameter='NLS_CHARACTERSET';

PARAMETER	VALUE
NLS_CHARACTERSET	AL32UTF8

SQL> select e_name, length(e_name), lengthB(e_name) from employees where e_id = 95;

E_NAME                                   LENGTH(E_NAME) LENGTHB(E_NAME)
---------------------------------------- -------------- ---------------
????????? ????????? ??????????                       30              58

[oracle@adpdb ~]$ locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

[oracle@adpdb /]$ export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
[oracle@adpdb /]$ sqlplus /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Oct 16 02:49:54 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

SQL> conn adpmanager/adpmanager
Connected.
SQL> select e_name from employees where e_id = 95;

E_NAME
--------------------------------------------------------------------------------
............. АЛЕКСАНДР ВАЛЕРЬЕВИЧ