What is your HA solution?

It sounds totally worthless if it prevents you from making simple changes to
a database without downing the cluster.

Try something like this:

If you need to move the table and lobsegment:

ALTER TABLE foo MOVE
TABLESPACE new_tbsp STORAGE(new_storage)
LOB (lobcol) STORE AS lobsegment
(TABLESPACE new_tbsp STORAGE (new_storage));

hth

Chuck

----- Original Message -----
From: "Sade Jacobs" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, January 31, 2002 6:20 AM
Subject: tablespace out of free space!


> Hi guys,
> I'm in a fix right now.
> I have a lobsegment that needs to be extended, but it
> can't because i don't have enough space on the
> tablespace it's on.
> Naturally i would have added a datafile to the
> tablespace, but my senior dba does not like that
> approach.
> I've also checked out the option of 'resizing' the
> datafile. I have enough space on the disk, but because
> we have a clustered/HA system, the box has to be
> brought down as not to mess things up. I can't afford
> that to happen.
> The only option i can think of, even though i've never
> used it is the "alter table...move". I have free space
> on another tablespace in the database that i can move
> this this lobsegment to.
> Can you kindly send me the right syntax, and is it
> adviceable to do this on a production box or should i
> just stick to what i know, and bring down the system?
>
> Rgds,
> Sade.
>
> __________________________________________________
> Do You Yahoo!?
> Great stuff seeking new owners in Yahoo! Auctions!
> http://auctions.yahoo.com
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>

Oracle LazyDBA home page