Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tablespace problem with standby database
alter tablespace temp add tempfile
tablespace cannot be dropped but you can drop and add tempfiles of arbitrary size
in metalink you can find this information
most information here is incorrect
"clueless" <ro_cright_at_hotmail.com> schrieb im Newsbeitrag
news:TW679.8211$V21.159030_at_news...
> oracle 8.1.7.4 on w2k, dell box 4 processors
>
> I have a standby database that I use for reporting purposes. The standby
is
> in NON-managed mode and remotely hosted.
>
> Several reports are run against the standby database that is open in read
> only mode and some of the queries cause a lot of sorting, etc. Oracle
> attempts to increase the size of the TEMP tablespace to accommodate the
> sorting and fails because the database is in read only mode.
>
> I want to increase the size of the TEMP tablespace in the production
> database then migrate that change to the standby via the ARLogs. The
> problem I have is that I cannot drop the TEMP tablespace and re-create it
> and set the initial size higher than it is. I see a lot of information on
> the web concerning reducing the size of an existing tablespace but nothing
> on increasing the size of an existing tablepsace forcing it to increase
the
> size immediately.
>
> The existing temp tablespace uses 2 datafiles tmp1(2 gig, .008% used,
> autoextend) and tmp2(11gig 9%used, autoextend).
> The tablespace itself, temp, is 12gig and at 9% used and the extents are
> unlimited.
>
> I will continue looking into this issue today and will post the solution
> if/when I find it.
>
> Cheers
>
>
Received on Sat Aug 17 2002 - 05:08:31 CDT