oracle 表分区segment,deferred_segment_creation与分区表操作的bug

最新推荐文章于 2024-05-22 06:36:27 发布
最新推荐文章于 2024-05-22 06:36:27 发布
阅读量281 收藏
点赞数
文章标签： oracle 表分区segment

CREATE OR REPLACE DIRECTORY dumpdir AS '/oracle/dumpdir';

CREATE TABLESPACE ADDATA DATAFILE

'+DATADG/andy11g/datafile/addata001' SIZE 8000M AUTOEXTEND OFF,

'+DATADG/andy11g/datafile/addata002' SIZE 8000M AUTOEXTEND OFF;

CREATE TABLESPACE ADINDX DATAFILE

'+DATADG/andy11g/datafile/adindx001' SIZE 8000M AUTOEXTEND OFF,

'+DATADG/andy11g/datafile/adindx002' SIZE 8000M AUTOEXTEND OFF;

CREATE USER ADUSER

IDENTIFIED BY andy00

DEFAULT TABLESPACE ADDATA

TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

-- 2 Roles for ADUSER

GRANT CONNECT TO ADUSER;

ALTER USER ADUSER DEFAULT ROLE ALL;

-- 2 Tablespace Quotas for ADUSER

ALTER USER ADUSER QUOTA UNLIMITED ON ADINDX;

ALTER USER ADUSER QUOTA UNLIMITED ON ADDATA;

CREATE USER DATAGUARD

IDENTIFIED BY andy00

DEFAULT TABLESPACE ADDATA

TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

-- 2 Roles for DATAGUARD

GRANT CONNECT TO DATAGUARD;

ALTER USER DATAGUARD DEFAULT ROLE ALL;

-- 2 Tablespace Quotas for DATAGUARD

ALTER USER DATAGUARD QUOTA UNLIMITED ON ADINDX;

ALTER USER DATAGUARD QUOTA UNLIMITED ON ADDATA;

nohup impdp \"\/ as sysdba\" directory=dumpdir dumpfile=AD_RESULT1.dmp logfile=imp_AD_RESULT1.log job_name=TE_RESULT1_imp tables=ADUSER.AD_RESULT1 remap_schema=ADUSER:DATAGUARD &

--在dataguard和aduser下建好分区表，表名都叫ad_result1，dataguard.ad_result1有12年的数据。aduser.ad_result1是空表。

SQL> select name,user# from user$ where name in ('ADUSER','DATAGUARD');

NAME                                USER#

------------------------------ ----------

DATAGUARD                              85

ADUSER                                 84

SQL> show parameter def

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

deferred_segment_creation            boolean     TRUE

SQL>

SQL> select owner,table_name,partitioned from dba_tables where owner in ('ADUSER','DATAGUARD');

OWNER                          TABLE_NAME                     PAR

------------------------------ ------------------------------ ---

ADUSER                         AD_RESULT1_2010_MID         NO

DATAGUARD                      AD_RESULT1                  YES

ADUSER                         AD_RESULT1                  YES

SQL>

--这时因为aduser.ad_result1是空表，由于deferred_segment_creation=true，只能在dba_segments里看到dataguard的表

SQL> select owner,header_file,header_block from dba_segments where segment_name='AD_RESULT1' and partition_name='AD_RESULT1_201201_SAD_R1_1';

OWNER                          HEADER_FILE HEADER_BLOCK

------------------------------ ----------- ------------

DATAGUARD                                7       182417

SQL>

SQL> select user# from seg$ where file#=7 and block#=182417;

USER#

----------

85

--把dataguard.ad_result1里12年所有子分区，通过mid普通表exchange到aduser.ad_result1以后，发现只能查到aduser.ad_result1了，因为dataguard.ad_result1是空表了。

--这时seg$里的user#却没变成84

SQL> select owner,header_file,header_block from dba_segments where segment_name='AD_RESULT1' and partition_name='AD_RESULT1_201201_SAD_R1_1';

OWNER                          HEADER_FILE HEADER_BLOCK

------------------------------ ----------- ------------

ADUSER                                   7       182417

SQL> select user# from seg$ where file#=7 and block#=182417;

USER#

----------

85

SQL>

--重现问题

alter table ADUSER.AD_RESULT1 truncate partition AD_RESULT1_201201;

alter table ADUSER.AD_RESULT1 truncate partition AD_RESULT1_201202;

alter table ADUSER.AD_RESULT1 truncate partition AD_RESULT1_201203;

