Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with Truncate Table

Re: Problem with Truncate Table

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Thu, 01 Mar 2007 15:55:29 GMT
Message-ID: <RHCFh.4040$Tg7.3763@trnddc03>


BGT wrote:
> On Mar 1, 7:46 am, "gazzag" <gar..._at_jamms.org> wrote:

>> On 1 Mar, 11:53, "BGT" <bgt0..._at_optonline.net> wrote:
>>
>>
>>
>>> I have since determined that this only applies to approx 4 tables out
>>> of 150.  
>> Could you DESCRIBE each of the four tables affected and post the
>> output here, please?
>>
>> HTH
>>
>> -g

>
> Sure,
>
> Needles to say I have the same structure running in 10 + databases
> with no troubles except this one..
>
> SQL> desc azcms_tst.disorder_archive;

By any chance are these "tables" actually synonym pointing somewhere else and the "somewhere else" doesn't exist or had a problem? Or perhaps  is the table part of a cluster? Received on Thu Mar 01 2007 - 09:55:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US