Re: 17Gb table with long column to be replicated.

From: Ian Cary <Ian.Cary_at_ons.gsi.gov.uk>
Date: Wed, 1 Feb 2012 10:10:29 +0000
Message-ID: <OF61B26007.448B623C-ON80257997.00379945-80257997.0037E45B_at_ons.gsi.gov.uk>

You don't mention which version of Oracle your source data is (I'm assuming Oracle due to the LONG type) but the COPY command is still available in 11g and is the best way of moving LONG's

Cheers,

Ian

|---------+----------------------------->


|         |           Joel.Patterson_at_cro|

|         |           wley.com          |

|         |           Sent by:          |

|         |           oracle-l-bounce_at_fr|

|         |           eelists.org       |

|         |                             |

|         |                             |

|         |           31/01/2012 19:37  |

|         |           Please respond to |

|         |           Joel.Patterson    |

|         |                             |

|---------+----------------------------->
  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |                                                                                                                                                  |
  |       To:       oracle-l_at_freelists.org                                                                                                           |
  |       cc:                                                                                                                                        |
  |       Subject:  17Gb table with long column to be replicated.                                                                                    |
  |                                                                                                                                                  |
  |                                                                                                                                                  |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|

I have a 17Gb table I would like to replicate to either oracle or sqlserver.

It contains a LONG data type columns which is incompatible with materialized views.

Sugestions?

--
http://www.freelists.org/webpage/oracle-l






For the latest data on the economy and society consult National Statistics at http://www.ons.gov.uk

*********************************************************************************


Please Note:  Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications
*********************************************************************************


Legal Disclaimer  :  Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics
*********************************************************************************


The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless Worldwide in partnership with MessageLabs. (CCTM Certificate Number 2009/09/0052.) On leaving the GSi this email was certified virus free.
Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 01 2012 - 04:10:29 CST