Database Utilities (MOSC)

MOSC Banner

How to exlude LOB types from data pump export

edited May 23, 2019 5:02AM in Database Utilities (MOSC) 4 commentsAnswered

Hi,

I have a 1.5TB database ver. 11.2.0.3 and I have to export all data exclude four tables that contain LOB columns.

The size of four tables in total is about 1.2GB. I tried to exclude these tables but the total estimated size is 1469GB (calculated in the beginning of expdp running)

The four tables that contain the LOB type are in the same schema.

expdp system/xxx directory=export_dir parfile=Z:\Export\export_parameters.par

export_parameters.par:

full=yes

exclude=table:"IN('schema.table_name','schema.table_name','schema.table_name','schema.table_name')"

dumpfile=yyy_%U.dmp

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