alter table ADUSER.AD_RESULT1 truncate partition AD_RESULT1_201204;

alter table ADUSER.AD_RESULT1 truncate partition AD_RESULT1_201205;

alter table ADUSER.AD_RESULT1 truncate partition AD_RESULT1_201206;

alter table ADUSER.AD_RESULT1 truncate partition AD_RESULT1_201207;

alter table ADUSER.AD_RESULT1 truncate partition AD_RESULT1_201208;

alter table ADUSER.AD_RESULT1 truncate partition AD_RESULT1_201209;

alter table ADUSER.AD_RESULT1 truncate partition AD_RESULT1_201210;

alter table ADUSER.AD_RESULT1 truncate partition AD_RESULT1_201211;

alter table ADUSER.AD_RESULT1 truncate partition AD_RESULT1_201212;

SQL> select owner,header_file,header_block from dba_segments where segment_name='AD_RESULT1' and partition_name='AD_RESULT1_201201_SAD_R1_1';

OWNER                          HEADER_FILE HEADER_BLOCK

------------------------------ ----------- ------------

ADUSER                                   7       182417

SQL> select user# from seg$ where file#=7 and block#=182417;

USER#

----------

85

SQL> select count(1) from aduser.AD_RESULT1;

COUNT(1)

----------

0

SQL> select count(1) from dataguard.AD_RESULT1;

COUNT(1)

----------

1204

SQL> select distinct substr(partition_name,1,15) from dba_segments t where owner='ADUSER';

SUBSTR(PARTITION_NAME,1,15)

---------------------------------------------

AD_RESULT1_2012

SQL> select distinct substr(partition_name,1,15) from dba_segments t where owner='DATAGUARD';

SUBSTR(PARTITION_NAME,1,15)

---------------------------------------------

AD_RESULT1_MAX_

SQL>

SQL> drop user dataguard cascade;

User dropped.

SQL> CREATE USER DATAGUARD

2    IDENTIFIED BY andy00

3    DEFAULT TABLESPACE ADDATA

4    TEMPORARY TABLESPACE TEMP

5    PROFILE DEFAULT

6    ACCOUNT UNLOCK;

User created.

SQL>   GRANT CONNECT TO DATAGUARD;

ALTER USER DATAGUARD DEFAULT ROLE ALL;

Grant succeeded.

SQL>

User altered.

SQL>   ALTER USER DATAGUARD QUOTA UNLIMITED ON ADINDX;

ALTER USER DATAGUARD QUOTA UNLIMITED ON ADDATA;

User altered.

SQL>

User altered.

SQL>

SQL> select name,user# from user$ where name in ('ADUSER','DATAGUARD');

NAME                                USER#

------------------------------ ----------

DATAGUARD                              86

ADUSER                                 84

SQL> select owner,header_file,header_block from dba_segments where segment_name='AD_RESULT1' and partition_name='AD_RESULT1_201201_SAD_R1_1';

OWNER                          HEADER_FILE HEADER_BLOCK

------------------------------ ----------- ------------

ADUSER                                   7       182417

SQL> select user# from seg$ where file#=7 and block#=182417;

USER#

----------

85

SQL>

重新导入dataguard

SQL> select owner,header_file,header_block from dba_segments where segment_name='AD_RESULT1' and partition_name='AD_RESULT1_201201_SAD_R1_1';

OWNER                          HEADER_FILE HEADER_BLOCK

------------------------------ ----------- ------------

ADUSER                                   7       182417

DATAGUARD                                6       182417

SQL> select name,user# from user$ where name in ('ADUSER','DATAGUARD');

NAME                                USER#

------------------------------ ----------

DATAGUARD                              86

ADUSER                                 84

SQL> select user# from seg$ where file#=7 and block#=182417;

USER#

----------

85

SQL> select user# from seg$ where file#=6 and block#=182417;

USER#

----------

86

SQL>

SQL> show parameter timed_statistics

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

timed_statistics                     boolean     TRUE

SQL> show parameter user_dump_dest

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

user_dump_dest                       string      /oracle/orabase/diag/rdbms/ad1

1g/andy11g1/trace

SQL> show parameter max_dump_file_size trace

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

max_dump_file_size                   string      unlimited

alter session set tracefile_identifier='adtest';

alter session set events '10046 trace name context forever, level 12';

alter table dataguard.AD_RESULT1 exchange subpartition AD_RESULT1_201201_SAD_R1_1 with table ADUSER.AD_RESULT1_2010_MID including indexes WITHOUT VALIDATION;

