Home » SQL & PL/SQL » SQL & PL/SQL » Fast database generation
Fast database generation [message #259977] Fri, 17 August 2007 01:25 Go to next message
Kingfisher
Messages: 40
Registered: August 2007
Location: Oslo, Norway
Member
hi

We need to generate many databases from a template database for code testing purposes.

What is the fastest way to do this?

Regards,
Rolf
Re: Fast database generation [message #259981 is a reply to message #259977] Fri, 17 August 2007 01:34 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Are you sure you want to generate multiple databases or you mean multiple schemas ?
Re: Fast database generation [message #260023 is a reply to message #259981] Fri, 17 August 2007 03:06 Go to previous messageGo to next message
Kingfisher
Messages: 40
Registered: August 2007
Location: Oslo, Norway
Member
S.Rajaram wrote on Fri, 17 August 2007 08:34
Are you sure you want to generate multiple databases or you mean multiple schemas ?


Yes I do Smile

The developer that asked me said "databases", but really meant schemas.

All testing is done in in-memory databases. Today we do like this:
One build tests against one database.
When we want to test another build we have to clean out the old database and re-populate it before testing again. This takes time, and is too slow for frequent testing.

Production- and production test databases is Oracle 10g.
Re: Fast database generation [message #260026 is a reply to message #260023] Fri, 17 August 2007 03:26 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Export and import would be the fastest, I think. But then again, I'm only a developer...

MHE
Re: Fast database generation [message #260039 is a reply to message #260026] Fri, 17 August 2007 04:24 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
As you're on 10g, you could use Dbms_DataPump
Re: Fast database generation [message #260048 is a reply to message #260039] Fri, 17 August 2007 04:52 Go to previous messageGo to next message
Kingfisher
Messages: 40
Registered: August 2007
Location: Oslo, Norway
Member
JRowbottom wrote on Fri, 17 August 2007 11:24
As you're on 10g, you could use Dbms_DataPump


Which is limited to processing HFS files on z/OS?

[Updated on: Fri, 17 August 2007 04:58]

Report message to a moderator

Re: Fast database generation [message #260075 is a reply to message #260048] Fri, 17 August 2007 06:21 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
In the words of Manuel form Fawlty Towers: Que?

There's a nice little example in the docs of how to use Datapump to export a schems and then import it, mapping to a different user.

What are HFS files, and what is z/OS?

Re: Fast database generation [message #260079 is a reply to message #260075] Fri, 17 August 2007 06:35 Go to previous message
Kingfisher
Messages: 40
Registered: August 2007
Location: Oslo, Norway
Member
JRowbottom wrote on Fri, 17 August 2007 13:21
In the words of Manuel form Fawlty Towers: Que?

There's a nice little example in the docs of how to use Datapump to export a schems and then import it, mapping to a different user.

What are HFS files, and what is z/OS?

I have probably misread some of Oracles' docs, because I read one section as this feature is only available on...

HFS is a file system. z/OS is used on IBM servers.

I will look into the datapump. Thanks.
Previous Topic: auto genrated no
Next Topic: Matrix query from a single table
Goto Forum:
  


Current Time: Sun Dec 04 02:13:41 CST 2016

Total time taken to generate the page: 0.18076 seconds