table clone/copy

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: EMW (SomeOne_at_MicroSoft.Com)
Date: 03/17/04


Date: Wed, 17 Mar 2004 20:23:55 +0100

Is it possible to copy an Oracle database table with a SELECT command or
something else?

I tried reading the data from one table in a dataset, then renaming the
table to the one in the database and then do an UPDATE on it, but it didn't
work.

rg,
Eric



Relevant Pages

  • looping
    ... I am writting a perl script which: ... Calls oracle database and produce the desired results ... While I am reading each row data that is fetched by select query from ...
    (perl.beginners)
  • EMC NS series
    ... am i mistaken or is this primarily for file sharing? ... don't see how (reading their marketing lit) that i would, ... run an Oracle database on this that's on a Sun box. ...
    (comp.arch.storage)
  • Re: Need Help
    ... You didn't provide any details about the syntax of the command you ... use for loading the data chunks into the Oracle database, ...
    (comp.unix.shell)
  • Re: Fssnap
    ... I would like to use the above command to obtian a snapshot ... of a Database intsllaed and mounte on /ora9i on a Solaris 8 Server. ... I use fssnap on a regular basis - but the name of your mount point ... implies that you have an Oracle database. ...
    (comp.sys.sun.admin)
  • Re: Values of a Oracle table in C++
    ... see the Vales of the row: ... classes that Oracle has to use for client connectivity? ... I have all the value of my table (in Oracle Database) in the reader, ... There is a variant of the create table SQL command called CREATE TABLE ...
    (comp.databases.oracle.server)