What is the name of the table that you cannot truncate? And please provide
the exact command you are typing.
"Matthias Wirtz" <Matthias.Wirtz_at_abbrevation.com> wrote in message
news:c3v2u4$2d9670$1_at_ID-151394.news.uni-berlin.de...
> Hi,
>
> facing this ORA-03291 while trying to truncate a table.
>
> No cluster, no referential integrity in place. I have four tables. Three
of
> them I can truncate and one gives me this error back. The table definition
> looks like this for all four:
>
> CERATE TABLE <table_name> (cols...) TABLESPACE <tablespace>;
>
> Why am I forced to use the STORAGE clause for this particular table? Where
> is the difference?
>
> PS: using 9i on win2k
> --
> Matthias Wirtz - Norfolk, usa
Received on Thu Mar 25 2004 - 11:29:45 CST
