Home » RDBMS Server » Server Utilities » Schema level export with particular partition tables (Oracle 10g Suse 10 64 Bit)
icon4.gif  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

Previous Topic: Error During IMPDP
Next Topic: Loading Multiple Input files into multiple tables
Goto Forum:
  


Current Time: Thu Sep 24 04:10:26 CDT 2020