Re: Development Environment under Oracle

In <4919c7$l0c_at_intp1.columbus.co.za> stef_at_columbus.co.za (Stef Viljoen) writes:
>
>
>We have just recently converted to Oracle and are experiencing
 problems
>with the setting-up of our development environment. Our requirements
 are
>as follows:
>
>The development environment should consist of three different
 'levels'.
>
>These are: 1) An environment for new development where changes to the
> metadata are usually quite extensive and new projects are
> initialized from.
> 2) An environment where day-to-day changes are made to
 exsisting
> systems, and where these changes can be tested. Due to the
> complexity of our data, we need a coplete copy of our
 production
> database here.
> 3) An environment where applications can undergo final
 compilation
> and where the database should be an exact copy of the
 production
> database, but without any data (an empty shell).
>
>Our database sizes in the range of 20 gigabytes and because of space
 constraints
>have only managed to implement the test environment. We are now
 batteling to
>get the empty database (point 3 above) in place. We have tried
 exporting the
>production metadata but the storage parameters are included in the
 export.
>These can be edited out but it is a very time consuming job.
>
>Any ideas of how to handle this?
>How do other Oracle sites setup their development environments??
>Any suggestions are most welcome.
>
>
>Stef Viljoen. -- stef_at_columbus.co.za
>
Stef,

Why not use the Show option of Export to produce a SQL command file of Create Table statements including Tablespace and Storage qualifiers. Then use sed or awk to remove the Storage clauses. The Create Table statements will then inherit the tablespace defaults, typically 10k for the initial extent.

Rich Received on Fri Nov 24 1995 - 00:00:00 CET