Database Utilities (MOSC)

MOSC Banner

Export efficiency

edited Mar 8, 2024 6:21PM in Database Utilities (MOSC) 4 commentsAnswered ✓

Hello All,

running Oracle 19.21 CDB/PDB

On RHEL 8.8

I am attempting to make an export more efficient. I've heard that taking a daily export is fast for data recovery. I have opinions on that but thats besides the point.

Objective: I only want to export application schema data. Nothing oracle owned. I want it to be modular, usable in any pluggable database regardless of application schema name.

I have attempted a few different times, making modifications based on errors but still wont run. It seems that FULL=N makes it a schema level export and I dont seem to be able to exclude schemas in the parameter file at schema level.

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