Oracle11g data pump problem-CodePudding

DECLARE
- to create data pump handle to work
H1 NUMBER;
The begin
- create a user-defined data schema of the backup pump
H1:=dbms_datapump. Open (operation=& gt; 'EXPORT' job_mode=& gt; "Schema");
- define the storage file
Dbms_datapump. Add_file (handle=& gt; H1, filename=& gt; 'BDQN. DMP);
- define the filter conditions
Dbms_datapump. Metadata_filter (handle=& gt; H1, NAME=& gt; 'schema_expr, value=https://bbs.csdn.net/topics/>' in ' 'BDQN' ' ');
- start the session data pump
Dbms_datapump. Start_job (handle=& gt; H1);
- disconnect session data pump
Dbms_datapump. Detach (handle=& gt; H1);
The end;

O answer!!!!! How is this to return a responsibility excuse me, why is this case? How should change?

CodePudding user response:

The DIRECTORY defined?

CodePudding user response:

 DBMS_DATAPUMP. ADD_FILE (
Handle IN NUMBER, 
Filename IN VARCHAR2, 
The directory IN VARCHAR2, 
The filesize VARCHAR2 IN DEFAULT NULL, 
Filetype NUMBER IN DEFAULT DBMS_DATAPUMP. KU $_FILE_TYPE_DUMP_FILE), 
Reusefile NUMBER IN DEFAULT NULL;

The directory is the parameter must be clear,