\u5ba2\u6237\u5c1d\u8bd5\u5bfc\u5165\u4e00\u4e2a\u5206\u533a\u8868\u7684\u4e2a\u522b\u51e0\u4e2a\u5206\u533a\uff0c\u7ed3\u679c\u5374\u635f\u5931\u4e86\u6574\u4e2a\u5206\u533a\u8868\u7684\u6570\u636e\u3002
\n\u4e0b\u9762\u901a\u8fc7\u4e00\u4e2a\u4f8b\u5b50\u6765\u5728\u7ebf\u8fd9\u4e2a\u95ee\u9898\uff1a
\nSQL> CREATE TABLE T_PART PARTITION BY RANGE (CREATED)
\n2 (PARTITION P1 VALUES LESS THAN (TO_DATE(‘2012-1-1’, ‘YYYY-MM-DD’)),
\n3 PARTITION P2 VALUES LESS THAN (TO_DATE(‘2012-2-1’, ‘YYYY-MM-DD’)),
\n4 PARTITION P3 VALUES LESS THAN (TO_DATE(‘2012-3-1’, ‘YYYY-MM-DD’)),
\n5 PARTITION P4 VALUES LESS THAN (TO_DATE(‘2012-4-1’, ‘YYYY-MM-DD’)),
\n6 PARTITION PMAX VALUES LESS THAN (MAXVALUE))
\n7 AS SELECT * FROM DBA_OBJECTS;
\nTable created.
\nSQL> host expdp test directory=d_output dumpfile=t_part.dp logfile=t_part.log tables=t_part:p3, t_part:p4
\nExport: Release 11.2.0.3.0 – Production on Tue Mar 13 12:17:00 2012
\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates. All rights reserved.
\nPassword:
\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
\nWith the Partitioning, Oracle Label Security and Real Application Testing options
\nStarting “TEST”.”SYS_EXPORT_TABLE_01″: test\/******** directory=d_output dumpfile=t_part.dp logfile=t_part.log tables=t_part:p3, t_part:p4
\nEstimate in progress using BLOCKS method…
\nProcessing object type TABLE_EXPORT\/TABLE\/TABLE_DATA
\nTotal estimation using BLOCKS method: 16 MB
\nProcessing object type TABLE_EXPORT\/TABLE\/TABLE
\n. . exported “TEST”.”T_PART”:”P3″ 29.89 KB 193 rows
\n. . exported “TEST”.”T_PART”:”P4″ 65 KB 425 rows
\nMaster table “TEST”.”SYS_EXPORT_TABLE_01″ successfully loaded\/unloaded
\n******************************************************************************
\nDump file set for TEST.SYS_EXPORT_TABLE_01 is:
\n\/home\/oracle\/t_part.dp
\nJob “TEST”.”SYS_EXPORT_TABLE_01″ successfully completed at 12:17:17
\n\u5ba2\u6237\u5c1d\u8bd5\u5bfc\u5165\u51e0\u4e2a\u5206\u533a\uff0c\u4f46\u662f\u8fd9\u4e9b\u5206\u533a\u5e76\u4e0d\u4e3a\u7a7a\uff0c\u4e8e\u662f\u5728\u5bfc\u5165\u65f6\u6307\u5b9a\u4e86\u9519\u8bef\u7684TABLE_EXISTS_ACTION\u53c2\u6570\u4e3aREPLACE\uff1a
\nSQL> host impdp test directory=d_output dumpfile=t_part.dp logfile=t_part_imp.log tables=t_part:p3 table_exists_action=replace
\nImport: Release 11.2.0.3.0 – Production on Tue Mar 13 14:51:55 2012
\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates. All rights reserved.
\nPassword:
\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
\nWith the Partitioning, Oracle Label Security and Real Application Testing options
\nMaster table “TEST”.”SYS_IMPORT_TABLE_01″ successfully loaded\/unloaded
\nStarting “TEST”.”SYS_IMPORT_TABLE_01″: test\/******** directory=d_output dumpfile=t_part.dp logfile=t_part_imp.log tables=t_part:p3 table_exists_action=replace
\nProcessing object type TABLE_EXPORT\/TABLE\/TABLE
\nProcessing object type TABLE_EXPORT\/TABLE\/TABLE_DATA
\n. . imported “TEST”.”T_PART”:”P3″ 29.89 KB 193 rows
\nJob “TEST”.”SYS_IMPORT_TABLE_01″ successfully completed at 14:52:00
\n\u867d\u7136\u5bfc\u5165\u7684\u65f6\u5019\u4ec5\u6307\u5b9a\u4e86\u4e00\u4e2a\u5206\u533a\uff0c\u4f46\u662fOracle\u5e76\u4e0d\u4f1a\u5bf9\u8fd9\u4e00\u4e2a\u5206\u533a\u6267\u884cTRUNCATE\u64cd\u4f5c\uff0c\u800c\u662f\u5c06\u6574\u4e2a\u8868DROP\u6389\uff0c\u7136\u540e\u5229\u7528\u6570\u636e\u6cf5\u4e2d\u7684\u6e90\u6570\u636e\u91cd\u5efa\u3002
\nSQL> SELECT COUNT(*) FROM T_PART PARTITION (P1);
\nCOUNT(*)
\n———-
\n0
\nSQL> SELECT COUNT(*) FROM T_PART PARTITION (P2);
\nCOUNT(*)
\n———-
\n0
\nSQL> SELECT COUNT(*) FROM T_PART PARTITION (P3);
\nCOUNT(*)
\n———-
\n193
\nSQL> SELECT COUNT(*) FROM T_PART PARTITION (P4);
\nCOUNT(*)
\n———-
\n0
\nSQL> SELECT COUNT(*) FROM T_PART PARTITION (PMAX);
\nCOUNT(*)
\n———-
\n0
\n\u8fd9\u4e2a\u8868\u4e2d\u53ea\u6709\u5bfc\u5165\u7684\u5206\u533a\u8bb0\u5f55\u5b58\u5728\uff0c\u539f\u5219\u4e0aimpdp\u5bf9\u5e94\u7684\u6570\u636e\u6cf5\u5bfc\u51fa\u6587\u4ef6\u4e2d\u7684\u8bb0\u5f55\u4e5f\u90fd\u662f\u53ef\u4ee5\u6062\u590d\u7684\uff0c\u4f46\u662f\u8868\u4e2d\u5176\u4ed6\u7684\u5206\u533a\u6570\u636e\u5219\u5b8c\u5168\u4e22\u5931\u3002
\n\u800c\u4e14Oracle\u5728\u5220\u9664\u7684\u65f6\u5019\u8fd8\u4f7f\u7528PURGE\u9009\u9879\uff0c\u4f7f\u5f97\u5206\u533a\u8868\u5728\u5220\u9664\u7684\u65f6\u5019\u5e76\u6ca1\u6709\u88ab\u653e\u5230\u56de\u6536\u7ad9\u4e2d\uff0c\u800c\u662f\u76f4\u63a5\u4ece\u6570\u636e\u5e93\u4e2d\u88ab\u6e05\u9664\u3002\u4ece\u8fd9\u4e00\u70b9\u4e0a\u8bb2\uff0cOracle\u5e94\u8be5\u53bb\u6389PURGE\u8bed\u53e5\uff0c\u6216\u8005\u81f3\u5c11\u7ed9\u51fa\u4e00\u4e2a\u9009\u9879\uff0c\u6bd5\u7adfDROP TABLE\u5bf9\u4e8e\u7cfb\u7edf\u6765\u8bf4\u6709\u98ce\u9669\u7684\u3002
\n\u6700\u8fd1\u78b0\u5230\u4e24\u4e09\u6b21\u7684\u95ee\u9898\u90fd\u662f\u548cimp\u4ee5\u53caimpdp\u6709\u5173\uff0c\u56e0\u6b64\u53ea\u8981\u662f\u6d89\u53ca\u5230\u6570\u636e\u5e93\u4fee\u6539\u7684\uff0c\u8fd8\u662f\u8981\u8c28\u614e\u5904\u4e4b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5ba2\u6237\u5c1d\u8bd5\u5bfc\u5165\u4e00\u4e2a\u5206\u533a\u8868\u7684\u4e2a\u522b\u51e0\u4e2a\u5206\u533a\uff0c\u7ed3\u679c\u5374\u635f\u5931\u4e86\u6574\u4e2a\u5206\u533a\u8868\u7684\u6570\u636e\u3002 \u4e0b\u9762\u901a\u8fc7\u4e00\u4e2a\u4f8b\u5b50\u6765\u5728\u7ebf\u8fd9\u4e2a\u95ee\u9898\uff1a SQL> CREATE TABLE T_PART PARTITION BY RANGE (CREATED) 2 (PARTITION P1 VALUES LESS THAN (TO_DATE(‘2012-1-1’, ‘YYYY-MM-DD’)), 3 PARTITION P2 VALUES LESS THAN (TO_DATE(‘2012-2-1’, ‘YYYY-MM-DD’)), 4 PARTITION P3 VALUES LESS THAN (TO_DATE(‘2012-3-1’, ‘YYYY-MM-DD’)), 5 PARTITION P4 VALUES LESS THAN … Continue reading