Re: Coalescing Tablespaces

From: sysdba <sysdba_at_inter.net.il>
Date: Tue, 5 Oct 1999 16:45:57 +0200
Message-ID: <7td2gt$r1s$1@news2.inter.net.il>

if u sure thats your tablespace name, try do the command:

alter tablespace "TEMP_SET1_U05" coalesce;

notice for the " character.

If it will go, then you might have a problem with your data dictionery (someone update system tables ??)

Asaf Shoval,
Oracle Israel Support Center

<amerar_at_ci.chi.il.us> wrote in message news:7tacp3$1hm$1_at_nnrp1.deja.com...
>
>
> Hello,
>
> I was trying to coalesce one of our tablespaces using this command:
>
> alter tablespace TEMP_SET1_U05 coalesce;
>
> But it says it cannot find the tablespace. Ummm, is there as trick to
> this command that I should know about???
>
> Arthur
> amerar_at_ci.chi.il.us
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 05 1999 - 09:45:57 CDT