dsvmofs> expdp system/XXXXX parfile=auexpfulltts.dat
Export: Release 11.2.0.4.0 - Production on Wed Aug 17 05:29:16 2022
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31633: unable to create master table "SYSTEM.SYS_EXPORT_FULL_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1038
ORA-00372: file 7 cannot be modified at this time
ORA-01110: data file 7: '/OFSSITDATA2/oradata/owad01.dbf'
dsvmofs> cat auexpfulltts.dat
directory=dmpdir
metrics=y
dumpfile=xttsfulltts%U.dmp
filesize=1048576000
full=y
exclude=STATISTICS
logfile=expfulltts.log
parallel=8
transportable=always
version=12
dsvmofs>
Root cause : Customer has SYS related tables in OWAPUB Tablespace, We made OWAPUB readonly as pert of TTS Activity.
Solution : Moved the SYS related tables from OWAPUB tablespace to SYS.
Other alternative solutions
1. Before restarting the expdp check if there are orphan Data Pump jobs left in database. Use << Note 336014.1 >>
2. After clearing the orphaned jobs if you still see the errors, Upload output of below queries.
connect as sysdba
spool boxa.html
set pagesize 9999
set markup html on
select name from v$database;
SELECT * from v$version ;
SELECT distinct(length(addr)*4) "Word Size" from v$process;
SELECT owner,object_name,object_type,status from dba_objects where status = 'INVALID';
select owner,object_type,count(*) from dba_objects where status='INVALID' group by owner,object_type;
SELECT SUBSTR(comp_id,1,15) comp_id, status, SUBSTR(version,1,10) version, modified,
SUBSTR(comp_name,1,30) comp_name, substr(schema,1,15) as schema
FROM dba_registry order by comp_id;
select * from registry$history;
