{"id":41,"date":"2011-08-26T23:44:19","date_gmt":"2011-08-26T15:44:19","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=41"},"modified":"2011-09-22T18:46:16","modified_gmt":"2011-09-22T10:46:16","slug":"exp%e6%97%a0%e6%b3%95%e5%af%bc%e5%87%ba%e5%bb%b6%e8%bf%9f%e6%ae%b5%e5%88%9b%e5%bb%ba%e7%9a%84%e8%a1%a8","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=41","title":{"rendered":"EXP\u65e0\u6cd5\u5bfc\u51fa\u5ef6\u8fdf\u6bb5\u521b\u5efa\u7684\u8868"},"content":{"rendered":"<p>\u5bf9\u4e8e11g\u4e2d\u4f7f\u7528\u4e86\u5ef6\u8fdf\u6bb5\u521b\u5efa\u65b9\u5f0f\u521b\u5efa\u7684\u8868\uff0c\u5982\u679c\u5bfc\u51fa\u65f6\u523b\u8868\u7684\u6bb5\u6ca1\u6709\u88ab\u521b\u5efa\uff0c\u90a3\u4e48EXP\u4e0d\u4f1a\u5bfc\u51fa\u8fd9\u5f20\u8868\u3002<br \/>\n\u68c0\u67e5\u6d4b\u8bd5\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>SQL> create table t_defer (id number, name varchar2(30));\r\nTable created.\r\nSQL> create table t_imme (id number, name varchar2(30)) segment creation immediate; \r\nTable created.\r\nSQL> select table_name, segment_created from user_tables;\r\nTABLE_NAME                     SEG\r\n------------------------------ ---\r\nT_IMME                         YES\r\nT_DEFER                        NO<\/pre>\n<p>\u4e0b\u9762\u901a\u8fc7EXP\u8fdb\u884c\u5bfc\u51fa\uff1a<\/p>\n<pre lang='SQL'>[oracle@DB11G ~]$ exp yangtk\/yangtk file=seg_defer.dmp log=seg_defer.log buffer=2048000\r\nExport: Release 11.2.0.1.0 - Production on Wed Aug 24 14:11:39 2011\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates.  All rights reserved.\r\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nExport done in US7ASCII character set and AL16UTF16 NCHAR character set\r\nserver uses AL32UTF8 character set (possible charset conversion)\r\nAbout to export specified users ...\r\n. exporting pre-schema procedural objects and actions\r\n. exporting foreign function library names for user YANGTK \r\n. exporting PUBLIC type synonyms\r\n. exporting private type synonyms\r\n. exporting object type definitions for user YANGTK \r\nAbout to export YANGTK's objects ...\r\n. exporting database links\r\n. exporting sequence numbers\r\n. exporting cluster definitions\r\n. about to export YANGTK's tables via Conventional Path ...\r\n. . exporting table                         T_IMME          0 rows exported\r\n. exporting synonyms\r\n. exporting views\r\n. exporting stored procedures\r\n. exporting operators\r\n. exporting referential integrity constraints\r\n. exporting triggers\r\n. exporting indextypes\r\n. exporting bitmap, functional and extensible indexes\r\n. exporting posttables actions\r\n. exporting materialized views\r\n. exporting snapshot logs\r\n. exporting job queues\r\n. exporting refresh groups and children\r\n. exporting dimensions\r\n. exporting post-schema procedural objects and actions\r\n. exporting statistics\r\nExport terminated successfully without warnings.\r\n[oracle@DB11G ~]$ exp yangtk\/yangtk file=defer.dmp log=defer.log tables=t_defer buffer=2048000\r\nExport: Release 11.2.0.1.0 - Production on Wed Aug 24 14:12:42 2011\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates.  All rights reserved.\r\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nExport done in US7ASCII character set and AL16UTF16 NCHAR character set\r\nserver uses AL32UTF8 character set (possible charset conversion)\r\nAbout to export specified tables via Conventional Path ...\r\nEXP-00011: YANGTK.T_DEFER does not exist\r\nExport terminated successfully with warnings.\r\n[oracle@DB11G ~]$ exp yangtk\/yangtk file=defer.dmp log=defer.log tables=t_defer buffer=2048000 direct=y recordlength=65534\r\nExport: Release 11.2.0.1.0 - Production on Wed Aug 24 14:13:04 2011\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates.  All rights reserved.\r\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nExport done in US7ASCII character set and AL16UTF16 NCHAR character set\r\nserver uses AL32UTF8 character set (possible charset conversion)\r\nAbout to export specified tables via Direct Path ...\r\nEXP-00011: YANGTK.T_DEFER does not exist\r\nExport terminated successfully with warnings.\r\n[oracle@DB11G ~]$ expdp yangtk\/yangtk dumpfile=seg_defer.dp logfile=seg_defer_expdp.log directory=d_output\r\n\r\nExport: Release 11.2.0.1.0 - Production on Wed Aug 24 14:13:36 2011\r\n\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nStarting \"YANGTK\".\"SYS_EXPORT_SCHEMA_01\":  yangtk\/******** dumpfile=seg_defer.dp logfile=seg_defer_expdp.log directory=d_output \r\nEstimate in progress using BLOCKS method...\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA\r\nTotal estimation using BLOCKS method: 0 KB\r\nProcessing object type SCHEMA_EXPORT\/USER\r\nProcessing object type SCHEMA_EXPORT\/SYSTEM_GRANT\r\nProcessing object type SCHEMA_EXPORT\/ROLE_GRANT\r\nProcessing object type SCHEMA_EXPORT\/DEFAULT_ROLE\r\nProcessing object type SCHEMA_EXPORT\/PRE_SCHEMA\/PROCACT_SCHEMA\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/INDEX\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/CONSTRAINT\/CONSTRAINT\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/COMMENT\r\n. . exported \"YANGTK\".\"T_DEFER\"                              0 KB       0 rows\r\n. . exported \"YANGTK\".\"T_IMME\"                               0 KB       0 rows\r\nMaster table \"YANGTK\".\"SYS_EXPORT_SCHEMA_01\" successfully loaded\/unloaded\r\n******************************************************************************\r\nDump file set for YANGTK.SYS_EXPORT_SCHEMA_01 is:\r\n  \/home\/oracle\/dmp\/seg_defer.dp\r\nJob \"YANGTK\".\"SYS_EXPORT_SCHEMA_01\" successfully completed at 14:14:33<\/pre>\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u65e0\u8bba\u662f\u4f7f\u7528\u5e38\u89c4\u8def\u5f84\u8fd8\u662f\u76f4\u63a5\u8def\u5f84\uff0c\u5373\u4f7f\u76f4\u63a5\u6307\u5b9a\u8868\u540d\uff0c\u4e5f\u65e0\u6cd5\u5bfc\u51fa\u5ef6\u8fdf\u6bb5\u521b\u5efa\u7684\u8868\uff0c\u800c\u6570\u636e\u6cf5\u5bfc\u51fa\u5219\u6ca1\u6709\u8fd9\u4e2a\u95ee\u9898\u3002<br \/>\n\u5bf9\u4e8e\u5df2\u7ecf\u8bbe\u7f6e\u4e86\u5ef6\u8fdf\u6bb5\u521b\u5efa\uff0c\u53c8\u5e0c\u671bEXP\u5bfc\u51fa\u7684\u65f6\u5019\u53ef\u4ee5\u5bfc\u51fa\u6240\u6709\u8868\uff0c\u53ef\u4ee5\u901a\u8fc7\u4e0b\u9762\u7684\u7b80\u5355\u65b9\u6cd5\uff1a<\/p>\n<pre lang='SQL'>SQL> begin \r\n  2  for i in (select table_name from user_tables where segment_created = 'NO') loop\r\n  3  execute immediate 'alter table ' || i.table_name || ' allocate extent';\r\n  4  end loop;\r\n  5  end;\r\n  6  \/\r\nPL\/SQL procedure successfully completed.\r\nSQL> select table_name, segment_created from user_tables;\r\nTABLE_NAME                     SEG\r\n------------------------------ ---\r\nT_IMME                         YES\r\nT_DEFER                        YES<\/pre>\n<p>\u8fd9\u65f6EXP\u5c31\u53ef\u4ee5\u6b63\u786e\u5bfc\u51fa\u6240\u6709\u8868\u4e86\uff1a<\/p>\n<pre lang='SQL'>[oracle@DB11G ~]$ exp yangtk\/yangtk file=seg_defer_2.dmp log=seg_defer_2.log buffer=2048000\r\nExport: Release 11.2.0.1.0 - Production on Wed Aug 24 15:44:21 2011\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates. All rights reserved.\r\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nExport done in US7ASCII character set and AL16UTF16 NCHAR character set\r\nserver uses AL32UTF8 character set (possible charset conversion)\r\nAbout to export specified users ...\r\n. exporting pre-schema procedural objects and actions\r\n. exporting foreign function library names for user YANGTK \r\n. exporting PUBLIC type synonyms\r\n. exporting private type synonyms\r\n. exporting object type definitions for user YANGTK \r\nAbout to export YANGTK's objects ...\r\n. exporting database links\r\n. exporting sequence numbers\r\n. exporting cluster definitions\r\n. about to export YANGTK's tables via Conventional Path ...\r\n. . exporting table T_DEFER 0 rows exported\r\n. . exporting table T_IMME 0 rows exported\r\n. exporting synonyms\r\n. exporting views\r\n. exporting stored procedures\r\n. exporting operators\r\n. exporting referential integrity constraints\r\n. exporting triggers\r\n. exporting indextypes\r\n. exporting bitmap, functional and extensible indexes\r\n. exporting posttables actions\r\n. exporting materialized views\r\n. exporting snapshot logs\r\n. exporting job queues\r\n. exporting refresh groups and children\r\n. exporting dimensions\r\n. exporting post-schema procedural objects and actions\r\n. exporting statistics\r\nExport terminated successfully without warnings.<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5bf9\u4e8e11g\u4e2d\u4f7f\u7528\u4e86\u5ef6\u8fdf\u6bb5\u521b\u5efa\u65b9\u5f0f\u521b\u5efa\u7684\u8868\uff0c\u5982\u679c\u5bfc\u51fa\u65f6\u523b\u8868\u7684\u6bb5\u6ca1\u6709\u88ab\u521b\u5efa\uff0c\u90a3\u4e48EXP\u4e0d\u4f1a\u5bfc\u51fa\u8fd9\u5f20\u8868\u3002 \u68c0\u67e5\u6d4b\u8bd5\u5982\u4e0b\uff1a SQL> create table t_defer (id number, name varchar2(30)); Table created. SQL> create table t_imme (id number, name varchar2(30)) segment creation immediate; Table created. SQL> select table_name, segment_created from user_tables; TABLE_NAME SEG &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212; T_IMME YES T_DEFER NO \u4e0b\u9762\u901a\u8fc7EXP\u8fdb\u884c\u5bfc\u51fa\uff1a &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=41\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[83,84],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-F","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/41"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=41"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/41\/revisions"}],"predecessor-version":[{"id":140,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/41\/revisions\/140"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=41"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=41"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=41"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}