alter table ADUSER.AD_RESULT1 exchange subpartition AD_RESULT1_201201_SAD_R1_1 with table ADUSER.AD_RESULT1_2010_MID including indexes WITHOUT VALIDATION;

alter session set events '10046 trace name context off';

SQL> alter session set tracefile_identifier='adtest';

Session altered.

SQL> alter session set events '10046 trace name context forever, level 12';

Session altered.

SQL> alter table dataguard.AD_RESULT1 exchange subpartition AD_RESULT1_201201_SAD_R1_1 with table ADUSER.AD_RESULT1_2010_MID including indexes WITHOUT VALIDATION;

Table altered.

SQL> alter table ADUSER.AD_RESULT1 exchange subpartition AD_RESULT1_201201_SAD_R1_1 with table ADUSER.AD_RESULT1_2010_MID including indexes WITHOUT VALIDATION;

alter table ADUSER.AD_RESULT1 exchange subpartition AD_RESULT1_201201_SAD_R1_1 with table ADUSER.AD_RESULT1_2010_MID including indexes WITHOUT VALIDATION

*

ERROR at line 1:

ORA-01950: no privileges on tablespace 'ADDATA'

SQL> alter session set events '10046 trace name context off';

Session altered.

vi andy11g1_ora_1101_adtest.trc

PARSING IN CURSOR #47887786011128 len=159 dep=0 uid=0 oct=15 lid=0 tim=1333956457878482 hv=2252224127 ad='647e34d10' sqlid='8s5g0da33wdmz'

alter table ADUSER.AD_RESULT1 exchange subpartition AD_RESULT1_201201_SAD_R1_1 with table ADUSER.AD_RESULT1_2010_MID including indexes WITHOUT VALIDATION

END OF STMT

PARSE #47887786011128:c=6999,e=6915,p=0,cr=10,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=1333956457878481

PARSE #47887786058712:c=0,e=38,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=0,tim=1333956457878707

PARSE #47887786459656:c=0,e=6,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=1388734953,tim=1333956457878804

EXEC #47887786459656:c=0,e=12,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=1388734953,tim=1333956457878837

FETCH #47887786459656:c=0,e=143,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=1,plh=1388734953,tim=1333956457878996

CLOSE #47887786459656:c=0,e=2,dep=2,type=3,tim=1333956457879047

PARSE #47887786444232:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=1388734953,tim=1333956457879083

EXEC #47887786444232:c=0,e=12,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,plh=1388734953,tim=1333956457879109

FETCH #47887786444232:c=0,e=99,p=0,cr=0,cu=0,mis=0,r=1,dep=2,og=1,plh=1388734953,tim=1333956457879222

CLOSE #47887786444232:c=0,e=2,dep=2,type=3,tim=1333956457879266

WAIT #47887786011128: nam='enq: TT - contention' ela= 135 name|mode=1414791172 tablespace ID=6 operation=16 obj#=-1 tim=1333956457897169

=====================

/47887786011128

STAT #47887786103704 id=2 cnt=0 pid=1 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# (cr=1 pr=0 pw=0 time=6 us cost=0 size=0 card=1)'

CLOSE #47887786103704:c=0,e=4,dep=1,type=0,tim=1333956457900880

=====================

PARSING IN CURSOR #47887786103704 len=190 dep=1 uid=0 oct=3 lid=0 tim=1333956457901164 hv=293780133 ad='6a71b2d48' sqlid='4kt3cun8s5fp5'

select name,password,datats#,tempts#,type#,defrole,resource$, ptime, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass),spare1,spare4,ext_username,spare2 from user$ where user#=:1

END OF STMT

PARSE #47887786103704:c=0,e=22,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2709293936,tim=1333956457901163

BINDS #47887786103704:

Bind#0

oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0

kxsbbbfp=2b8dbe7c9d48  bln=22  avl=02  flg=05

value=85

EXEC #47887786103704:c=0,e=53,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2709293936,tim=1333956457901304

FETCH #47887786103704:c=0,e=6,p=0,cr=1,cu=0,mis=0,r=0,dep=1,og=4,plh=2709293936,tim=1333956457901327

STAT #47887786103704 id=1 cnt=0 pid=0 pos=1 obj=22 op='TABLE ACCESS CLUSTER USER$ (cr=1 pr=0 pw=0 time=6 us cost=1 size=102 card=1)'

