temporary tables

#11

On Jul 25, 3:26*am, Robert Klemme <shortcut... (AT) googlemail (DOT) com> wrote:

Quote:

On 07/24/2010 08:06 PM, francogrex wrote:

Eventually I could SELECT INTO a table in an
external database. But I am using ODBC to
connect to the ORACLE server and I don't have
any local ORACLE database I can select into.

Here's another option: create your own instance on a different system
and copy the data via Data Pump or a database link. *Then you can create
indexes etc. in your own copy of the DB. *Update efficiency is still an
issue. *But if this is a one off operation then this approach might be
feasible.

Kind regards

Adding a little to that, if your data and processing requirements are
"small" enough, use XE on your local system. See the docs for the
limitations. Besides its own tools, it is a full Oracle environment
so you can grab the data in several ways depending on how much access
you have to the server. I bet your ODBC access definition has enough
information to make a dblink or tnsnames, if you can't just log onto
the server and export. And if you are using ODBC, I suspect your
requirements are "small" enough.

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2...sure-alarming/

#12

On Apr 26, 8:13*am, Carter34Jaime <u... (AT) compgroups (DOT) net/> wrote:

Quote:

freelance writer

And major spam asshole.

jg
--
@home.com is bogus.
http://www.orafarm.com/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

temporary tables

comp.databases.oracle.server comp.databases.oracle.server

Re: temporary tables - 07-26-2010 , 04:09 PM

Re: temporary tables - 04-26-2011 , 10:35 AM