I know you mentioned not using datapump, but that’s how we do it. We do a
datapump import over the network, which doesn’t require the disk space that
exporting to a file, then importing from the file would require and it doesn’t
take as long. The only issue is that any tables with LONG or LONG RAW columns
will not be brought over. Those will have to be done manually. They will be
created.
Scott Canaan ’88 (srcdco@xxxxxxx<mailto:srcdco@xxxxxxx>)
(585) 475-7886 – work (585) 339-8659 – cell
“Life is like a sewer, what you get out of it depends on what you put into it.”
– Tom Lehrer
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Michael Calisi
Sent: Tuesday, February 07, 2017 11:33 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Populate new 12c database
The database I am currently running is on 11.2.0.4.0. We went and build a new
12c database on a different node.
I am now looking to populate my new 12c database with my 11 database data.
What's the best method with limited downtime? I was thinking of using RMAN but
not sure that's possible. We are not looking to do a traditional exp/imp pump
it will take to long and the database is over 5TB.
Thanks.
--
Michael A. Calisi