Re: Metalink disaster
Date: Sat, 14 Nov 2009 08:05:08 -0800 (PST)
On Nov 14, 10:33 am, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> 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;
> CREATE TABLE PRINT AS
> ALTER TABLE PRINT ADD (ACTIVE CHAR(1));
> 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 220.127.116.11 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.
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Sat Nov 14 2009 - 10:05:08 CST