Поиск
  • mdvorkin

INCLUDE parameter of expdp

-- Export all public database links

expdp user/password full=y \

include=db_link:"in (select db_link from dba_db_links where owner = 'PUBLIC')"


-- Export one table

expdp user/password include=table:"in ('<TABLE_NAME>')"


-- Valid values for "INCLUDE" statement

select * from DATABASE_EXPORT_OBJECTS;

select * from SCHEMA_EXPORT_OBJECTS;

select * from TABLE_EXPORT_OBJECTS;

Просмотров: 0Комментариев: 0

Недавние посты

Смотреть все

After logon trigger - trace user sessions

-- Activate trace for sessions using after logon database trigger -- -- Tables: -- -- SYS.XX_LOGIN_TRACE_CONDITION - add here the conditions for activating trace -- SYS.XX_LOGIN_TRACED_SESSIONS - con