Re: Create Schema
From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Fri, 08 Nov 2013 07:07:34 -0700
Message-ID: <527CF026.5030107_at_gmail.com>
Why? How often does it change? What are the business reasons around this? What connectivity? What version of database? Is seed data to be included? Is this for training or production? etc. etc. etc.
Date: Fri, 08 Nov 2013 07:07:34 -0700
Message-ID: <527CF026.5030107_at_gmail.com>
Why? How often does it change? What are the business reasons around this? What connectivity? What version of database? Is seed data to be included? Is this for training or production? etc. etc. etc.
There are several ways that might work, including transportable tablespace (which is how Oracle distributes and includes the sample database schemas), deferring segment creation, data pump import, external tables using data pump, DBLink, Pluggabe container DBs.
You don't describe much about how you are doing this now to achieve your (rather good 12 minutes), so t's hard to make suggestions.
/Hans
On 07/11/2013 10:41 PM, Raju Angani wrote:
> I was wondering, if there's a way to speed-up the schema creation (say
> 2 minutes).
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 08 2013 - 15:07:34 CET