Re: TTS Self-contained restriction workaround
From: Jeremy Schneider <jeremy.schneider_at_ardentperf.com>
Date: Mon, 27 Jun 2016 16:15:57 -0400
Message-Id: <1623FF0F-EF8F-4215-860A-37C8E54ECFEF_at_ardentperf.com>
Date: Mon, 27 Jun 2016 16:15:57 -0400
Message-Id: <1623FF0F-EF8F-4215-860A-37C8E54ECFEF_at_ardentperf.com>
> On Jun 27, 2016, at 10:55 AM, sharmakdeep_oracle wrote:
>
> We tried it on the Test DB and it took 8 hrs. Test DB is 3TB vs Prod which is 170TB. Haven't tried in Prod yet.
The object count might be a bigger factor than size, though extent count would probably factor in too. At any rate you might find that the time doesn't increase as much a you'd expect even though your PROD db is a lot bigger.
FYI - I have seen some TTS exports go quite long for large schemas (in both size and object count) -- though I never saw one go 8 hours...
-Jeremy
Sent from my iPhone
http://about.me/jeremy_schneider
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 27 2016 - 22:15:57 CEST