Same situation here too. Alter table move does not move LOB
segments. I raised this issue in the forum few months ago,
and Regis came up with one suggestion.

ALTER TABLE tname MOVE TABLESPACE newtbs LOB(column_name) STORE AS
(TABLESPACE newtbs DISABLE STORAGE IN ROW).

But this does not move LOB index segments, if i remember correctly.

Current workaround i am doing presently is
- Take an export using the tables option (grants=cons=index=row=y)
- import userid/pw file=dmpfile log=logfile show=Y
- Edit the logfile and change the tbs.
- drop the tables
- create the stru based on the contents of the edited logfile
- import with ignore=Y

---
HTH

GovindanK
|XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX|
|ABSENCE OF EVIDENCE DOES NOT CORRELATE TO EVIDENCE OF ABSENCE|
|XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX|




On Thu, 27 Feb 2003 16:48:53
April Sims wrote:
>Anyone know how to remove these lob segments? leftover in a tablespace
>where I have exported all items out, dropped tables and reimported them in
>to a different tablespace...
>
>Not sure how they got there....I am doing a mass alter table move and alter
>index rebuild and any leftover have long datatypes...
>
>which I moved by export/import. I can't drop the tablespace with them
>there and Metalink is down.
>
>SYS_IL0000430640C00002$$
> LOBINDEX DEVELOPMENT
> 3
> 40882 512000 125 1 512000 512000
> 1 2147483645
> 0 1 1 3 DEFAULT
>
>SYS_LOB0000430640C00002$$
> LOBSEGMENT DEVELOPMENT
> 3
> 21100 512000 125 1 512000 512000
> 1 99
> 0 1 1 3 DEFAULT
>
>Thanks
>
>
>
>
> >>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<
>April Sims MCSE, CNE Abilene Christian University
>OCP 8i 9i DBA ACU Box 29005
>Information Technology Abilene, TX 79699
>[Email Address Removed] Vx:(915)674-2681 Fx:674-6724
> >>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<
>
>
>
>--------
>Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] 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
>
>


_____________________________________________________________
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
Oracle LazyDBA home page