!! Please do not post Off Topic to this List !!
...or copy command of sqlplus.
Regards.
- Suhen Pather <Suhen.Pather_at_strandbags.com.au>
wrote:
> !! Please do not post Off Topic to this List !!
>
>
>
> You cannot use the alter table move on a table with
> LONG columns.
> *
> ERROR at line 1:
> ORA-00997: illegal use of LONG datatype
>
> I would normally use export/ import
>
> Regards
> Suhen
>
>
>
> 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).
> >
>
>
> --
> This e-mail is intended for the use of the
> addressee(s) only and may contain
> privileged, confidential, or proprietary information
> that is exempt from
> disclosure under law. If you have received this
> message in error, please
> inform us promptly by reply e-mail, then delete the
> e-mail and destroy any
> printed copy. Thank you.
>
>
> ==
> --
> 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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Suhen Pather
> INET: Suhen.Pather_at_strandbags.com.au
>
> 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).
Eng. Christian Trassens
Senior DBA
Systems Engineer
ctrassens_at_yahoo.com
ctrassens_at_hotmail.com
Phone : 541149816062
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christian Trassens
INET: ctrassens_at_yahoo.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 Fri Sep 14 2001 - 02:51:59 CDT