并行导出clob大表

于 2021-06-18 16:43:42 发布
阅读量507 收藏 2
点赞数
分类专栏： oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jycjyc/article/details/118029262
版权

脚本参考：

SQL> desc MEDICAL_CHECK_SYSINFO_H
 Name                                               Null?    Type
 ----------------------------------------------------------------------------------------- -------- ------------------------------------------------------------
 ID                                               NOT NULL NUMBER(10)
 REGISTER_NO                                           NOT NULL VARCHAR2(50 CHAR)
 PATIENT_ID                                           NOT NULL NUMBER(10)
 ORG_CODE                                           NOT NULL VARCHAR2(50 CHAR)
 MICODE                                            NOT NULL VARCHAR2(50 CHAR)
 ICNO                                               NOT NULL VARCHAR2(50 CHAR)
 SERVER_DATE                                           NOT NULL TIMESTAMP(9)
 ALLOW_QUERY_FLAG                                       NOT NULL NUMBER(10)
 SIGNINFO                                           NOT NULL VARCHAR2(50 CHAR)
 RAW_DATA                                                CLOB
 

查看导出job：

SET lines 200 
COL owner_name FORMAT a10;
COL job_name FORMAT a20;
COL state FORMAT a12;
COL operation LIKE state;
COL job_mode LIKE state;
COL owner.object for a50;
 
-- locate Data Pump jobs: 
SELECT owner_name, job_name, rtrim(operation) "OPERATION", 
    rtrim(job_mode) "JOB_MODE", state, attached_sessions
FROM dba_datapump_jobs
 WHERE job_name NOT LIKE 'BIN$%'
 ORDER BY 1,2; 

SELECT o.status, o.object_id, o.object_type, 
       o.owner||'.'||object_name "OWNER.OBJECT" 
  FROM dba_objects o, dba_datapump_jobs j 
 WHERE o.owner=j.owner_name AND o.object_name=j.job_name 
   AND j.job_name NOT LIKE 'BIN$%' ORDER BY 4,2;

异常终止expdp处理：

expdp xxx/xxx@xxxdb TABLES=MEDICAL_CHECK_SYSINFO_H QUERY=MEDICAL_CHECK_SYSINFO_H:\"where mod\(dbms_rowid.rowid_block_number\(rowid\), 10\) = 7\" directory=DMP dumpfile=MEDICAL_CHECK_SYSINFO_H_7.dmp logfile=log_test_7.log 

SQL> SET lines 200 
COL owner_name FORMAT a10;
COL job_name FORMAT a20;
COL state FORMAT a12;
COL operation LIKE state;
COL job_mode LIKE state;
COL owner.object for a50;

SQL> SELECT o.status, o.object_id, o.object_type, 
       o.owner||'.'||object_name "OWNER.OBJECT" 
  FROM dba_objects o, dba_datapump_jobs j 
 WHERE o.owner=j.owner_name AND o.object_name=j.job_name 
   AND j.job_name NOT LIKE 'BIN$%' ORDER BY 4,2;  2    3    4    5  

STATUS	 OBJECT_ID OBJECT_TYPE
------- ---------- -----------------------
OWNER.OBJECT
--------------------------------------------------------------------------------
VALID	     94147 TABLE
xxx.SYS_EXPORT_TABLE_10

SQL> -- locate Data Pump jobs: 
SQL>SELECT owner_name, job_name, rtrim(operation) "OPERATION", 
    rtrim(job_mode) "JOB_MODE", state, attached_sessions
FROM dba_datapump_jobs
 WHERE job_name NOT LIKE 'BIN$%';

OWNER_NAME JOB_NAME		OPERATION    JOB_MODE	  STATE        ATTACHED_SESSIONS
---------- -------------------- ------------ ------------ ------------ -----------------
xxx	   SYS_EXPORT_TABLE_10	EXPORT	     TABLE	  STOP PENDING		       0

SQL> /

OWNER_NAME JOB_NAME		OPERATION    JOB_MODE	  STATE        ATTACHED_SESSIONS
---------- -------------------- ------------ ------------ ------------ -----------------
xxx	   SYS_EXPORT_TABLE_10	EXPORT	     TABLE	  STOP PENDING		       0

SQL> /

OWNER_NAME JOB_NAME		OPERATION    JOB_MODE	  STATE        ATTACHED_SESSIONS
---------- -------------------- ------------ ------------ ------------ -----------------
xxx	   SYS_EXPORT_TABLE_10	EXPORT	     TABLE	  STOPPING		       0

SQL> /

no rows selected

SQL> SELECT o.status, o.object_id, o.object_type, 
       o.owner||'.'||object_name "OWNER.OBJECT" 
  FROM dba_objects o, dba_datapump_jobs j 
 WHERE o.owner=j.owner_name AND o.object_name=j.job_name 
   AND j.job_name NOT LIKE 'BIN$%' ORDER BY 4,2;   2    3    4    5  

no rows selected



[oracle@rac1 dmp]$ expdp xxx/xxx@xxxdb attach=SYS_EXPORT_TABLE_10

