Re: rbs01.dbf
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 16 Feb 2002 19:28:45 +0100
Message-ID: <u6t9ke9rq8c635_at_corp.supernews.com>
Date: Sat, 16 Feb 2002 19:28:45 +0100
Message-ID: <u6t9ke9rq8c635_at_corp.supernews.com>
"Jose Reyes" <jreyes_at_answerthink.com> wrote in message
news:3C6DB1B7.3F343BAB_at_answerthink.com...
> how does one go about decreasing the size of this file? It is taking up
> tons of space on my system, I don't want to just delete it but I would
> like to know how to make it smaller and maybe put a limit on how large
> it can grow.
>
>
> Thanks!
alter database datafile '<filename>' resize <number> M
Hth
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail addressReceived on Sat Feb 16 2002 - 19:28:45 CET