datapump export - expdp takes long time
Oracle DB: 10.2.0.4Linux:Red Hat Enterprise Linux Server release 5.8 (Tikanga)
DB use: Cognos Metadata
DB size: 23 gb
Last week when I ran an export using datapump - expdp that took 3 hours and 45 minutes.
I am running the same export right now with the TRACE=480300 parameter. I was watching the export and realize that one of the table that has a CLOB column took a while and this table is not big. it has 30116 rows with two column and one being a clob and the table size is 138MB. This database has many BLOB and CLOB columns. Is there a bug or known issue with CLOB/BLOB columns exports? BTW... the import completed in 1 hour and 30 minutes.
DB use: Cognos Metadata
DB size: 23 gb
Last week when I ran an export using datapump - expdp that took 3 hours and 45 minutes.
I am running the same export right now with the TRACE=480300 parameter. I was watching the export and realize that one of the table that has a CLOB column took a while and this table is not big. it has 30116 rows with two column and one being a clob and the table size is 138MB. This database has many BLOB and CLOB columns. Is there a bug or known issue with CLOB/BLOB columns exports? BTW... the import completed in 1 hour and 30 minutes.
1