Re: transporting 3 TBs of data to a new database
- From: Ian Cary <ian.cary@xxxxxxxxxxxxxx>
- To: oracledbaquestions@xxxxxxxxx
- Date: Tue, 30 Sep 2008 15:39:40 +0100
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@fr|
| | eelists.org |
| | |
| | |
| | 30/09/2008 15:28 |
| | Please respond to |
| | oracledbaquestions|
| | |
|---------+----------------------------->
>--------------------------------------------------------------------------------------------------------------|
|
|
| To: oracle-l@xxxxxxxxxxxxx
|
| 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.
Other related posts:
