Database Utilities (MOSC)

MOSC Banner

DBMS_DATAPUMP.METADATA_FILTER filet on table invalid argument

edited Apr 8, 2024 1:56PM in Database Utilities (MOSC) 4 commentsAnswered

DECLARE hdn1 NUMBER;
BEGIN
-- type d'action : export ou import
hdn1 := DBMS_DATAPUMP.open( operation=>'EXPORT', job_mode=>'SCHEMA', job_name=>null, version=>'19.0');

-- définition du nom du fichier d'export
DBMS_DATAPUMP.add_file( handle => hdn1, filename => 'export1.dmp', REUSEFILE => 1, directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_dump_file);
-- définition du nom du fichier de log
DBMS_DATAPUMP.add_file( handle => hdn1, filename => 'log_export1.log', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_log_file);
-- définition des schéma à exporter
DBMS_DATAPUMP.METADATA_FILTER(HANDLE=>hdn1,name => 'SCHEMA_LIST', value => '''SCHEMA1''');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center