Re: Metalink disaster
Date: Sat, 14 Nov 2009 08:05:08 -0800 (PST)
Message-ID: <e40276e7-6f99-4f3e-81dd-e887c340e919_at_i12g2000prg.googlegroups.com>
On Nov 14, 10:33 am, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> Mladen,
>
> You might want to check the column definitions for the table PRINT.
> While I have little experience working with clusters, I think that I
> was able to reproduce the problem that you are experiencing.
>
> Here is a test case I created:
> CREATE CLUSTER PRINT_CLU(ACTIVE CHAR(1))
> TABLESPACE USER_DATA
> SINGLE TABLE HASHKEYS 3;
>
(snip)
> CREATE TABLE PRINT AS
> SELECT
> *
> FROM
> DBA_OBJECTS;
>
> ALTER TABLE PRINT ADD (ACTIVE CHAR(1));
>
(snip)
> ALTER TABLE PRINT ADD BLOB_TEST BLOB;
>
> CREATE TABLE PRINT_TMP
> CLUSTER PRINT_CLU(ACTIVE)
> AS SELECT * FROM PRINT WHERE ROWNUM<0;
>
> ERROR at line 3:
> ORA-03001: unimplemented feature
>
> /* OK, same error, I think we found a possible cause of the error */
>
> The above test case was performed on 10.2.0.4.
Just a follow up. Oracle 11.1.0.7 also produces the same error
message when the PRINT table contained a BLOB column. A search of the
documentation found this:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_7002.htm
"Restrictions on Cluster Tables
Cluster tables are subject to the following restrictions:
•Object tables and tables containing LOB columns or columns of the
Any* Oracle-supplied types cannot be part of a cluster.
•You cannot specify the parallel_clause or CACHE or NOCACHE for a
table that is part of a cluster.
•You cannot specify CLUSTER with either ROWDEPENDENCIES or
NOROWDEPENDENCIES unless the cluster has been created with the same
ROWDEPENDENCIES or NOROWDEPENDENCIES setting."
I guess that is something else that may be checked, but I am not sure why a more appropriate error message is not returned as was the case when a LONG RAW column was included in the PRINT table.
Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
Received on Sat Nov 14 2009 - 10:05:08 CST