别人盗用我的网站备案号怎么办,柳州企业做网站,北京便宜的网站建设,自己用dw做网站能加声音吗问题#xff1a;由于段延迟分配。导致新创建的表未分配段。与参数deferred_segment_creation有关。如果是空表#xff0c;使用exp和imp会导致导不出来表结构。 使用exp加参数rowsn导出元数据#xff0c;记录一个问题导入后#xff0c;往表里插入数据#xff0c;发现占用了…问题由于段延迟分配。导致新创建的表未分配段。与参数deferred_segment_creation有关。如果是空表使用exp和imp会导致导不出来表结构。 使用exp加参数rowsn导出元数据记录一个问题导入后往表里插入数据发现占用了很大的空间经过排查是initial extent的问题。使用rowsn,导出元数据然后在导入到其它库。initial extent会改变(新建立的表默认为64k) 怎样才处理该问题ALTER TABLE username.table_name MOVE tablespace tablespace_name STORAGE(INITIAL 64k NEXT 1m);ALTER INDEX username.index_name REBUILD online tablespace tablespace_name STORAGE(INITIAL 64k NEXT 1m); 测试1.查询表的定义initial默认为64kSQL select dbms_metadata.get_ddl(TABLE,T1,ERWA) from dual; DBMS_METADATA.GET_DDL(TABLE,T1,ERWA)-------------------------------------------------------------------------------- CREATE TABLE ERWA.T1 ( EMPNO NUMBER(4,0), ENAME VARCHAR2(20), JOB VARCHAR2(9), MGR NUMBER(4,0), HIREDATE DATE, SAL NUMBER(7,2), COMM NUMBER(7,2), DEPTNO NUMBER(2,0) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE USERS SQL 2.使用rowsn导出[oraclelxtrac05 bk]$ exp system/oracle filetest.dmp tableserwa.t1 rowsnExport: Release 11.2.0.4.0 - Production on Thu Feb 22 11:14:16 2018Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsExport done in UTF8 character set and AL16UTF16 NCHAR character setserver uses AL32UTF8 character set (possible charset conversion)Note: table data (rows) will not be exportedAbout to export specified tables via Conventional Path ...Current user changed to ERWA. . exporting table T1EXP-00091: Exporting questionable statistics.Export terminated successfully with warnings.[oraclelxtrac05 bk]$ 3.导入[oraclelxtrac05 bk]$ imp system/oracle filetest.dmp tablest1 fromusererwa tousersrwImport: Release 11.2.0.4.0 - Production on Thu Feb 22 11:15:27 2018Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing options Export file created by EXPORT:V11.02.00 via conventional pathimport done in UTF8 character set and AL16UTF16 NCHAR character setimport server uses AL32UTF8 character set (possible charset conversion). importing ERWAs objects into SRWImport terminated successfully without warnings.[oraclelxtrac05 bk]$4.再次查询表的定义结构。发现initial extent变了。SQL select dbms_metadata.get_ddl(TABLE,T1,SRW) from dual;DBMS_METADATA.GET_DDL(TABLE,T1,SRW)-------------------------------------------------------------------------------- CREATE TABLE SRW.T1 ( EMPNO NUMBER(4,0), ENAME VARCHAR2(20), JOB VARCHAR2(9), MGR NUMBER(4,0), HIREDATE DATE, SAL NUMBER(7,2), COMM NUMBER(7,2), DEPTNO NUMBER(2,0) ) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE( INITIAL 710934528 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE USERS SQL 转载于:https://www.cnblogs.com/erwadba/p/8458634.html