STAT #47887786103704 id=2 cnt=0 pid=1 pos=1 obj=11 op='INDEX UNIQUE SCAN I_USER# (cr=1 pr=0 pw=0 time=5 us cost=0 size=0 card=1)'

CLOSE #47887786103704:c=0,e=3,dep=1,type=0,tim=1333956457901379

EXEC #47887786011128:c=20997,e=23043,p=0,cr=279,cu=1,mis=0,r=0,dep=0,og=1,plh=0,tim=1333956457901568

ERROR #47887786011128:err=1950 tim=1333956457901597

WAIT #47887786011128: nam='SQL*Net break/reset to client' ela= 23 driver id=1650815232 break?=1 p3=0 obj#=-1 tim=1333956457902352

WAIT #47887786011128: nam='SQL*Net break/reset to client' ela= 69 driver id=1650815232 break?=0 p3=0 obj#=-1 tim=1333956457902446

WAIT #47887786011128: nam='SQL*Net message to client' ela= 1 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1333956457902460

*** 2012-04-09 15:27:51.649

WAIT #47887786011128: nam='SQL*Net message from client' ela= 13747270 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1333956471649774

CLOSE #47887786011128:c=0,e=10,dep=0,type=0,tim=1333956471649882

=====================

PARSING IN CURSOR #47887786011128 len=55 dep=0 uid=0 oct=42 lid=0 tim=1333956471649990 hv=2217940283 ad='0' sqlid='06nvwn223659v'

alter session set events '10046 trace name context off'

END OF STMT

PARSE #47887786011128:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=0,tim=1333956471649990

EXEC #47887786011128:c=999,e=282,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=0,tim=1333956471650345

tkprof andy11g1_ora_1101_adtest.trc andy11g1_ora_1101_adtest.txt

SQL> select distinct substr(partition_name,1,15) from dba_segments t where owner='ADUSER';

SUBSTR(PARTITION_NAME,1,15)

---------------------------------------------

AD_RESULT1_2012

SQL> select distinct substr(partition_name,1,15) from dba_segments t where owner='DATAGUARD';

SUBSTR(PARTITION_NAME,1,15)

---------------------------------------------

AD_RESULT1_MAX_

AD_RESULT1_2012

SQL>

SQL> select count(1) from ADUSER.AD_RESULT1;

COUNT(1)

----------

0

alter table ADUSER.AD_RESULT1 drop partition AD_RESULT1_201201;

alter table ADUSER.AD_RESULT1 drop partition AD_RESULT1_201202;

alter table ADUSER.AD_RESULT1 drop partition AD_RESULT1_201203;

alter table ADUSER.AD_RESULT1 drop partition AD_RESULT1_201204;

alter table ADUSER.AD_RESULT1 drop partition AD_RESULT1_201205;

alter table ADUSER.AD_RESULT1 drop partition AD_RESULT1_201206;

alter table ADUSER.AD_RESULT1 drop partition AD_RESULT1_201207;

alter table ADUSER.AD_RESULT1 drop partition AD_RESULT1_201208;

alter table ADUSER.AD_RESULT1 drop partition AD_RESULT1_201209;

alter table ADUSER.AD_RESULT1 drop partition AD_RESULT1_201210;

alter table ADUSER.AD_RESULT1 drop partition AD_RESULT1_201211;

alter table ADUSER.AD_RESULT1 drop partition AD_RESULT1_201212;

