Return-Path: <ml-errors@fatcity.com>
Received: from ensim.rackshack.net (root@localhost)
 by orafaq.net (8.11.6/8.11.6) with ESMTP id h6TFM5s22805
 for <oracle-l@orafaq.net>; Tue, 29 Jul 2003 10:22:05 -0500
X-ClientAddr: 66.27.56.210
Received: from ns3.fatcity.com (rrcs-west-66-27-56-210.biz.rr.com [66.27.56.210])
 by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h6TFM4p22798
 for <oracle-l@orafaq.net>; Tue, 29 Jul 2003 10:22:04 -0500
Received: from ns3.fatcity.com (localhost.localdomain [127.0.0.1])
 by ns3.fatcity.com (8.12.5/8.12.5) with ESMTP id h6TD29Rj008612
 for <oracle-l@orafaq.net>; Tue, 29 Jul 2003 06:02:11 -0700
Received: (from root@localhost)
 by ns3.fatcity.com (8.12.5/8.12.5/Submit) id h6TCtPEv007063
 for oracle-l@orafaq.net; Tue, 29 Jul 2003 05:55:26 -0700
Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005C7A60; Tue, 29 Jul 2003 05:49:23 -0800
Message-ID: <F001.005C7A60.20030729054923@fatcity.com>
Date: Tue, 29 Jul 2003 05:49:23 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
X-Comment: Oracle RDBMS Community Forum
X-Sender: <rgaffuri@cox.net>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: <rgaffuri@cox.net>
Subject: ocp question
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Im using the osborne OCP books for review. They say you can do 

analyze table <table_name> validate structure into <storage of bad rows table>

I do that I get ORA-14510 only place its documented is on metalink and it says:

Error:	ORA 14510 Text:	can specify VALIDATE INTO clause only for partitioned tables  --------------------------------------------------------------------------- Cause:	The VALIDATE INTO has been specified for a non partitioned table or  	cluster or index.  Action:	Use syntax correctly 
. 

how do you define where you want to store your results ofa  validate structure. I know you can use the invalid_rows table, but Im testing. and the book is wrong. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <rgaffuri@cox.net
  INET: rgaffuri@cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).