Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Automanagement of extent sizing
!! Please do not post Off Topic to this List !!
I must be spacing out here, I found where I got the idea that you can not use alter tablespace move with a long,
"The drawback to using this
method is the you cannot move a table with a LONG or LONG RAW. You must exp
that table and imp it into a table."
http://asktom.oracle.com/pls/ask/f?p=4950:8:123086::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:47812348053,%7BALTER%7D%20and%20%7BTABLE%7D%20and%20%7Bmove %7D
But I can't find it in the docs and don't have access to 8i a the moment to test. I swear I saw it in the docs too. Anyone back me up on this? - E
>-----Original Message-----
>From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
>Sent: Thursday, September 13, 2001 4:40 PM
>To: Multiple recipients of list ORACLE-L
>Subject: RE: Automanagement of extent sizing
>
>
>!! Please do not post Off Topic to this List !!
>
>Ethan - Can you use the SQL command ALTER TABLE MOVE? In a
>quick glance at
>the documentation, it seems like you could probably use it on
>a table with a
>LONG. Test it first, obviously.
>
>Dennis Williams
>DBA
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: epost_at_kcc.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Sep 13 2001 - 18:09:52 CDT
![]() |
![]() |