Database Administration (MOSC)

MOSC Banner

DataPump imports and redo generated

edited Nov 10, 2009 12:06AM in Database Administration (MOSC) 4 commentsAnswered
 Can redo logging be turned off by the import DataPump (impdp) utility? We have a job which exports a schema, drops the schema with cascade, creates the schema and imports the fresh data using impdp. All this is done from a shell script with embedded sql as needed. Currently this generates a lot of redo and along wih the redo, a lot of archive log files. In researching this issue, I discovered the hidden parameter _disable_logging (if set to true, logging is disabled). A lot of articles indicate this should not be used, however almost all the articles focused on setting

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