Re: How to export data from one table, then load it in another ???

On 2 Dec 1997 22:57:35 GMT, "Dmitriy Evinshteyn" <Dmitriy.Evinshteyn_at_lgtna.com> wrote:

 Another easy way that I have found for accomplishing this same task is to export the table without the data. Then take the export file and edit it with a text editor to get the sql statements for creating the table along with the indexes and constraints. Then write an insert statement to select the data from the old user.table into the new table. When you are done you will have a script for creating the table, indexes and constraints.

 It seems to work best for me when I use a unix shell script to make everything lowercase and take out all of the double quotes that oracle's export utility likes to put around object names.

>Take a look at ORACLE Monitor http://www.softtreetech.com/monitor/.
>
>Export/Import to and from numerous popular file formats including export to
>HTML.
>5 steps:
>1. Open table
>2. Save data to the file
>3. Open same or another table
>4. Load data from the file
>5. Save imported data
>
>and much, much more...
>
>Julio <julio.negueruela_at_si.unirioja.es> wrote in article
><34835A0D.5FD2_at_si.unirioja.es>...
>Sergei Didur wrote:
>>
>> Hi everybody !
>>
>> Is it possible to export data from one table and store it in file (on
 disk
>> or tape),
>> then import it (from disk or tape) to another table within the same user
>> schema ???
>>
>> Thanks in advance,
>> Sergei Didur
>
>When you do an export the tables structures are store then, at
>importing, the import utility attempts to create the table and after
>insert the rows. So I'm afraid it's not useful for you.
>
>I think it would be better for you to execute the SQL statement:
>CREATE TABLE <NEW TABLE> AS SELECT * FROM <OLD_TABLE>
>{WHERE <CONDITION SEARCH>};
>This way the names of the columns of the new table are the same than
>than the old table's.
>Other way, you can create the new table with different column names and
>execute:
>INSERT INTO <NEW TABLE> SELECT * FROM OLD TABLE;
>You should define the new table's columns in the same order than the old
>table.
>
>Regards
>--
>Julio Negueruela
>Telf: 941-299177 Fax: 941- 299244
>Servicio Informático
>Universidad de La Rioja - Spain
>mailto:julio.negueruela_at_si.unirioja.es
>
>----------
>

• ========= ========= ========= ========= Noah Monsey noah_at_azlink.com
• ========= ========= ========= ========= The only dumb question is the one that you don't ask.
• ========= ========= ========= ========= Oracle Master Database Administration April 1992 Oracle Master Application Development April 1992
• ========= ========= ========= =========