Daniel, I understand what is you are saying and what you tested but I don't the why or what it means. Does it mean that the sql command is not going to work? Does it means that you have to issue it again to get it to work?
Ref: Doc ID: Note:123214.1 invalid Type: PROBLEM Status: PUBLISHED .... Seems that truncate command invalidates object definition and existence in library cache. Invalidation can also be seen on temporary tables! .. Jonathan, The memory problem is described in Doc id:1157495.8 Support Description of Bug 1157495 Ron >>> [EMAIL PROTECTED] 11/12/2003 1:14:25 PM >>> Ron, I don't know about the TRUNCATE option w/ sql*loader, but the regular DDL TRUNCATE invalidates sql that references the table. Example: 1 select sql_text, invalidations 2 from v$sql 3* where sql_text = 'select * from emp' SQL> / SQL_TEXT INVALIDATIONS -------------------------------------------------- ------------- select * from emp 0 SQL> truncate table emp; Table truncated. SQL> select sql_text, invalidations 2 from v$sql 3 where sql_text = 'select * from emp' 4 / SQL_TEXT INVALIDATIONS -------------------------------------------------- ------------- select * from emp 1 Ron Rogers wrote: > Daniel, > How does using the TRUNCATE command is a sqlldr invalidate anything? > The sqlldr truncate command reuses the storage that the table originally > used and does not change the HW mark. If there are indexes on the tables > then they are placed in the "DIRECT PATH" state during the load and > updated with the now block info. > Please explain whet you mean by "invalidate". > Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
