RE: Create Schema

From: Ric Van Dyke <ric.van.dyke_at_hotsos.com>
Date: Fri, 8 Nov 2013 13:53:26 -0600
Message-ID: <C970F08BBE1E164AA8063E01502A71CF021C1983_at_WIN02.hotsos.com>

How about, create it all in a tablespace and then just use transportable tablespace to plug it into the new DB?    

Ric Van Dyke

Education Director

Hotsos Enterprises, Ltd

Hotsos Symposiun March 2-6 2014, Be There.        

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Raju Angani Sent: Friday, November 08, 2013 12:41 AM To: ORACLE-L
Subject: Create Schema  

Hi dbgurus,  

I have a db schema, which has around 950 table, 700 indexes, 70 views, 800 sequences.  

As of now when I deploy the schema, it takes around 10-12 minutes.  

I was wondering, if there's a way to speed-up the schema creation (say 2 minutes).  

Thank you

RA    

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 08 2013 - 20:53:26 CET