Re: Creating a table while loading data into it - possible?

On Sun, 09 Apr 2006 09:10:13 -0700, DA Morgan <damorgan_at_psoug.org> wrote:

>Dave Baker wrote:
>> I'm using VB to load data from one Access table into a destination table.
>>
>> At the moment the destination table is also Microsoft Access, so it's a very
>> simple matter of doing this:
>>
>> SELECT * INTO tblDestination IN "C:\My Documents\RawData1.mdb" FROM tblSource
>>
>> This command creates an entirely new table (entirely new database too I
>> guess) and populates it from an existing table, all with 1 command.
>>
>> What I want to do now is to make the destination table an Oracle table.
>>
>> Is it possible to do the same thing with one command for Oracle? I can easily
>> do it the hard way by reading the structure of my source table and creating a
>> destination structure then finally populating it, but before getting stuck
>> into that I thought I would just ask here if it is easier than that.
>>
>> Thanks,
>>
>> Dave
>
>You can do it, as others have said, but of far greater concern is why
>you think this is a good idea.

I don't necessarily think it's the best idea, but the current application creates an Access table from another Access table. Presumably & hopefully changing the same application to create an Oracle table from the Access table wouldn't require reinventing the wheel. I'm certainly open to suggestion though.

>Using VB to perform DDL is an indication
>of a very poorly thought out design. Can you explain the business reason?

It's hardly design or a business reason - we are talking about getting some data from a table into another table. In a timely manner.

>Also ... look up the word "database" in the Oracle docs at
>http://tahiti.oracle.com. The word "database" means something very
>different to Oracle than it does in any Microsoft product.

But presumably you knew what it meant...

Thanks for all your valuable help.

Dave Received on Mon Apr 10 2006 - 03:08:29 CDT