Sql> SELECT table_name,
2 Partitioning_type TYPE,
3 P.subpartitioning_type,
4 P.partition_count
5 from User_part_tables P
6 WHERE p.table_name = ' P_partition_rang ';
TABLE_NAME TYPE Subpartitioning_type Partition_count
------------------------------ ------- -------------------- ---------------
P_partition_rang RANGE NONE 4
sql> ANALYZE TABLE P_partition_rang validate structure cascade;
ANALYZE TABLE P_partition_rang Validate structure Cascade
*
ERROR at line 1:
Ora-14508:specified VALIDATE into table not found
This error is recorded in [ID 111990.1] , which can be executed manually after the Utivalid.sql is created to create the table invalid_rows.
Sql> @?/rdbms/admin/utivalid.sql
sp2-0310:unable to open file "/oracle/app/oracle10g/rdbms/admin/utivalid.sql"
Sql> @?/rdbms/admin/utlvalid
sp2-0310:unable to open file "/oracle/app/oracle10g/rdbms/admin/utlvalid.sql"
Sql> host more $ORACLE _home/rdbms/admin/utlvalid.sql
rem
REM-Copyright (c) 1990, 1995, 1996, 1998 by ORACLE C Orporation
Rem NAME
rem utlvalid. SQL
rem FUNCTION
rem creates the default table for storing the output of the
REM &N bsp; Analyze validate command on a partitioned table
rem NOTES
rem MODIFIED
rem & nbsp; syeung 06/17/98-add subpartition_name
rem mmonajje 05/21/96-replace timestamp col name with Analyze_timestamp
rem sbasu 05/07/96-remove echo setting
rem ssamu 01/09/96-new file utlvalid.sql
Rem
CREATE TABLE Invalid_rows (
owner_name varchar2 (30),
table_name varchar2 (),
Partition_name varchar2,
subpartition_name varchar2 (),
head_rowid rowID,
analyze_timestamp date
;
Sql> CREATE TABLE Invalid_rows (
2 owner_name varchar2 (30),
3 table_name VARCHAR2 (30),
4 partition_name varchar2 (30),
5 subpartition_name varchar2 (30),
6 Head_rowid rowID,
7 Analyze_timestamp Date
8);
Table created.
sql> ANALYZE TABLE P_partition_rang validate structure cascade;
Table analyzed.