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 LazyDBA home page