查看expdp导出的dump文件中的表空间名及用户名

expdp导出数据后，想知道源库数据库用户名和表空间名，可以使用sqlfile参数导出定义语句

1.sqlfile参数使用

impdp \"sys  AS SYSDBA \" directory=expdir remap_schema=hie:mz_hie remap_tablespace=TBS_HIE_DATA:MZ_HIE_DATA,EIF_TBS:MZ_HIE_DATA parallel=8 dumpfile=mz_hie_2025-02-14_%U.dmp sqlfile=sqlfile.sql logfile=imp_mz_hie_2025-03-12.log

2.查看 sqlfile文件内容

打开sqlfile.sql文件，包用户名、表空间名、表、存储过程、索引、权限、统计信息、数据等的创建语句，执行此命令实际并未导入数据。

# more sqlfile.sql

-- CONNECT SYS

ALTER SESSION SET EVENTS '10150 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10904 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '25475 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10407 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10851 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '22830 TRACE NAME CONTEXT FOREVER, LEVEL 192 ';

-- new object type path: SCHEMA_EXPORT/USER
-- CONNECT SYSTEM

 CREATE USER "MZ_HIE" IDENTIFIED BY VALUES 'S:A724AF4896E0C5EFFDD82CA30F00A84
ABA42342B8F0A84C2CF4CEC06DEAC;510534F75C1EDC5D'
    DEFAULT TABLESPACE "MZ_HIE_DATA"
    TEMPORARY TABLESPACE "MZ_HIE_DATA_TEMP";

-- new object type path: SCHEMA_EXPORT/SYSTEM_GRANT

GRANT IMPORT FULL DATABASE TO "MZ_HIE";
GRANT EXPORT FULL DATABASE TO "MZ_HIE";
GRANT SELECT ANY DICTIONARY TO "MZ_HIE";
GRANT CREATE VIEW TO "MZ_HIE";
GRANT CREATE SYNONYM TO "MZ_HIE";
GRANT UPDATE ANY TABLE TO "MZ_HIE";
GRANT SELECT ANY TABLE TO "MZ_HIE";
GRANT UNLIMITED TABLESPACE TO "MZ_HIE";
GRANT CREATE TABLESPACE TO "MZ_HIE";
GRANT CREATE SESSION TO "MZ_HIE";

-- new object type path: SCHEMA_EXPORT/ROLE_GRANT

 GRANT "CONNECT" TO "MZ_HIE";
 GRANT "RESOURCE" TO "MZ_HIE";
 GRANT "EXP_FULL_DATABASE" TO "MZ_HIE";
 GRANT "IMP_FULL_DATABASE" TO "MZ_HIE";

-- new object type path: SCHEMA_EXPORT/DEFAULT_ROLE

 ALTER USER "MZ_HIE" DEFAULT ROLE ALL;
 
-- new object type path: SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
-- CONNECT MZ_HIE