Re: transporting 3 TBs of data to a new database

From: Ian Cary <ian.cary_at_ons.gsi.gov.uk>
Date: Tue, 30 Sep 2008 15:39:40 +0100
Message-ID: <OF2560415B.F12735EC-ON802574D4.00505A3B-802574D4.0050A11E@ons.gsi.gov.uk>


You might want to look at using DBMS_FILE_TRANSFER. I've used this to copy files in and out of ASM using transportable tablespaces a number of times and it works well.

Cheers,

Ian

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

| | oracledbaquestions|
| | @gmail.com |
| | Sent by: |
| | oracle-l-bounce_at_fr|
| | eelists.org |
| | |
| | |
| | 30/09/2008 15:28 |
| | Please respond to |
| | oracledbaquestions|
| | |
|---------+-----------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: oracle-l_at_freelists.org | | cc: | | Subject: transporting 3 TBs of data to a new database | >--------------------------------------------------------------------------------------------------------------|

I am on ASM, the group moving the data is not. I think transportable tablespaces is the best way to do this. So I have to use RMAN to put the data in ASM. Is this a copy to an an ASM tablespace? Any idea how this works? I am trying to figure out how long this will take. We may be able to do it in pieces.

I dont think data pump is good for this.

I also dont know a good wait to write comma delimitted files out of this much data to sql load.

This email was received from the INTERNET and scanned by the Government Secure Intranet anti-virus service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) In case of problems, please call your organisation’s IT Helpdesk. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.

For the latest data on the economy and society consult National Statistics at http://www.statistics.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 in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) 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. i0zX+n{+i^ Received on Tue Sep 30 2008 - 09:39:40 CDT

Original text of this message