Schema level export with particular partition tables [message #559991] |
Sun, 08 July 2012 23:29 |
burasami
Messages: 20 Registered: April 2010
|
Junior Member |
|
|
Hi All,
I have used the following option to export schema level with partition tables
YYYYY/********@devchn schemas=YYYYY EXCLUDE=TABLE:" IN('ACCOUNT_STATEMENT_HISTORY','CUSTOMER_IMAGE','XAPI_ACTIVITY_HISTORY','GL_ACCOUNT_SUMMARY$AUD','GL_ACCOUNT_HISTORY:GL_ACCT_HIST_PAR T1','GL_ACCOUNT_HISTORY:GL_ACCT_HIST_PART2','GL_ACCOUNT_HISTORY:GL_ACCT_HIST_PART3','GL_ACCOUNT_HISTORY:GL_ACCT_HIST_PART4','GL_ACCOU NT_HISTORY:GL_ACCT_HIST_PART5','GL_ACCOUNT_HISTORY:GL_ACCT_HIST_PART6','GL_ACCOUNT_HISTORY:GL_ACCT_HIST_PART7','DEPOSIT_ACCOUNT_HISTO RY:DEP_ACCT_HIST1','DEPOSIT_ACCOUNT_HISTORY:DEP_ACCT_HIST2', 'DEPOSIT_ACCOUNT_HISTORY:DEP_ACCT_HIST3','TXN_JOURNAL:TRX_JOURN_PART1','TXN_JOURNAL:TRX_JOURN_PART2')" directory=DUMPDIR1 dumpfile=MSB_06-July-2012.dmp logfile=exp_MSB_06-July-2012.log
but its not work..
Log file
. . exported "YYYYY."."TXN_JOURNAL":"TRX_JOURN_PART3" 1.801 GB 6650371 rows
. . exported "YYYYY."."EVENT_JOURNAL" 1.533 GB 15930785 rows
. . exported "YYYYY."."LOAN_ACCOUNT$AUD" 1.287 GB 6339368 rows
. . exported "YYYYY."."GL_ACCOUNT_HISTORY":"GL_ACCT_HIST_PART6" 1.212 GB 5860272 rows
. . exported "YYYYY."."GL_ACCOUNT_HISTORY":"GL_ACCT_HIST_PART5" 1.102 GB 5363721 rows
. . exported "YYYYY."."DEPOSIT_ACCOUNT_HISTORY":"DEP_ACCT_HIST3" 1.055 GB 5530280 rows
. . exported "YYYYY."."GL_ACCOUNT_HISTORY":"GL_ACCT_HIST_PART4" 929.4 MB 4513889 rows
. . exported "YYYYY."."DP_ACCT_INTEREST_HISTORY" 925.0 MB 7002553 rows
. . exported "YYYYY."."GL_ACCOUNT_HISTORY":"GL_ACCT_HIST_PART2" 909.8 MB 4441940 rows
. . exported "YYYYY."."GL_ACCOUNT_HISTORY":"GL_ACCT_HIST_PART3" 768.3 MB 3786671 rows
. . exported "YYYYY."."ACCOUNT$AUD" 709.8 MB 4348526 rows
. . exported "YYYYY."."EVENT_CHARGE_JOURNAL" 663.9 MB 5303756 rows
. . exported "YYYYY."."DP_ACCT_CYCLE_STAT_HIST" 655.4 MB 4389715 rows
. . exported "YYYYY."."DP_ACCT_PERIOD_CYCLE_STAT_HIST" 569.1 MB 3733176 rows
. . exported "YYYYY."."DP_ACCT_CHARGE_CYCLE_STAT_HIST" 535.4 MB 3712447 rows
. . exported "YYYYY."."GL_ACCOUNT_HISTORY":"GL_ACCT_HIST_PART7" 473.3 MB 2238240 rows
. . exported "YYYYY."."WF_WORK_ITEM_HISTORY" 474.4 MB 1887956 rows
. . exported "YYYYY."."OFFLINE_OUTBOUND_TXN_LOG" 478.4 MB 32803 rows
. . exported "YYYYY."."OPERATIONAL_SERVICE_ERROR_LOG" 291.8 MB 55333 rows
. . exported "YYYYY."."TXN_JOURNAL":"TRX_JOURN_PART1" 350.3 MB 1352267 rows
. . exported "YYYYY."."DEPOSIT_ACCOUNT_STAT" 313.6 MB 414942 rows
. . exported "YYYYY."."CORRESPONDENCE_QUEUE_BK" 295.6 MB 1816383 rows
. . exported "YYYYY."."EXT_TXN_JOURNAL" 255.6 MB 1234290 rows
. . exported "YYYYY."."PERSONAL_CUSTOMER$AUD" 244.7 MB 1018705 rows
. . exported "YYYYY."."GL_ACCOUNT_STAT" 228.3 MB 873915 rows
. . exported "YYYYY."."TXN_JOURNAL":"TRX_JOURN_PART2" 228.8 MB 855180 rows
. . exported "YYYYY."."DEPOSIT_ACCOUNT_HISTORY":"DEP_ACCT_HIST1" 210.5 MB 1119932 rows
. . exported "YYYYY."."USER_ROLE_ALERT" 180.9 MB 3059052 rows
. . exported "YYYYY."."CUSTOMER$AUD" 172.7 MB 1005897 rows
. . exported "YYYYY."."DEPOSIT_ACCOUNT_HISTORY":"DEP_ACCT_HIST2" 162.3 MB 837967 rows
. . exported "YYYYY."."DEPOSIT_ACCOUNT_SUMMARY" 160.7 MB 414942 rows
. . exported "YYYYY."."CUSTOMER_IMAGE_HISTORY" 142.0 MB 10085 rows
. . exported "YYYYY."."SYSUSER$AUD" 137.9 MB 986069 rows
. . exported "YYYYY."."TXN_BATCH_ITEM$AUD" 143.9 MB 893961 rows
. . exported "YYYYY."."ALERT" 130.8 MB 652573 rows
. . exported "YYYYY."."EXT_DP_ACCOUNT_SUMMARY" 132.3 MB 336115 rows
. . exported "YYYYY."."GL_ACCOUNT_HISTORY":"GL_ACCT_HIST_PART1" 132.7 MB 681899 rows
. . exported "YYYYY."."DEPOSIT_ACCOUNT_INTEREST" 113.0 MB 835126 rows
. . exported "YYYYY."."EXT_DP_ACCOUNT_INTEREST" 112.3 MB 625117 rows
. . exported "YYYYY."."GL_ACCOUNT_SUMMARY" 103.5 MB 873885 rows
. . exported "YYYYY."."DP_ACCT_INTEREST_TIER_HISTORY" 102.4 MB 1413589 rows
. . exported "YYYYY."."GL_ACCOUNT_MONTHLY_STAT" 98.52 MB 852631 rows
. . exported "YYYYY."."GL_ACCOUNT_QUARTERLY_STAT" 98.45 MB 852630 rows
. . exported "YYYYY."."GL_ACCOUNT_YEARLY_STAT" 98.47 MB 852630 rows
. . exported "YYYYY."."LN_ACCT_REPMNT_EVENT" 91.53 MB 902496 rows
. . exported "YYYYY."."WF_WORK_ITEM_CHKLST_RESP" 83.03 MB 538855 rows
. . exported "YYYYY."."DEPOSIT_ACCOUNT$AUD" 79.53 MB 450801 rows
. . exported "YYYYY."."ACCOUNT_CHEQUE_INVENTORY" 73.38 MB 910879 rows
. . exported "YYYYY."."EXT_DP_ACCOUNT_INTEREST_TIER" 71.44 MB 670870 rows
. . exported "YYYYY."."PENDING_TXN_JOURNAL" 44.14 MB 9578 rows
. . exported "YYYYY."."CUSTOMER" 67.22 MB 405785 rows
. . exported "YYYYY."."TXN_BATCH_ITEM" 66.98 MB 458442 rows
. . exported "YYYYY."."ACCOUNT" 58.82 MB 443064 rows
. . exported "YYYYY."."ACCOUNT_CYCLIC_CHARGE" 56.00 MB 405963 rows
. . exported "YYYYY."."EXT_CUSTOMER" 57.16 MB 321364 rows
. . exported "YYYYY."."EXT_LN_ACCT_REPMNT_EVENT" 61.50 MB 437790 rows
. . exported "YYYYY."."ORGANISATION_CUSTOMER$AUD" 49.84 MB 241014 rows
. . exported "YYYYY."."OFFLINE_ASYNCH_QUEUE" 52.14 MB 3562 rows
. . exported "YYYYY."."OPERATIONAL_SVCE_MAN_RUN_HIST" 47.91 MB 766864 rows
. . exported "YYYYY."."DEPOSIT_ACCOUNT_INTEREST_TIER" 46.44 MB 670938 rows
. . exported "YYYYY."."LN_ACCT_PERIOD_CYCLE_STAT_HIST" 42.09 MB 260703 rows
. . exported "YYYYY."."ADDRESS" 41.39 MB 411753 rows
. . exported "YYYYY."."EXT_ACCOUNT_RELATIONSHIP" 41.98 MB 305353 rows
EXCLUDE option is not working for partition tables.. But its working fine for other tables
examples
EXCLUDE=TABLE:"IN('ACCOUNT_STATEMENT_HISTORY','CUSTOMER_IMAGE','XAPI_ACTIVITY_HISTORY','GL_ACCOUNT_SUMMARY$AUD'
the above part is working fine..
But.
EXCLUDE=TABLE:"IN('GL_ACCOUNT_HISTORY:GL_ACCT_HIST_PART5','GL_ACCOUNT_HISTORY:GL_ACCT_HIST_PART6')
the above exclude option is not working.. data's from the table are exported into the dump.. Help me how to archive the task.
Thanks & Regards
Sami.
[Updated on: Mon, 09 July 2012 01:14] by Moderator Report message to a moderator
|
|
|