Exporting Specific Tables Under SYS Schema Using Oracle expdp
When working with Oracle Data Pump (expdp), you may encounter issues exporting specific tables under the SYS schema. Below is a step-by-step example and explanation of why this happens.
Creating a Test Table
First, create a test table under the SYS schema to demonstrate the problem:
D:\app\product\11.1.0\db_1>sqlplus "/as sysdba"
...
Posted on Thu, 01 Oct 2026 16:40:01 +0000 by JohnnyBlaze