!! Please do not post Off Topic to this List !!
...or copy command of sqlplus.
Regards.
--- Suhen Pather <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]
> >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.
> >[EMAIL PROTECTED]
> >--
> >Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >--
> >Author: DENNIS WILLIAMS
> > INET: [EMAIL PROTECTED]
> >
> >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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
[EMAIL PROTECTED]
[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
