On sql server table create your column definition as a TEXT column. But be
aware of the 2g limitation.
-----Original Message-----
Sent: Thursday, August 30, 2001 11:06 AM
To: Multiple recipients of list ORACLE-L
It's working . but how do I move those objects with CLOB Datatype ??
Any Ideas???
----- Original Message -----
To: Multiple <mailto:[EMAIL PROTECTED]> recipients of list ORACLE-L
Sent: Thursday, August 30, 2001 1:26 PM
Easy. Use SQL*Server's DTS (data transformation services) to pull the data
from Oracle into SQL*Server.
Jon Walthour
-----Original Message-----
Sent: Thursday, August 30, 2001 12:07 PM
To: Multiple recipients of list ORACLE-L
Hello Folks,
I am looking for some cool script to move all the database objects
across from Oracle 8.1.7 to Latest Sql Server (ver ???) frequently.
Is there any particular way we can do it to automate this ??
BTW: I want to pledge $20 or even willing to pay yearly subscription and it
would be a good
idea to Send out a Pledge form to everyone . to keep the greens coming..
Cheers
RK
This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shaw, Donnie
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).
