Skip to main content

Oracle datapump import only a package

In the par file INCLUDE/EXCLUDE parameters can be added in order to filter metadata. For instance only a package can be imported:

Content of the par file:
DIRECTORY = export_dir
DUMPFILE = exported_data.dmp
LOGFILE = import_only_package.log

import command here:
$ impdp schema_name_here@sid_name_here PARFILE=parfile.par


Popular posts from this blog

Sending Jboss Server Logs to Logstash Using Filebeat with Multiline Support

In addition to sending system logs to logstash, it is possible to add a prospector section to the filebeat.yml for jboss server logs. Sometimes jboss server.log has single events made up from several lines of messages. In such cases Filebeat should be configured for a multiline prospector.
Filebeat takes lines do not start with a date pattern (look at pattern in the multiline section "^[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}" and negate section is set to true) and combines them with the previous line that starts with a date pattern.

server.log file excerpt where DatePattern: yyyy-MM-dd-HH and ConversionPattern: %d %-5p [%c] %m%n
Logstash filter: