Re: DB Setup - Dump file versus SQL Loader

On Jun 8, 1:37 am, AnGanesh <angan..._at_gmail.com> wrote:
> Dear All,
>
> I am working for a product based company. For DB setup for our
> product, we are currently using the dump file to generate all the
> required tables and initial data. As part of initial data setup, we
> have both static/lookup data loading and test data loading as well
> (nearly 130 tables have data setup).
>
> During development, we are facing great challenge in the dump file
> generation.... to even make small changes to data and test the same,
> we have to go through the complete process of dump file preparation
> and checking in the same. To avoid this one of the suggestion is to
> move away from dump file and have scripts for tables/views/sp
> creation
> and load initial data using sql loader. Concern with this approach
> is
> my installation process becomes bulkier (will take more time to
> create
> tables and then the sqlloder lot of log files). Number of log files
> to skim through to see whether installation is successful or not etc.
>
> Any suggestions or sharing your experience on this will be of great
> help !!!
>
> Thanks
> Ganesh

Is there the possibility of using transportable tablespaces? The transfer time for the tablespace files may be an issue, however the import of the tablespace metadata is quick.

You can investigate this process here:

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#i1007169

David Fitzjarrell

"Pardon me," said Milo to the first man who happened by; "can you tell me where I am?"

"To be sure," said Canby; "you're on the Island of Conclusions. Make yourself at home. You're apt to be here for some time."

"But how did we get here?" asked Milo, who was still a bit puzzled by being there at all.

"You jumped, of course," explained Canby. "That's the way most everyone gets here. It's really quite simple: every time you decide something without having a good reason, you jump to Conclusions whether you like it or not. It's such an easy trip to make that I've been here hundreds of times."

"But this is such an unpleasant-looking place," Milo remarked.

"Yes, that's true," admitted Canby; "it does look much better from a distance."

• Norton Juster, "The Phantom Tollbooth"