Database Utilities (MOSC)

MOSC Banner

Pre checklist for export and import schema

edited Jan 20, 2020 9:03AM in Database Utilities (MOSC) 4 commentsAnswered

Hello all,

I'm planning to refresh dev database ( oracle 12C ) using expdp/impdp.

Prior to that, i need and input what's the complete checklist should i update in my workplan.

Here is the list;

1. expdp ABC schema

dumpfile=DATA_PUMP_DIR:ABC.dmp

logfile=DATA_PUMP_DIR:ABC.log

filesize=10G

schemas=ABC

2. run query to drop schema XYZ objects on target db

SELECT 'DROP '|| OBJECT_TYPE || ' ' ||OWNER||'.'||OBJECT_NAME||';'

FROM SYS.DBA_OBJECTS WHERE OWNER = 'ODSTRN' AND OBJECT_TYPE IN ('LOB','PACKAGE','SEQUENCE','VIEW','FUNCTION','PROCEDURE','SYNONYM','TRIGGER');

3. run impdp

directory=DATA_PUMP_DIR

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