Sample Header Ad - 728x90

Oracle 19c and 21c expdp exports dumpfile of 308kb without any content

0 votes
1 answer
595 views
Trying to export schema using the following command on several Oracle instances: two 19c and one 21c
$ expdp mySchema/myPwd@ORCL
- Adding CONTENT=ALL or SCHEMA=mySchema or SCHEMA=MYSCHEMA or DUMPFILE=dumpfile.dmp to _expdp_ command arguments does not help. - The user used in login is a DBA. - Tablespace is Users and temporary is Temp with Unlimited space and disk space has plenty of free space. - There is actual data in tables and there are hundreds of tables in the schema. All export jobs succeed without any errors, except that all dumps are 308kb but one 19c it actually dumps schema as dump file is ~100mb. Data Pump Wizard also creates dump 308 kb file. In case, DEFERRED_SEGMENT_CREATION parameter is True. The export log is:
Export: Release 19.0.0.0.0 - Production on Thu Feb 22 11:22:09 2024
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production

Warning: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.

Starting "MYSCHEMA"."SYS_EXPORT_SCHEMA_01":  MYSCHEMA/********@oracle21c SCHEMAS=MYSCHEMA DUMPFILE=ded 
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Master table "MYSCHEMA"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for MYSCHEMA.SYS_EXPORT_SCHEMA_01 is:
  ...\DPDUMP\DED.DMP
Job "MYSCHEMA "."SYS_EXPORT_SCHEMA_01" successfully completed at Thu Feb 22 11:22:51 2024 elapsed 0 00:00:39
What may be wrong with the schema as other schema export as expected creating hundreds of MB dump file but in this case dump has no content?
Asked by Vy8 (1 rep)
Feb 22, 2024, 04:50 PM
Last activity: Apr 19, 2025, 06:01 PM