我是使用Oracle 10gR2 DB的,在我注意到某种奇怪之处时,在座右铭之一。
除了我的桌子外,我发现,如果规模大,“LOBSEGMENT”型号的浮板——当时有17gb。
我在Oracle没有专家,也不知道产生这种情况。 某些表格中含有LOB的物体,但我怎么说属于什么?
这一系统本应保持我们的大型平台,因此,它配置了<条形码> 极具管理力的远洋望远镜 UNIFORM SIZE 64M。 这可能是另一个问题,除了这个大物体外,还有几十个其他物体,其中每个物体都配有至少<>> 6m。
我不承认的物体分为两类:LOBSEGMENT(名称为“SYS_LOB0000187667C00006$”)和LOBINDEX/code>(名称为“SYS_IL0000187607C00006$”)。
我认为,这个问题的一个根源是使用看法。 我们用一刀阔.的观点,参加这个没有特殊组合的庞大会议。 这个问题吗?
感谢!
<>LOBSEGMENT 储存了LOB数据,LOBINDEX使亚洲开发银行能够发现并整理表层不同地点LOB的部件。
查询a 类似员额,以找到消耗空间的桌子。
其他员额:
SELECT owner, table_name, column_name
FROM dba_lobs
WHERE segment_name = SYS_LOB<<identifier>>$$
I m trying to export some tables from SQL Server 2005 and then create those tables and populate them in Oracle. I have about 10 tables, varying from 4 columns up to 25. I m not using any constraints/...
I ve got the following objects: CREATE FUNCTION CONSTFUNC RETURN INT DETERMINISTIC AS BEGIN RETURN 1; END; CREATE TABLE "FUNCTABLE" ( "ID" NUMBER(*,0) NOT NULL, "VIRT" NUMBER GENERATED ALWAYS AS ...
The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...
I was wondering, is there a way to make a kind of one to one left outer join: I need a join that matches say table A with table B, for each record on table A it must search for its pair on table B, ...
I need to be able to run an Oracle query which goes to insert a number of rows, but it also checks to see if a primary key exists and if it does, then it skips that insert. Something like: INSERT ALL ...
I just came across NULL values in NOT-NULL fields in our test database. How could they get there? I know that NOT-NULL constraints can be altered with NOVALIDATE clause, but that would change table s ...
I m studying databases and am currently working on a object-relational DB project and I ve encountered a small problem with the number of possible constraints in an object table. I m using "Database ...
we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...