Export: Release 19.0.0.0.0 - Production on Sat Jun 19 13:11:41 2021
Version 19.11.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Job: SYS_EXPORT_TABLE_10
  Owner: xxx                            
  Operation: EXPORT                         
  Creator Privs: TRUE                           
  GUID: C5186FACCC327C75E053820AA8C04187
  Start Time: Saturday, 19 June, 2021 13:08:53
  Mode: TABLE                          
  Instance: xxx1
  Max Parallelism: 1
  Timezone: +00:00
  Timezone version: 32
  Endianness: LITTLE
  NLS character set: ZHS16GBK
  NLS NCHAR character set: AL16UTF16
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        xxx/********@xxxdb TABLES=MEDICAL_CHECK_SYSINFO_H QUERY=MEDICAL_CHECK_SYSINFO_H:"where mod(dbms_rowid.rowid_block_number(rowid), 10) = 7" directory=DMP dumpfile=MEDICAL_CHECK_SYSINFO_H_7.dmp logfile=log_test_7.log 
     TRACE                 0
  State: STOP PENDING                   
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Job heartbeat: 112
  Dump File: /oracle/dmp/MEDICAL_CHECK_SYSINFO_H_7.dmp
    bytes written: 32,768
  
Worker 1 Status:
  Instance ID: 1
  Instance name: xxx1
  Host name: rac1
  Object start time: Saturday, 19 June, 2021 13:09:17
  Object status at: Saturday, 19 June, 2021 13:09:17
  Process Name: DW03
  State: EXECUTING                      
  Object Schema: xxx
  Object Name: MEDICAL_CHECK_SYSINFO_H
  Object Type: TABLE_EXPORT/TABLE/TABLE_DATA
  Completed Objects: 1
  Total Objects: 1
  Completed Rows: 163,321
  Worker Parallelism: 1

Export> kill_job
Are you sure you wish to stop this job ([yes]/no): yes

查看lob表大小：

select a.owner,a.table_name,a.column_name,b.segment_name,ROUND(b.BYTES / 1024 / 1024)
  from dba_lobs a, dba_segments b
 where a.segment_name = b.segment_name
   and a.owner = 'XXX'
   and a.table_name = 'MEDICAL_CHECK_SYSINFO_H'
union all
select a.owner,a.table_name,a.column_name,b.segment_name,ROUND(b.BYTES / 1024 / 1024)
  from dba_lobs a, dba_segments b
 where a.index_name = b.segment_name
   and a.owner = 'XXX'
   and a.table_name = 'MEDICAL_CHECK_SYSINFO_H'
union all
select a.owner,'','',a.segment_name,ROUND(sum(a.BYTES) / 1024 / 1024)
  from dba_segments a
 where a.owner = 'XXX'
   and a.segment_name = 'MEDICAL_CHECK_SYSINFO_H' group by a.owner,a.segment_name;

1.sh内容：注意i必须从0开始

导出：
#!/bin/bash
chunk=10
for ((i=0;i<=9;i++));
do
expdp xxx/xxx@xxxTABLES=MEDICAL_CHECK_SYSINFO_H QUERY=MEDICAL_CHECK_SYSINFO_H:\"where mod\(dbms_rowid.rowid_block_number\(rowid\)\, ${chunk}\) = ${i}\" directory=DMP cluster=N exclude=statistics dumpfile=MEDICAL_CHECK_SYSINFO_H_${i}.dmp logfile=log_test_${i}.log &
echo $i
sleep 2  #不加延迟2秒，将导致输出太快报错ORA-31626: job does not exist
done

导入：需要先导入元表结构并排除索引exclude=index,constraint,trigger,statistics,然后执行下面脚本导入content=data_only最后导入include=index,constraint,trigger,statistics

#!/bin/bash
chunk=10
for ((i=0;i<=9;i++));
do
impdp xxx/xxx@xxx  directory=DMP REMAP_TABLE=MEDICAL_CHECK_SYSINFO_H:MEDICAL_CHECK_SYSINFO_H  remap_schema=xxx:target dumpfile=MEDICAL_CHECK_SYSINFO_H_${i}.dmp logfile=TABLE_imp_log_test_${i}.log  DATA_OPTIONS=DISABLE_APPEND_HINT CONTENT=DATA_ONLY cluster=N exclude=statistics &
sleep 2
done

DISABLE_APPEND_HINT — Specifies that you do not want the import operation to use the APPEND hint while loading the data object. Disabling the APPEND hint can be useful if there is a small set of data objects to load that already exist in the database and some other application may be concurrently accessing one or more of the data objects. 

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/datapump-import-utility.html#GUID-5FFA128D-B7F5-41D0-A72C-EB2CE384765D

并行导出操作记录参考：13分钟，120GB大小

查看job任务：


select owner_name, job_name, operation, job_mode, state, attached_sessions 
from dba_datapump_jobs 
where job_name not like 'BIN$%' 
order by 1, 2;

执行窗口：

[oracle@rac1 dmp]$ chmod +x 1.sh
[oracle@rac1 dmp]$ ./1.sh
0
1
2
3
4
5
6
7
8
9
[oracle@rac1 dmp]$ 
Export: Release 19.0.0.0.0 - Production on Fri Jun 18 16:24:08 2021
Version 19.11.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.


Export: Release 19.0.0.0.0 - Production on Fri Jun 18 16:24:08 2021
Export: Release 19.0.0.0.0 - Production on Fri Jun 18 16:24:08 2021
Version 19.11.0.0.0
Version 19.11.0.0.0


Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Export: Release 19.0.0.0.0 - Production on Fri Jun 18 16:24:08 2021
Version 19.11.0.0.0



Export: Release 19.0.0.0.0 - Production on Fri Jun 18 16:24:08 2021
Export: Release 19.0.0.0.0 - Production on Fri Jun 18 16:24:08 2021
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
Version 19.11.0.0.0
Version 19.11.0.0.0



Export: Release 19.0.0.0.0 - Production on Fri Jun 18 16:24:08 2021
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
Version 19.11.0.0.0


Export: Release 19.0.0.0.0 - Production on Fri Jun 18 16:24:08 2021
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
Version 19.11.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.


Export: Release 19.0.0.0.0 - Production on Fri Jun 18 16:24:08 2021
Export: Release 19.0.0.0.0 - Production on Fri Jun 18 16:24:08 2021
Version 19.11.0.0.0
Version 19.11.0.0.0


Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-31626: job does not exist
ORA-31633: unable to create master table "xxx.SYS_EXPORT_TABLE_07"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1163
ORA-00955: name is already used by an existing object
ORA-06512: at "SYS.KUPV$FT", line 1056
ORA-06512: at "SYS.KUPV$FT", line 1044


ORA-31626: job does not exist
ORA-31633: unable to create master table "xxx.SYS_EXPORT_TABLE_08"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1163
ORA-00955: name is already used by an existing object
ORA-06512: at "SYS.KUPV$FT", line 1056
ORA-06512: at "SYS.KUPV$FT", line 1044


Starting "xxx"."SYS_EXPORT_TABLE_01":  xxx/********@xxxdb TABLES=MEDICAL_CHECK_SYSINFO_H QUERY=MEDICAL_CHECK_SYSINFO_H:"where mod(dbms_rowid.rowid_block_number(rowid), 10) = 1" directory=DMP dumpfile=MEDICAL_CHECK_SYSINFO_H_1.dmp logfile=log_test_1.log 
Starting "xxx"."SYS_EXPORT_TABLE_02":  xxx/********@xxxdb TABLES=MEDICAL_CHECK_SYSINFO_H QUERY=MEDICAL_CHECK_SYSINFO_H:"where mod(dbms_rowid.rowid_block_number(rowid), 10) = 0" directory=DMP dumpfile=MEDICAL_CHECK_SYSINFO_H_0.dmp logfile=log_test_0.log 
Starting "xxx"."SYS_EXPORT_TABLE_08":  xxx/********@xxxdb TABLES=MEDICAL_CHECK_SYSINFO_H QUERY=MEDICAL_CHECK_SYSINFO_H:"where mod(dbms_rowid.rowid_block_number(rowid), 10) = 4" directory=DMP dumpfile=MEDICAL_CHECK_SYSINFO_H_4.dmp logfile=log_test_4.log 
Starting "xxx"."SYS_EXPORT_TABLE_07":  xxx/********@xxxdb TABLES=MEDICAL_CHECK_SYSINFO_H QUERY=MEDICAL_CHECK_SYSINFO_H:"where mod(dbms_rowid.rowid_block_number(rowid), 10) = 6" directory=DMP dumpfile=MEDICAL_CHECK_SYSINFO_H_6.dmp logfile=log_test_6.log 
Starting "xxx"."SYS_EXPORT_TABLE_04":  xxx/********@xxxdb TABLES=MEDICAL_CHECK_SYSINFO_H QUERY=MEDICAL_CHECK_SYSINFO_H:"where mod(dbms_rowid.rowid_block_number(rowid), 10) = 2" directory=DMP dumpfile=MEDICAL_CHECK_SYSINFO_H_2.dmp logfile=log_test_2.log 
Starting "xxx"."SYS_EXPORT_TABLE_03":  xxx/********@xxxdb TABLES=MEDICAL_CHECK_SYSINFO_H QUERY=MEDICAL_CHECK_SYSINFO_H:"where mod(dbms_rowid.rowid_block_number(rowid), 10) = 3" directory=DMP dumpfile=MEDICAL_CHECK_SYSINFO_H_3.dmp logfile=log_test_3.log 
Starting "xxx"."SYS_EXPORT_TABLE_05":  xxx/********@xxxdb TABLES=MEDICAL_CHECK_SYSINFO_H QUERY=MEDICAL_CHECK_SYSINFO_H:"where mod(dbms_rowid.rowid_block_number(rowid), 10) = 9" directory=DMP dumpfile=MEDICAL_CHECK_SYSINFO_H_9.dmp logfile=log_test_9.log 
Starting "xxx"."SYS_EXPORT_TABLE_06":  xxx/********@xxxdb TABLES=MEDICAL_CHECK_SYSINFO_H QUERY=MEDICAL_CHECK_SYSINFO_H:"where mod(dbms_rowid.rowid_block_number(rowid), 10) = 5" directory=DMP dumpfile=MEDICAL_CHECK_SYSINFO_H_5.dmp logfile=log_test_5.log 
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
. . exported "xxx"."MEDICAL_CHECK_SYSINFO_H"             11.80 GB  313975 rows
Master table "xxx"."SYS_EXPORT_TABLE_08" successfully loaded/unloaded
******************************************************************************
Dump file set for xxx.SYS_EXPORT_TABLE_08 is:
  /oracle/dmp/MEDICAL_CHECK_SYSINFO_H_4.dmp
Job "xxx"."SYS_EXPORT_TABLE_08" successfully completed at Fri Jun 18 16:35:26 2021 elapsed 0 00:11:08

. . exported "xxx"."MEDICAL_CHECK_SYSINFO_H"             11.88 GB  314981 rows
Master table "xxx"."SYS_EXPORT_TABLE_05" successfully loaded/unloaded
******************************************************************************
Dump file set for xxx.SYS_EXPORT_TABLE_05 is:
  /oracle/dmp/MEDICAL_CHECK_SYSINFO_H_9.dmp
Job "xxx"."SYS_EXPORT_TABLE_05" successfully completed at Fri Jun 18 16:35:34 2021 elapsed 0 00:11:18

. . exported "xxx"."MEDICAL_CHECK_SYSINFO_H"             11.85 GB  313992 rows
Master table "xxx"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for xxx.SYS_EXPORT_TABLE_01 is:
  /oracle/dmp/MEDICAL_CHECK_SYSINFO_H_1.dmp
. . exported "xxx"."MEDICAL_CHECK_SYSINFO_H"             11.78 GB  314160 rows
Job "xxx"."SYS_EXPORT_TABLE_01" successfully completed at Fri Jun 18 16:35:39 2021 elapsed 0 00:11:24

. . exported "xxx"."MEDICAL_CHECK_SYSINFO_H"             11.85 GB  314894 rows
Master table "xxx"."SYS_EXPORT_TABLE_06" successfully loaded/unloaded
******************************************************************************
Dump file set for xxx.SYS_EXPORT_TABLE_06 is:
  /oracle/dmp/MEDICAL_CHECK_SYSINFO_H_5.dmp
. . exported "xxx"."MEDICAL_CHECK_SYSINFO_H"             11.91 GB  316471 rows
Master table "xxx"."SYS_EXPORT_TABLE_03" successfully loaded/unloaded
. . exported "xxx"."MEDICAL_CHECK_SYSINFO_H"             11.97 GB  317177 rows
Job "xxx"."SYS_EXPORT_TABLE_06" successfully completed at Fri Jun 18 16:35:42 2021 elapsed 0 00:11:26

******************************************************************************
Dump file set for xxx.SYS_EXPORT_TABLE_03 is:
  /oracle/dmp/MEDICAL_CHECK_SYSINFO_H_3.dmp
Master table "xxx"."SYS_EXPORT_TABLE_07" successfully loaded/unloaded
******************************************************************************
Dump file set for xxx.SYS_EXPORT_TABLE_07 is:
  /oracle/dmp/MEDICAL_CHECK_SYSINFO_H_6.dmp
Job "xxx"."SYS_EXPORT_TABLE_03" successfully completed at Fri Jun 18 16:35:44 2021 elapsed 0 00:11:29

Master table "xxx"."SYS_EXPORT_TABLE_04" successfully loaded/unloaded
. . exported "xxx"."MEDICAL_CHECK_SYSINFO_H"             11.91 GB  316566 rows
******************************************************************************
Dump file set for xxx.SYS_EXPORT_TABLE_04 is:
  /oracle/dmp/MEDICAL_CHECK_SYSINFO_H_2.dmp
Job "xxx"."SYS_EXPORT_TABLE_07" successfully completed at Fri Jun 18 16:35:45 2021 elapsed 0 00:11:27

Job "xxx"."SYS_EXPORT_TABLE_04" successfully completed at Fri Jun 18 16:35:46 2021 elapsed 0 00:11:30

Master table "xxx"."SYS_EXPORT_TABLE_02" successfully loaded/unloaded
******************************************************************************
Dump file set for xxx.SYS_EXPORT_TABLE_02 is:
  /oracle/dmp/MEDICAL_CHECK_SYSINFO_H_0.dmp
Job "xxx"."SYS_EXPORT_TABLE_02" successfully completed at Fri Jun 18 16:35:47 2021 elapsed 0 00:11:33

另一窗口记录：

SQL> col state for a10
SQL> 
 select owner_name, job_name, operation, job_mode, state, attached_sessions
 from dba_datapump_jobs
 where job_name not like 'BIN$%'
 order by 1, 2

OWNER_NAME JOB_NAME			  OPERAT JOB_MO STATE	   ATTACHED_SESSIONS
---------- ------------------------------ ------ ------ ---------- -----------------
xxx	   SYS_EXPORT_TABLE_01		  EXPORT TABLE	EXECUTING		   1
xxx	   SYS_EXPORT_TABLE_02		  EXPORT TABLE	EXECUTING		   1
xxx	   SYS_EXPORT_TABLE_03		  EXPORT TABLE	EXECUTING		   1
xxx	   SYS_EXPORT_TABLE_04		  EXPORT TABLE	EXECUTING		   1
xxx	   SYS_EXPORT_TABLE_05		  EXPORT TABLE	EXECUTING		   1
xxx	   SYS_EXPORT_TABLE_06		  EXPORT TABLE	EXECUTING		   1
xxx	   SYS_EXPORT_TABLE_07		  EXPORT TABLE	EXECUTING		   1
xxx	   SYS_EXPORT_TABLE_08		  EXPORT TABLE	EXECUTING		   1

8 rows selected.

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.11.0.0.0
[oracle@rac1 ~]$ cd /oracle/dmp
[oracle@rac1 dmp]$ du -sh MEDICAL_CHECK_SYSINFO*.dmp
8.1G	MEDICAL_CHECK_SYSINFO_H_0.dmp
8.1G	MEDICAL_CHECK_SYSINFO_H_1.dmp
8.1G	MEDICAL_CHECK_SYSINFO_H_2.dmp
8.0G	MEDICAL_CHECK_SYSINFO_H_3.dmp
8.1G	MEDICAL_CHECK_SYSINFO_H_4.dmp
8.1G	MEDICAL_CHECK_SYSINFO_H_5.dmp
8.1G	MEDICAL_CHECK_SYSINFO_H_6.dmp
8.1G	MEDICAL_CHECK_SYSINFO_H_9.dmp
[oracle@rac1 dmp]$ du -sh MEDICAL_CHECK_SYSINFO*.dmp
8.1G	MEDICAL_CHECK_SYSINFO_H_0.dmp
8.1G	MEDICAL_CHECK_SYSINFO_H_1.dmp
8.1G	MEDICAL_CHECK_SYSINFO_H_2.dmp
8.0G	MEDICAL_CHECK_SYSINFO_H_3.dmp
8.1G	MEDICAL_CHECK_SYSINFO_H_4.dmp
8.1G	MEDICAL_CHECK_SYSINFO_H_5.dmp
8.1G	MEDICAL_CHECK_SYSINFO_H_6.dmp
8.1G	MEDICAL_CHECK_SYSINFO_H_9.dmp
[oracle@rac1 dmp]$ du -sh MEDICAL_CHECK_SYSINFO*.dmp
16G	MEDICAL_CHECK_SYSINFO_H_0.dmp
16G	MEDICAL_CHECK_SYSINFO_H_1.dmp
16G	MEDICAL_CHECK_SYSINFO_H_2.dmp
16G	MEDICAL_CHECK_SYSINFO_H_3.dmp
16G	MEDICAL_CHECK_SYSINFO_H_4.dmp
16G	MEDICAL_CHECK_SYSINFO_H_5.dmp
16G	MEDICAL_CHECK_SYSINFO_H_6.dmp
16G	MEDICAL_CHECK_SYSINFO_H_9.dmp
[oracle@rac1 dmp]$ du -sh MEDICAL_CHECK_SYSINFO*.dmp
16G	MEDICAL_CHECK_SYSINFO_H_0.dmp
16G	MEDICAL_CHECK_SYSINFO_H_1.dmp
16G	MEDICAL_CHECK_SYSINFO_H_2.dmp
16G	MEDICAL_CHECK_SYSINFO_H_3.dmp
16G	MEDICAL_CHECK_SYSINFO_H_4.dmp
16G	MEDICAL_CHECK_SYSINFO_H_5.dmp
16G	MEDICAL_CHECK_SYSINFO_H_6.dmp
16G	MEDICAL_CHECK_SYSINFO_H_9.dmp
[oracle@rac1 dmp]$ du -sh MEDICAL_CHECK_SYSINFO*.dmp
16G	MEDICAL_CHECK_SYSINFO_H_0.dmp
16G	MEDICAL_CHECK_SYSINFO_H_1.dmp
16G	MEDICAL_CHECK_SYSINFO_H_2.dmp
16G	MEDICAL_CHECK_SYSINFO_H_3.dmp
16G	MEDICAL_CHECK_SYSINFO_H_4.dmp
16G	MEDICAL_CHECK_SYSINFO_H_5.dmp
16G	MEDICAL_CHECK_SYSINFO_H_6.dmp
16G	MEDICAL_CHECK_SYSINFO_H_9.dmp
[oracle@rac1 dmp]$ sar 1 10
Linux 5.4.17-2011.6.2.el7uek.x86_64 (rac1) 	06/18/2021 	_x86_64_	(64 CPU)

04:31:35 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
04:31:36 PM     all      3.41      0.00      2.59      3.39      0.00     90.62
04:31:37 PM     all      3.40      0.00      2.25      3.22      0.00     91.13
04:31:38 PM     all      3.33      0.00      2.21      2.95      0.00     91.52
04:31:39 PM     all      3.31      0.00      2.16      3.70      0.00     90.83
04:31:40 PM     all      3.28      0.00      2.11      4.65      0.00     89.96
04:31:41 PM     all      3.21      0.00      2.38      5.04      0.00     89.36
04:31:42 PM     all      3.15      0.00      1.97      4.43      0.00     90.44
04:31:43 PM     all      3.21      0.00      1.86      3.72      0.00     91.21
04:31:44 PM     all      3.06      0.00      2.02      4.56      0.00     90.37
04:31:45 PM     all      3.15      0.00      1.92      4.47      0.00     90.46
Average:        all      3.25      0.00      2.15      4.01      0.00     90.59
[oracle@rac1 dmp]$ du -sh MEDICAL_CHECK_SYSINFO*.dmp
12G	MEDICAL_CHECK_SYSINFO_H_0.dmp
12G	MEDICAL_CHECK_SYSINFO_H_1.dmp
12G	MEDICAL_CHECK_SYSINFO_H_2.dmp
12G	MEDICAL_CHECK_SYSINFO_H_3.dmp
12G	MEDICAL_CHECK_SYSINFO_H_4.dmp
12G	MEDICAL_CHECK_SYSINFO_H_5.dmp
12G	MEDICAL_CHECK_SYSINFO_H_6.dmp
12G	MEDICAL_CHECK_SYSINFO_H_9.dmp
[oracle@rac1 dmp]$ du -sh MEDICAL_CHECK_SYSINFO*.dmp
12G	MEDICAL_CHECK_SYSINFO_H_0.dmp
12G	MEDICAL_CHECK_SYSINFO_H_1.dmp
12G	MEDICAL_CHECK_SYSINFO_H_2.dmp
12G	MEDICAL_CHECK_SYSINFO_H_3.dmp
12G	MEDICAL_CHECK_SYSINFO_H_4.dmp
12G	MEDICAL_CHECK_SYSINFO_H_5.dmp
12G	MEDICAL_CHECK_SYSINFO_H_6.dmp
12G	MEDICAL_CHECK_SYSINFO_H_9.dmp
[oracle@rac1 dmp]$ du -sh MEDICAL_CHECK_SYSINFO*.dmp
12G	MEDICAL_CHECK_SYSINFO_H_0.dmp
12G	MEDICAL_CHECK_SYSINFO_H_1.dmp
12G	MEDICAL_CHECK_SYSINFO_H_2.dmp
12G	MEDICAL_CHECK_SYSINFO_H_3.dmp
12G	MEDICAL_CHECK_SYSINFO_H_4.dmp
12G	MEDICAL_CHECK_SYSINFO_H_5.dmp
12G	MEDICAL_CHECK_SYSINFO_H_6.dmp
12G	MEDICAL_CHECK_SYSINFO_H_9.dmp
[oracle@rac1 dmp]$ ls -lt|more
total 239233592
-rw-r--r-- 1 oracle asmadmin        1380 Jun 18 16:35 log_test_0.log
-rw-r----- 1 oracle asmadmin 12790267904 Jun 18 16:35 MEDICAL_CHECK_SYSINFO_H_0.dmp
-rw-r--r-- 1 oracle asmadmin        1380 Jun 18 16:35 log_test_2.log
-rw-r----- 1 oracle asmadmin 12857425920 Jun 18 16:35 MEDICAL_CHECK_SYSINFO_H_2.dmp
-rw-r--r-- 1 oracle asmadmin        1380 Jun 18 16:35 log_test_6.log
-rw-r----- 1 oracle asmadmin 12797472768 Jun 18 16:35 MEDICAL_CHECK_SYSINFO_H_6.dmp
-rw-r--r-- 1 oracle asmadmin        1380 Jun 18 16:35 log_test_3.log
-rw-r----- 1 oracle asmadmin 12729819136 Jun 18 16:35 MEDICAL_CHECK_SYSINFO_H_3.dmp
-rw-r--r-- 1 oracle asmadmin        1380 Jun 18 16:35 log_test_5.log
-rw-r----- 1 oracle asmadmin 12649000960 Jun 18 16:35 MEDICAL_CHECK_SYSINFO_H_5.dmp
-rw-r--r-- 1 oracle asmadmin        1380 Jun 18 16:35 log_test_1.log
-rw-r----- 1 oracle asmadmin 12726243328 Jun 18 16:35 MEDICAL_CHECK_SYSINFO_H_1.dmp
-rw-r--r-- 1 oracle asmadmin        1380 Jun 18 16:35 log_test_9.log
-rw-r----- 1 oracle asmadmin 12764639232 Jun 18 16:35 MEDICAL_CHECK_SYSINFO_H_9.dmp
-rw-r--r-- 1 oracle asmadmin        1380 Jun 18 16:35 log_test_4.log
-rw-r----- 1 oracle asmadmin 12672323584 Jun 18 16:35 MEDICAL_CHECK_SYSINFO_H_4.dmp
-rwxr-xr-x 1 oracle oinstall         304 Jun 18 16:23 1.sh

[oracle@rac1 dmp]$ more log_test_4.log
;;; 
Export: Release 19.0.0.0.0 - Production on Fri Jun 18 16:24:08 2021
Version 19.11.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
;;; 
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "xxx"."SYS_EXPORT_TABLE_08":  xxx/********@xxxdb TABLES=MEDICAL_CHECK_SYSINFO_H QUERY=MEDICAL_CHECK_SYSINFO_H:"where mod(dbms_rowid.rowid_block_number(ro
wid), 10) = 4" directory=DMP dumpfile=MEDICAL_CHECK_SYSINFO_H_4.dmp logfile=log_test_4.log 
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
. . exported "xxx"."MEDICAL_CHECK_SYSINFO_H"             11.80 GB  313975 rows
Master table "xxx"."SYS_EXPORT_TABLE_08" successfully loaded/unloaded
******************************************************************************
Dump file set for xxx.SYS_EXPORT_TABLE_08 is:
  /oracle/dmp/MEDICAL_CHECK_SYSINFO_H_4.dmp
Job "xxx"."SYS_EXPORT_TABLE_08" successfully completed at Fri Jun 18 16:35:26 2021 elapsed 0 00:11:08
[oracle@rac1 dmp]$ sqlplus xxx/xxx123890@xxxdb

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jun 18 16:37:44 2021
Version 19.11.0.0.0

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

Last Successful login time: Fri Jun 18 2021 16:26:59 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.11.0.0.0

SQL> select count(*) from dba_datapump_jobs;        

  COUNT(*)
----------
	 0

非并行普通导出，消耗34分钟，大小120G，比并行慢接近3倍。

[oracle@rac1 dmp]$ expdp xxx/xxx@xxx TABLES=MEDICAL_CHECK_SYSINFO_H directory=DMP dumpfile=MEDICAL_CHECK_SYSINFO_H.dmp logfile=log_test.log

Export: Release 19.0.0.0.0 - Production on Fri Jun 18 16:48:00 2021
Version 19.11.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "xxx"."SYS_EXPORT_TABLE_01":  xxx/********@xxxdb TABLES=MEDICAL_CHECK_SYSINFO_H directory=DMP dumpfile=MEDICAL_CHECK_SYSINFO_H.dmp logfile=log_test.log 
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
. . exported "xxx"."MEDICAL_CHECK_SYSINFO_H"             118.6 GB 3152056 rows
Master table "xxx"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for xxx.SYS_EXPORT_TABLE_01 is:
  /oracle/dmp/MEDICAL_CHECK_SYSINFO_H.dmp
Job "xxx"."SYS_EXPORT_TABLE_01" successfully completed at Fri Jun 18 17:22:54 2021 elapsed 0 00:34:53

[oracle@rac1 dmp]$ du -sh MEDICAL_CHECK_SYSINFO_H.dmp 
119G	MEDICAL_CHECK_SYSINFO_H.dmp

 

参考：https://www.linkedin.com/pulse/optimising-lob-export-import-performance-via-oracle-datapump-arya/

好记忆不如烂笔头abc
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Oracle导出Clob,Blob工具版本2
04-15
Oracle导出Clob,Blob工具 ，支持导出CLob工具版本2，解决上个版本导出时间有问题的bug
impdp 把表数据和索引分别导入不同的表空间
shitongshuo的博客
12-05 1558
impdp 把表数据和索引分别导入不同的表空间 一、数据导出 expdp test/test directory=dump_dir dumpfile=test.dmp logfile=test_expdp.log tables=userinfo ——利用expdp 语句导出具体数据，如果是导出整个用户下数据，去掉 tables 参数 二、把数据导入数据表空间 impdp test/test d...
expdp/impdp中exclude,include参数使用
ciqiangzhun84942的博客
07-03 809
exclude和include在导数据时可以指定是否需要导出或者不导出哪些对象 如：索引，表，过程，包，授权，约束 1.导出t,t1表数据，不需要导索引，约束 C:\Users\admin>expdp admin/a...
oracle include用法,expdp/impdp中exclude,include参数使用
weixin_42298622的博客
04-16 1704
exclude和include在导数据时可以指定是否需要导出或者不导出哪些对象如：索引，表，过程，包，授权，约束1.导出t,t1表数据，不需要导索引，约束C:\Users\admin>expdp admin/admin dumpfile=a.dmp logfile=b.log directory=mydir tables=t,t1 exclude=index,constraintExport...
expdp impdp中 exclude/include 的使用
anjichan4261的博客
12-02 1835
exclude和include参数能够在使用expdp或impdp是对特定的对象或对象类型进行筛选或过滤。比如因工作的需要导出特定的表或不导出特定 的表、视图以及存储过程、索引、约束、授权统计信息等等。下面将给出expdp或impdp使用exclude和include参数的方法和示例。 一、exclude/include参数用法： EXCLUDE=[obj...
oracle 数据泵导入库 不导入索引,truncate表后impdp导入该表时加exclude=index参数并不能排除索引数据的导入...
weixin_42502775的博客
04-03 1965
1.truncate表:SQL> truncate table GCADJUSTMENTMAIN;Table truncated.XIEZQ用户下只有一个表：SQL> SELECT segment_name, SUM (bytes) / 1024 / 10242 FROM dba_segments3 WHERE owner = 'XIEZQ' AND segment_name...
Oracle导出Clob,Blob工具
03-28
Oracle导出Clob,Blob等大字段工具，自己写的工具，方便大家下载使用
sqluldr2数据快速导出工具
10-27
导出工具，sqluldr2可以导出大数据量CSV文件，内含Windows和linux版本，请大家放心使用
clob数据库表结构如下
01-15
clob数据库表结构如下clob数据库表结构如下clob数据库表结构如下
jdbc 处理clob类型字段
08-19
主要是整合了jdbc处理clob类型的增删改查方法，有需要的同学可以看下
expdp 引起ORA-39095
01-18 179
今天expdp导出表的时候出现问题： [oracle@busdbr1] /busdmp 541> expdp system/xxx DIRECTORY =BUS_DMP tables=business.prpcin...
数据泵方式导入导出数据
chenling9274的博客
11-07 1725
一、关于数据泵方式 1.imp、exp导入导出缺陷 使用imp、exp进行导入导出时，如果导出时的表空间和导入时的表空间名称不一致，并且表中含有Blob、Clob等大字段时，这些含有大字段的表将无法导入。除非在导入前在新数据库中创建同名表空间，先导入再将表数据迁移到目标表空间；或者...
oracle导出clob表数据及表结构,数据库导出clob数据
weixin_35338620的博客
04-05 1336
PL/SQL Developer导入导出数据库方法及说明PL/SQL Developer是Oracle数据库中用于导入或导出数据库的主要工具，本文主要介绍了利用PL/SQL Developer导入和导出数据库的过程，并对导入或导出时的一些注意事项进行了说明，接下来我们就一一介绍。一、导出步骤1 tools ->export user objec...文章徐胖子2013-04-141064浏览...
数据泵导出时报错ORA-1422错误
ckawt40802的专栏
08-12 667
今天一个学习Oracle时间不长的同事在使用数据泵导出的时候碰到了这个错误。 由于前两天看到他在研究DUAL表，而且还问过我几个DUAL表相关的问题，所以看到这个错误后首先想到的就是问他是否向DUAL表中插入数据。...
在锁表情况下expdp导出数据
ckreglt13022的博客
05-29 491
在使用expdp导出应用表数据时，有时会有这种期望：该表在准备导出时数据就不会被修改，直到导出结束。针对这种情况，一般会在导出前对需要导出的表加锁，保证数据不能被修改。那么什么锁可以满足这种情况呢？没错，share锁： ...
Oracle rac ora29283,ORACLE RAC中expdp出现ORA-29283错误解决方法
weixin_28754365的博客
04-03 1479
一个脚本,正常运行了很久,突然之间就报错了脚本核心语句如下:expdp system/********@orclfy directory=expdir dumpfile=20200313.dmp full=y cluster=n logfile=20200313.log报错如下:Export: Release 19.0.0.0.0 - Production on Fri Mar 13 19:42:...
本次遇到ora06512的解决方法
热门推荐
池鑫洋
03-14 3万+
在使用pl/sql测试函数（本函数是想删除表的某一条数据）时，出现错误ora06512。解决方法：检查表是否被锁住，然后测试删除其他记录再回来删除就成功了可能原因：        1.这个表被锁住        2.在测试函数前，要先commit其它事务，pl/sql默认不是自动提交，只有退出程序或者手动commit才能提交             ...
模拟分批expdp导出BLOB数据
bing_yuan的博客
05-24 351
–创建存储图片的表 CREATE TABLE IMAGE_LOB (T_ID VARCHAR2 (5) NOT NULL,T_IMAGE BLOB NOT NULL); –创建存储图片的目录 CREATE OR REPLACE DIRECTORY IMAGES AS ‘/soft’; –在c：下自己建一个叫picture的文件夹 CREATE OR REPLACE PROCEDURE IMG_INSERT (TID VARCHAR2,FILENAME VARCHAR2) AS F_LOB BFILE;–文.
ORACLE 使用expdp按条件导出clob数据
congchangbei6601的博客
10-30 1472
现在有张表prt_template，表包含大字段，并且需要按指定条件导出。不能使用客户端直接导出，可以使用expdp按指定条件导出： 1）建立导出目录并授权： SQL> crea...
oracle 导出导入clob/blob
最新发布
06-28
要导出和导入Oracle数据库中的CLOB和BLOB数据类型，可以使用以下方法： 1. 使用Oracle自带的exp和imp工具导出和导入整个数据库或特定表的数据。在导出时，使用参数“file=clob_data.dmp”或“file=blob_data.dmp”...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值