Database Utilities (MOSC)

MOSC Banner

expdp excluding 70 tables data

edited Mar 14, 2013 4:47AM in Database Utilities (MOSC) 5 commentsAnswered
Hi!I am trying to undertake an datapump expdp but excluding table data from 70 tables (want to have the DDL metadata but exclude table data) but include all other objects from the schemas being exported.The 70 table names can be captured from a query below

select * from all_tables where table_name like '%MESSAGES_%' or table_name like '%_MESSAGES_%'or table_name like ' %_MESSAGES_REPEAT%'or table_name like' %_MESSAGES_HISTORY%' or table_name like '%STIP_ACCOUNT%' or table_name like '%STIP_CLIENTS%' or table_name like' %STIP_EVENTS_O%' or table_name like ' %STIP_CARD%';

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