exporting table BASELINE_REV 0 rows exported exporting table A_UI_WIDGET_PAGE 7 rows exported exporting table A_UI_WIDGET_CONFIG 0 rows exported exporting table A_UI_WIDGET 7 rows exported exporting table A_UI_PAGE 1 rows exported exporting table A_UI_BLOB_DATA 0 rows exported exporting table A_SUBSTANCE_ALIAS 0 rows exported exporting table A_PROJ_RSRC 0 rows exported exporting table A_DW_TXN_LOG 7845111 rows exported exporting table A_CONTENT_FOLDER_MAP 0 rows exported exporting table A_CONTENT_FOLDER 20 rows exported exporting table A_CLUSTER_CACHE_SYNCH_LOG 6670 rows exported exporting table AUTOSELECT_TEMP 0 rows exported exporting table AUTONUMBER 0 rows exported exporting table AUTH_FAILED 2228 rows exported exporting table AUTHORIZED_USER 0 rows exported exporting table ATTR_PREF 0 rows exported exporting table ATTACH_REDLINE 0 rows exported exporting table ATTACHMENT_MAP 66353 rows exported
exporting table ATTACHMENTS 0 rows exported exporting table ATTACHMENT 116488 rows exported exporting table APP_PROPERTY 0 rows exported exporting table APPROVAL_ITEMS 0 rows exported exporting table APPLIEDTO 152970 rows exported exporting table AGILE_FLEX 222023 rows exported exporting table AGILEUSER 323 rows exported exporting table AGILESEQUENCES 133 rows exported exporting table AGGREGATED_SUBSTANCE 0 rows exported exporting table ADMIN_HISTORY_DETAILS 8384 rows exported exporting table ADMIN_HISTORY 8384 rows exported exporting table ADMINMSATT 13078 rows exported
exporting table ADMINCRITERIA 829 rows exported exporting table ADMINCLOBATT 0 rows exported exporting table ACTIVITY_DEPENDENCY 0 rows exported exporting table ACTIVITY_BASELINE 0 rows exported exporting table ACTION_ITEM 0 rows exported exporting table ACCOUNT_LOCKOUT_NOTIFY 36 rows exported about to export AGILE’s tables via Conventional Path … exporting object type definitions for user AGILE exporting foreign function library names for user AGILE exporting pre-schema procedural objects and actions I think that export was the first one to complete since 2016, but what good is it if it can’t be imported?Ĭonnected to: Oracle Database 12c Release 12.1.0.1.0 – 64bit ProductionĮxport done in A元2UTF8 character set and AL16UTF16 NCHAR character set I need to get the test db back up and make sure this company has valid backups to restore from. I tried to import the db dmp but the import failed after BOM_RESULT. The export completed after nearly 24 hours, it ended up at 33.1gb!! Change history was huge 136542511 ! Let me know if you think the dmp file is ok.Īnd the server has 8gb RAM and plenty of disc space. I found one dmp file from 2016 on the server that was 4.89gb back then so I figured it would be around 9gb now but this is much larger. The company has been on agile since 2013. %ORACLE_HOME%\bin\sqlplus agile/%PW_AGILE% file=agile9exp120519.dmp log=agile9exp120519.log owner=agileĭo you think I should stop it? I’ve never seen a dmp file so big.
%ORACLE_HOME%\bin\sqlplus agile/%PW_AGILE% agile/%PW_AGILE% parfile=agile9exp.par Set ORACLE_HOME=D:\oracle\product\12.1.0\dbhome_1 I started an export last night at 7:00pm and it’s still running 12 hours later! It’s now 17.1gb and log still shows it is on change_history! I’ve never seen a db dmp so big.
0 kommentar(er)