alter table ADUSER.AD_RESULT1 split partition AD_RESULT1_MAX at (TO_DATE('2012-01-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))

into (partition AD_RESULT1_201201, partition AD_RESULT1_MAX) update indexes;

alter table ADUSER.AD_RESULT1 split partition AD_RESULT1_MAX at (TO_DATE('2012-02-28 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))

into (partition AD_RESULT1_201202, partition AD_RESULT1_MAX) update indexes;

alter table ADUSER.AD_RESULT1 split partition AD_RESULT1_MAX at (TO_DATE('2012-03-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))

into (partition AD_RESULT1_201203, partition AD_RESULT1_MAX) update indexes;

alter table ADUSER.AD_RESULT1 split partition AD_RESULT1_MAX at (TO_DATE('2012-04-30 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))

into (partition AD_RESULT1_201204, partition AD_RESULT1_MAX) update indexes;

alter table ADUSER.AD_RESULT1 split partition AD_RESULT1_MAX at (TO_DATE('2012-05-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))

into (partition AD_RESULT1_201205, partition AD_RESULT1_MAX) update indexes;

alter table ADUSER.AD_RESULT1 split partition AD_RESULT1_MAX at (TO_DATE('2012-06-30 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))

into (partition AD_RESULT1_201206, partition AD_RESULT1_MAX) update indexes;

alter table ADUSER.AD_RESULT1 split partition AD_RESULT1_MAX at (TO_DATE('2012-07-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))

into (partition AD_RESULT1_201207, partition AD_RESULT1_MAX) update indexes;

alter table ADUSER.AD_RESULT1 split partition AD_RESULT1_MAX at (TO_DATE('2012-08-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))

into (partition AD_RESULT1_201208, partition AD_RESULT1_MAX) update indexes;

alter table ADUSER.AD_RESULT1 split partition AD_RESULT1_MAX at (TO_DATE('2012-09-30 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))

into (partition AD_RESULT1_201209, partition AD_RESULT1_MAX) update indexes;

alter table ADUSER.AD_RESULT1 split partition AD_RESULT1_MAX at (TO_DATE('2012-10-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))

into (partition AD_RESULT1_201210, partition AD_RESULT1_MAX) update indexes;

alter table ADUSER.AD_RESULT1 split partition AD_RESULT1_MAX at (TO_DATE('2012-11-30 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))

into (partition AD_RESULT1_201211, partition AD_RESULT1_MAX) update indexes;

alter table ADUSER.AD_RESULT1 split partition AD_RESULT1_MAX at (TO_DATE('2012-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS'))

into (partition AD_RESULT1_201212, partition AD_RESULT1_MAX) update indexes;

alter table dataguard.AD_RESULT1 exchange subpartition AD_RESULT1_201201_SAD_R1_1 with table ADUSER.AD_RESULT1_2010_MID including indexes WITHOUT VALIDATION;

alter table ADUSER.AD_RESULT1 exchange subpartition AD_RESULT1_201201_SAD_R1_1 with table ADUSER.AD_RESULT1_2010_MID including indexes WITHOUT VALIDATION;

SQL> select count(1) from dataguard.AD_RESULT1;

COUNT(1)

----------

1204

SQL>

成功end

世界说
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
SQL-Oracle序列、视图、索引、表分区
05-19 339
SQL-Oracle序列、视图、索引、表分区
segment-page.rar_page_segment page_操作系统段页
09-23
"segment-page.rar_page_segment page_操作系统段页"这个压缩包文件聚焦于一种特定的内存管理机制——段页式虚拟存储。下面将详细阐述段页式虚拟存储的工作原理、实现方式以及LRU（最近最少使用）和FIFO（先进先出）...
DEFERRED_SEGMENT_CREATION
weixin_33709609的博客
03-11 97
deferred_segment_creation 延迟段创建是11.2的新特性， 当创建一个 空表或者空分区时，实际的表段table segment被延迟到第一行数据插入的时候。 该功能通过DEFERRED_SEGMENT_CREATION参数启用，默认为TRUE. 由DEFERRED_SEGMENT_CREATION启用的新的空间分配方式的优势在于： 若系统安装后存在...
Oracle段延迟分配（Deferred Segment Creation）解析
最新发布
专注于数据库技术分享，包含但不限于Oracle，MySQL，PostgreSQL，ElasticSearch及国产数据库等
05-22 683
Oracle段延迟分配（Deferred Segment Creation）是Oracle 11g引入的一项重要特性，旨在优化资源使用和提高数据库管理效率。
oracle参数之DEFERRED_SEGMENT_CREATION
张振磊的博客
02-18 7481
众所周知，在清空表内所有数据时，truncate比delete要快很多，原因是，delete语句每次删除一行，都在事务日志中为所删除的每行记录一项。truncate通过释放存储表数据所用的数据页来删除数据，并且只在事务日志中记录页的释放。但是如果表存在外键的话，是不能使用truncate的 。         在使用的过程中，我发现某个存在外键的表，使用truncate提示成功了。一开始，我在怀
Oracle 参数之deferred_segment_creation的测试
weixin_30470643的博客
10-23 331
deferred_segment_creation参数的主要作用是控制分区表中段的创建，例如很多情况下我们会预先创建未来一段时间某个表的分区表，但是我们还不想让这些预先创建的分区表占用过多的空间，在这种情况下我们设置deferred_segment_creation为false，那么在dba_objects中会有相关分区表的记录，但是dba_segements中不会有相关预先创建的分区表的记录，...
STACK1_SEGMENT_STACK.rar_STACK1 SEGMENT_stack segment stack
09-19
在汇编语言的学习中，"STACK1_SEGMENT_STACK.rar_STACK1 SEGMENT_stack segment stack"这个标题提到了两个关键概念：栈段（Stack Segment）和栈（Stack）。栈在计算机科学中扮演着至关重要的角色，尤其是在汇编语言...
image_segment.zip_image segment_image segmentation_segment_zip
07-14
《图像分割技术详解——以image_segment.zip为例》 在当今数字化时代，图像处理与分析扮演着至关重要的角色，其中图像分割作为图像理解的基础步骤，被广泛应用于医疗诊断、自动驾驶、人脸识别等多个领域。本文将...
segment--Image.zip_image segment_segment image_segment软件_somethi
09-24
实用的图像分割软件，很实用 实用的图像分割软件，很实用
ridgesegment.rar_ridge_ridge matlab_ridgesegment_segment matlab_
07-14
4. **Segment_matlab**：MATLAB中的图像分割，可能是这个程序的一部分功能，将图像分割为不同的区域或对象，包括脊线。 5. **小波变换**：一种数学工具，常用于信号和图像处理，能提供多尺度分析，有助于识别像脊线...
oracle deferred_segment_creation,deferred_segment_creation 参数
weixin_35924734的博客
04-12 1374
一、导入时少表1.Oracle 11g EXP导出，再IMP导入时，发现导入后，出现少表，有一些数据为空的表结构没有被导入，原因是于导出时，这些空表没有被导出。二、查阅资料1.从网上翻看各类资料，产生“导入时少表”的原因，在于Oracle 11g 的参数 “deferred_segment_creation”。2.”deferred_segment_creation”参数①从字面上的意思“延迟段...
oracle deferred_segment_creation,Oracle数据库的deferred_segment_creation和segment creation immediate...
weixin_39675679的博客
04-12 468
[oracle@rhel63single ~]$ sqlplus scott/aaaaaaSQL*Plus: Release 11.2.0.4.0 Production on Sat Apr 8 02:54:40 2017Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g E...
oracle set deferred,Oracle 中deferred_segment_creation 的用法以及exp时解决办法
weixin_42311672的博客
04-13 533
SYS@ORCL>show parameter segmentNAME TYPE VALUE------------------------------------ ----------- ------------------------------deferred_segment_creation...
segment createion deferred
ct827519的博客
05-28 126
问题来源于一次导出C:UsersAdministrator>exp acms/acms tables=acms_light_time file=aaa.dmpExport: Release 11.2.0.1.0 - Pro...
oracle deferred_segment_creation,Oracle 11g使用deferred_segment_creation 延迟段创建特性时遇到的问题总结...
weixin_36378683的博客
04-12 272
总结，下面是两个问题。问题1是用户可以在所有表空间创建表;问题2是exp不能导出空表问题1：版本：Oracle 11.2.0.1.0select * from v$version;创建用户aaa，给其connect和resource角色，但回收unlimited tablespace权限：SQL> create user aaa identified by aaa default table...
oracle的dba_ segment,dba_extents和dba_segments不一致问题及原因
weixin_35097346的博客
04-03 584
dba_extents和dba_segments不一致问题及原因日志。Metalink Note 463101.1文章 HOW TO DISCOVER AND FIX THE MISTMATCH BETWEENDBA_SEGMENTS AND DBA_EXTENTS DICTIONARY VIEWS 描述了这一问题。根据描述，这个问题主要发生在并行索引创建、频繁的DELETE/INSERT等操作中...
oracle 延迟段分配,oracle 11g使用deferred_segment_creation 延迟段创建特性时遇到的问题总结...
weixin_32048757的博客
04-14 541
总结，下面是两个问题。问题1是用户可以在所有表空间创建表;问题2是exp不能导出空表问题1：版本：oracle 11.2.0.1.0select * from v$version;创建用户aaa，给其connect和resource角色，但回收unlimited tablespace权限：SQL> create user aaa identified by aaa default table...
普通表 分区表 大对象表之间不同的segment分配
mercenarylin的专栏
04-11 1013
scott@ORCL> create table table1 (id number,name varchar2(2)); 表已创建。 scott@ORCL> create table table2 (id number,time date) partition by range(time) 2 ( partition p1 values less than (to_date(
deferred_segment_creation
04-08
'b'deferred_segment_creation'是Oracle数据库中的一个参数，它的作用是在创建表空间时不立即分配空间，而是在需要时动态分配空间。这可以减少数据库自动增加空间时的开销，提高数据库的性能和可扩展性。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值