OraFAQ Forum: Server Utilities » Partition table import through Data Pump

Home » RDBMS Server » Server Utilities » Partition table import through Data Pump (oracle, 11g, windows 2008 server.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Partition table import through Data Pump [message #579284]

Mon, 11 March 2013 02:13

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hello All,

please guide me to IMPORT PARTITION TABLE Through Data Pump.

I have a table with RANGE PARTITION.
I wanted to import this into another server with the same partitions.

But when I imported the table, The table created with the Partition but the data is not inserted in partition wise.

But I could see the Entire table's ROW COUNT.

Regards
Muthu

Report message to a moderator

Re: Partition table import through Data Pump [message #579289 is a reply to message #579284]

Mon, 11 March 2013 02:37

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You did something wrong, fix it and it will be OK.
And post in the CORRECT forum.

Regards
Michel

Report message to a moderator

Re: Partition table import through Data Pump [message #579309 is a reply to message #579289]

Mon, 11 March 2013 04:30

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Michel,

Here is my code.

EXPORT LOG FILE

;;; 
Export: Release 10.2.0.4.0 - 64bit Production on Friday, 08 March, 2013 17:33:54

Copyright (c) 2003, 2007, Oracle.  All rights reserved.
;;; 
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "BKPUSR"."SYS_EXPORT_TABLE_02":  bkpusr/******** directory='EXPBKUP' dumpfile=TICKER_INTRA_08-03-2013.dmp logfile=TICKER_INTRA_08-03-2013.log tables=TICKER.BSEINTRADAYPRICES,TICKER.NSEINTRADAYPRICES 
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 9.123 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130220"  134.3 MB 1729527 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121102"  77.72 MB  995605 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121106"  76.07 MB  975142 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121107"  76.91 MB  986733 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121109"  76.24 MB  977721 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121116"  75.87 MB  971833 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121120"  76.22 MB  978376 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121127"  76.62 MB  982813 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121130"  78.51 MB 1006696 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121205"  79.62 MB 1017460 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121206"  76.99 MB  986000 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121207"  80.14 MB 1026418 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121210"  78.83 MB 1008953 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121211"  79.60 MB 1019271 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121212"  78.22 MB 1002828 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121213"  78.83 MB 1009658 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121214"  77.48 MB  994491 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121217"  77.76 MB  996672 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121218"  78.44 MB 1005733 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121219"  79.85 MB 1022986 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121220"  76.48 MB  980113 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121226"  76.99 MB  987849 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121227"  75.72 MB  972346 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121228"  76.80 MB  985189 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121231"  76.69 MB  984287 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130101"  76.97 MB  986963 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130102"  80.59 MB 1032119 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130103"  80.40 MB 1029606 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130104"  79.12 MB 1013650 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130107"  80.98 MB 1036037 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130108"  78.54 MB 1005500 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130109"  79.98 MB 1023845 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130110"  79.97 MB 1022940 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130111"  77.98 MB  998879 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130114"  77.11 MB  989472 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130115"  78.09 MB 1001172 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130116"  78.30 MB 1003118 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130117"  77.53 MB  994992 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130118"  78.10 MB 1002346 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130121"  77.58 MB  994076 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130122"  77.62 MB  995506 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130123"  77.78 MB  998220 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130124"  76.05 MB  976971 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121101"  73.64 MB  945401 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121108"  74.66 MB  957855 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121115"  75.17 MB  964156 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121119"  71.88 MB  922576 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121121"  74.55 MB  957496 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121122"  74.69 MB  958078 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121123"  74.18 MB  951227 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121126"  75.50 MB  967546 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121129"  72.54 MB  929312 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121203"  73.25 MB  937746 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121204"  74.88 MB  958831 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121221"  73.48 MB  941145 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130125"  75.56 MB  970361 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130128"  75.02 MB  965317 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130129"  74.82 MB  960590 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130130"  75.23 MB  967942 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130131"  74.46 MB  957090 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130201"  73.72 MB  947443 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130204"  75.55 MB  971521 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130205"  74.80 MB  962978 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130206"  75.26 MB  967386 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130207"  74.63 MB  960362 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130208"  74.05 MB  952712 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130211"  75.20 MB  966301 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130212"  74.27 MB  957500 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130213"  75.37 MB  971440 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130214"  74.15 MB  956339 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130215"  74.99 MB  967664 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130218"  74.35 MB  961756 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130219"  71.77 MB  925831 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130221"  73.55 MB  947244 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130222"  73.71 MB  953896 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130225"  71.78 MB  928577 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130226"  73.51 MB  952014 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130227"  73.16 MB  947263 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130228"  72.80 MB  943171 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130301"  73.31 MB  951608 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130304"  72.38 MB  939179 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130305"  74.17 MB  961180 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130306"  74.26 MB  962322 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130307"  74.12 MB  960463 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20130308"  75.43 MB  972659 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121112"  68.37 MB  874605 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130220"  18.91 MB  246269 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121127"  16.24 MB  211253 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121107"  14.64 MB  191618 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130221"  14.53 MB  188869 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121108"  14.11 MB  184366 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121126"  13.87 MB  181777 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121206"  13.74 MB  177704 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121210"  14.42 MB  187605 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130107"  13.81 MB  179555 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130108"  13.71 MB  178538 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130121"  13.98 MB  181800 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130214"  14.10 MB  185914 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130219"  13.99 MB  185180 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130301"  13.78 MB  182118 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121101"  13.51 MB  176733 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121109"  12.83 MB  166923 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121115"  13.00 MB  169750 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121119"  13.19 MB  172188 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121120"  13.14 MB  171383 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121129"  13.28 MB  172561 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121204"  13.06 MB  169625 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121205"  13.44 MB  174915 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121211"  13.16 MB  170931 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121212"  13.43 MB  175193 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121213"  13.65 MB  178152 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121214"  13.26 MB  173050 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121217"  13.14 MB  171289 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121218"  13.28 MB  173279 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121219"  13.14 MB  171062 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121220"  12.92 MB  168339 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130101"  13.03 MB  170101 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130109"  13.04 MB  169315 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130110"  13.45 MB  174981 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130116"  12.95 MB  168881 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130123"  13.16 MB  172002 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130124"  13.35 MB  174282 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130125"  13.18 MB  172558 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130130"  13.16 MB  172363 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130131"  13.25 MB  173764 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130201"  12.93 MB  169067 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130204"  12.99 MB  169979 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130205"  12.86 MB  168427 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130206"  12.98 MB  169972 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130208"  13.62 MB  178746 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130213"  13.37 MB  175727 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130215"  13.05 MB  170946 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130218"  13.58 MB  179073 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130222"  13.09 MB  172330 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130225"  13.32 MB  175307 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130226"  13.12 MB  172612 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130227"  12.94 MB  169836 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130228"  13.00 MB  171225 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130304"  13.21 MB  174230 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130307"  12.92 MB  169646 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121102"  12.05 MB  156218 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121105"  12.62 MB  164987 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121121"  12.54 MB  163849 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121123"  12.60 MB  164357 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121130"  12.44 MB  161561 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121203"  12.36 MB  160556 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121221"  12.38 MB  160867 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121226"  12.18 MB  158242 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121228"  12.06 MB  156521 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130102"  12.75 MB  165528 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130104"  12.20 MB  157914 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130115"  12.05 MB  156105 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130117"  12.69 MB  164589 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130122"  12.59 MB  163490 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130305"  12.12 MB  159004 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121106"  11.17 MB  144359 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121116"  11.68 MB  152183 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121122"  11.76 MB  153146 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121207"  11.91 MB  153581 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121227"  11.71 MB  151886 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121231"  11.86 MB  153834 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130103"  11.74 MB  151548 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130111"  11.93 MB  154548 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130114"  11.74 MB  152277 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130118"  11.32 MB  146358 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130128"  11.89 MB  155046 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130129"  11.52 MB  150281 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130207"  11.72 MB  152568 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130211"  11.82 MB  154115 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130212"  11.74 MB  153421 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130306"  11.75 MB  154313 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20130308"  10.92 MB  141756 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121112"  10.12 MB  130162 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121105"  3.439 MB   44110 rows
. . exported "TICKER"."NSEINTRADAYPRICES":"NSE_PRICES_20121224"  2.962 MB   40757 rows
. . exported "TICKER"."BSEINTRADAYPRICES":"BSE_PRICES_20121224"  1.668 MB   21343 rows
Master table "BKPUSR"."SYS_EXPORT_TABLE_02" successfully loaded/unloaded
******************************************************************************
Dump file set for BKPUSR.SYS_EXPORT_TABLE_02 is:
  F:\EXPBKUP\DMP\TICKER_INTRA_08-03-2013.DMP
Job "BKPUSR"."SYS_EXPORT_TABLE_02" successfully completed at 17:45:01

IMPORT LOG FILE

;;; 
Import: Release 10.2.0.3.0 - 64bit Production on Saturday, 09 March, 2013 9:04:10

Copyright (c) 2003, 2005, Oracle.  All rights reserved.
;;; 
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Master table "BKPUSR"."SYS_IMPORT_TABLE_03" successfully loaded/unloaded
Starting "BKPUSR"."SYS_IMPORT_TABLE_03":  BKPUSR/******** directory=EXPBKUP dumpfile=TICKER_INTRA_08-03-2013.DMP logfile=TICKER_INTRA_08-03-2013.log REMAP_SCHEMA=TICKER:DPBOSS REMAP_TABLESPACE=TICKER:DPBOSSTABLE tables=TICKER.BSEINTRADAYPRICES INCLUDE=TABLE 
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130220"  134.3 MB 1729527 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121102"  77.72 MB  995605 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121106"  76.07 MB  975142 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121107"  76.91 MB  986733 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121109"  76.24 MB  977721 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121116"  75.87 MB  971833 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121120"  76.22 MB  978376 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121127"  76.62 MB  982813 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121130"  78.51 MB 1006696 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121205"  79.62 MB 1017460 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121206"  76.99 MB  986000 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121207"  80.14 MB 1026418 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121210"  78.83 MB 1008953 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121211"  79.60 MB 1019271 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121212"  78.22 MB 1002828 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121213"  78.83 MB 1009658 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121214"  77.48 MB  994491 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121217"  77.76 MB  996672 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121218"  78.44 MB 1005733 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121219"  79.85 MB 1022986 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121220"  76.48 MB  980113 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121226"  76.99 MB  987849 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121227"  75.72 MB  972346 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121228"  76.80 MB  985189 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121231"  76.69 MB  984287 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130101"  76.97 MB  986963 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130102"  80.59 MB 1032119 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130103"  80.40 MB 1029606 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130104"  79.12 MB 1013650 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130107"  80.98 MB 1036037 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130108"  78.54 MB 1005500 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130109"  79.98 MB 1023845 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130110"  79.97 MB 1022940 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130111"  77.98 MB  998879 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130114"  77.11 MB  989472 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130115"  78.09 MB 1001172 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130116"  78.30 MB 1003118 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130117"  77.53 MB  994992 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130118"  78.10 MB 1002346 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130121"  77.58 MB  994076 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130122"  77.62 MB  995506 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130123"  77.78 MB  998220 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130124"  76.05 MB  976971 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121101"  73.64 MB  945401 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121108"  74.66 MB  957855 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121115"  75.17 MB  964156 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121119"  71.88 MB  922576 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121121"  74.55 MB  957496 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121122"  74.69 MB  958078 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121123"  74.18 MB  951227 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121126"  75.50 MB  967546 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121129"  72.54 MB  929312 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121203"  73.25 MB  937746 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121204"  74.88 MB  958831 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121221"  73.48 MB  941145 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130125"  75.56 MB  970361 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130128"  75.02 MB  965317 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130129"  74.82 MB  960590 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130130"  75.23 MB  967942 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130131"  74.46 MB  957090 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130201"  73.72 MB  947443 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130204"  75.55 MB  971521 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130205"  74.80 MB  962978 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130206"  75.26 MB  967386 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130207"  74.63 MB  960362 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130208"  74.05 MB  952712 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130211"  75.20 MB  966301 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130212"  74.27 MB  957500 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130213"  75.37 MB  971440 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130214"  74.15 MB  956339 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130215"  74.99 MB  967664 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130218"  74.35 MB  961756 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130219"  71.77 MB  925831 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130221"  73.55 MB  947244 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130222"  73.71 MB  953896 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130225"  71.78 MB  928577 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130226"  73.51 MB  952014 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130227"  73.16 MB  947263 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130228"  72.80 MB  943171 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130301"  73.31 MB  951608 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130304"  72.38 MB  939179 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130305"  74.17 MB  961180 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130306"  74.26 MB  962322 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130307"  74.12 MB  960463 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20130308"  75.43 MB  972659 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121112"  68.37 MB  874605 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121105"  3.439 MB   44110 rows
. . imported "DPBOSS"."BSEINTRADAYPRICES":"BSE_PRICES_20121224"  1.668 MB   21343 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/TRIGGER
ORA-39082: Object type TRIGGER:"DPBOSS"."INS_BEF_BSEINTRDAYPRCS" created with compilation warnings
ORA-39082: Object type TRIGGER:"DPBOSS"."INS_BEF_BSEINTRDAYPRCS" created with compilation warnings
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39083: Object type TABLE_STATISTICS failed to create with error:
ORA-06550: line 12, column 17:
PL/SQL: ORA-00917: missing comma
ORA-06550: line 4, column 137:
PL/SQL: SQL Statement ignored
ORA-06550: line 20, column 17:
PL/SQL: ORA-00917: missing comma
ORA-06550: line 12, column 180:
PL/SQL: SQL Statement ignored
ORA-06550: line 28, column 17:
PL/SQL: ORA-00917: missing comma
ORA-06550: line 20, column 176:
PL/SQL: SQL Statement ignored
ORA-06550: line 36, column 17:
PL/SQL: ORA-00917: missing comma
Job "BKPUSR"."SYS_IMPORT_TABLE_03" completed with 3 error(s) at 09:18:39

What is wrong in this.

Regards
Muthu

[EDITED by LF: applied [spoiler] tags] 72.38 MB 939179 rows
. . exported 13.28 MB 172561 rows
. . exported NSEINTRADAYPRICESDPBOSS

[Updated on: Mon, 11 March 2013 08:15] by Moderator

Report message to a moderator

Re: Partition table import through Data Pump [message #579311 is a reply to message #579309]

Mon, 11 March 2013 05:04

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The Oracle versions incompatibillity.

You can also import without the statistics and compute the statistics afterwards.

Regards
Michel

Report message to a moderator

Re: Partition table import through Data Pump [message #579316 is a reply to message #579311]

Mon, 11 March 2013 05:35

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Michel,

Thanks for your reply.

How we can import without Statistics?

Kindly help me out further.

I tried with another server, which is having the same oracle version, but still having the same problem.

Import log

;;; 
Import: Release 10.2.0.4.0 - 64bit Production on Saturday, 09 March, 2013 12:52:55

Copyright (c) 2003, 2007, Oracle.  All rights reserved.
;;; 
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "BKPUSR"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "BKPUSR"."SYS_IMPORT_TABLE_01":  BKPUSR/******** directory=EXPBKUP dumpfile=TICKER_INTRA_08-03-2013.DMP logfile=TICKER_INTRA_NSEINTRA_08-03-2013.log REMAP_SCHEMA=TICKER:MCX_HIST REMAP_TABLESPACE=TICKER:MCX tables=TICKER.NSEINTRADAYPRICES INCLUDE=TABLE 
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130220"  18.91 MB  246269 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121127"  16.24 MB  211253 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121107"  14.64 MB  191618 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130221"  14.53 MB  188869 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121108"  14.11 MB  184366 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121126"  13.87 MB  181777 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121206"  13.74 MB  177704 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121210"  14.42 MB  187605 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130107"  13.81 MB  179555 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130108"  13.71 MB  178538 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130121"  13.98 MB  181800 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130214"  14.10 MB  185914 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130219"  13.99 MB  185180 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130301"  13.78 MB  182118 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121101"  13.51 MB  176733 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121109"  12.83 MB  166923 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121115"  13.00 MB  169750 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121119"  13.19 MB  172188 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121120"  13.14 MB  171383 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121129"  13.28 MB  172561 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121204"  13.06 MB  169625 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121205"  13.44 MB  174915 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121211"  13.16 MB  170931 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121212"  13.43 MB  175193 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121213"  13.65 MB  178152 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121214"  13.26 MB  173050 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121217"  13.14 MB  171289 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121218"  13.28 MB  173279 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121219"  13.14 MB  171062 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121220"  12.92 MB  168339 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130101"  13.03 MB  170101 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130109"  13.04 MB  169315 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130110"  13.45 MB  174981 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130116"  12.95 MB  168881 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130123"  13.16 MB  172002 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130124"  13.35 MB  174282 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130125"  13.18 MB  172558 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130130"  13.16 MB  172363 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130131"  13.25 MB  173764 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130201"  12.93 MB  169067 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130204"  12.99 MB  169979 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130205"  12.86 MB  168427 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130206"  12.98 MB  169972 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130208"  13.62 MB  178746 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130213"  13.37 MB  175727 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130215"  13.05 MB  170946 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130218"  13.58 MB  179073 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130222"  13.09 MB  172330 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130225"  13.32 MB  175307 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130226"  13.12 MB  172612 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130227"  12.94 MB  169836 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130228"  13.00 MB  171225 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130304"  13.21 MB  174230 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130307"  12.92 MB  169646 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121102"  12.05 MB  156218 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121105"  12.62 MB  164987 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121121"  12.54 MB  163849 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121123"  12.60 MB  164357 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121130"  12.44 MB  161561 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121203"  12.36 MB  160556 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121221"  12.38 MB  160867 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121226"  12.18 MB  158242 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121228"  12.06 MB  156521 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130102"  12.75 MB  165528 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130104"  12.20 MB  157914 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130115"  12.05 MB  156105 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130117"  12.69 MB  164589 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130122"  12.59 MB  163490 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130305"  12.12 MB  159004 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121106"  11.17 MB  144359 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121116"  11.68 MB  152183 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121122"  11.76 MB  153146 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121207"  11.91 MB  153581 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121227"  11.71 MB  151886 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121231"  11.86 MB  153834 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130103"  11.74 MB  151548 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130111"  11.93 MB  154548 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130114"  11.74 MB  152277 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130118"  11.32 MB  146358 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130128"  11.89 MB  155046 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130129"  11.52 MB  150281 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130207"  11.72 MB  152568 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130211"  11.82 MB  154115 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130212"  11.74 MB  153421 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130306"  11.75 MB  154313 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20130308"  10.92 MB  141756 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121112"  10.12 MB  130162 rows
. . imported "MCX_HIST"."NSEINTRADAYPRICES":"NSE_PRICES_20121224"  2.962 MB   40757 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/TRIGGER
ORA-39083: Object type TRIGGER failed to create with error:
ORA-00942: table or view does not exist
Failing sql is:
CREATE TRIGGER "MCX_HIST"."INS_AFT_NSEINTRDAYPRCS" AFTER
INSERT ON TICKER.NSEINTRADAYPRICES FOR EACH ROW
DECLARE
     ld_DateTime     Date ;
     ln_ClosePrice   Number ;
     ls_SecurityCode Varchar2(21) ;
BEGIN
     SELECT DATETIME INTO ld_DateTime FROM NSECURRENTPRICES WHERE Ticker = trim(upper(:new.Ticker));
     IF ld_DateTime < :new.DateTime Then
          BEGIN
               Select S
ORA-39083: Object type TRIGGER failed to create with error:
ORA-00942: table or view does not exist
Failing sql is:
CREATE TRIGGER "MCX_HIST"."INS_BEF_NSEINTRDAYPRCS" BEFORE
INSERT ON TICKER.NSEINTRADAYPRICES FOR EACH ROW
DECLARE
    tempTicker        varchar2(30);
    tempPreOpenPrice  number;
    tempNoOfTrades    number;
    tempPrevClose     number;
    tempSecurityCode  varchar2(21);
BEGIN
    tempTicker := Upper(Trim(:new.Ticker));
    BEGIN
        Select SecurityCode into tempSecurityCode from Sec
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39083: Object type TABLE_STATISTICS failed to create with error:
ORA-06550: line 12, column 17:
PL/SQL: ORA-00917: missing comma
ORA-06550: line 4, column 139:
PL/SQL: SQL Statement ignored
ORA-06550: line 20, column 17:
PL/SQL: ORA-00917: missing comma
ORA-06550: line 12, column 182:
PL/SQL: SQL Statement ignored
ORA-06550: line 28, column 17:
PL/SQL: ORA-00917: missing comma
ORA-06550: line 20, column 178:
PL/SQL: SQL Statement ignored
ORA-06550: line 36, column 17:
PL/SQL: ORA-00917: missing comma
Job "BKPUSR"."SYS_IMPORT_TABLE_01" completed with 3 error(s) at 12:54:18

[EDITED by LF: applied [spoiler] tags]

[Updated on: Mon, 11 March 2013 08:15] by Moderator

Report message to a moderator

Re: Partition table import through Data Pump [message #579318 is a reply to message #579316]

Mon, 11 March 2013 05:48

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why do you want to import them and not recompute them?

Regards
Michel

Report message to a moderator

Previous Topic:	How to load unstructured data
Next Topic:	datadump 11g to 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 16:28:43 CST 2025