Insert statements from data from original tables

[phoenix]

I would like insert statements from data from original tables. I looked at this. I know you can do right click, Export Dataset, insert statements. Is there a way to copy the data from the original tables that you pulled your data from? I am selecting from four tables. I would like the original data from the four tables but only the records I am selecting from. My goal is to start over on a new database with only the data I am selecting from. The four original tables all have over a million records each so do not want to do:

create table table1 as (select * from table1@original_database);

create table table2 as (select * from table2@original_database);

create table table3 as (select * from table3@original_database);

create table table4 as (select * from table4@original_database);

How to generate insert statements for selected columns

Hi there, I use Toad 10 full version. I would like to know whether there is any way to create insert statements only for selected columns (Not for rows). I tried to edit the dataset while exporting data as Insert Statements but it is not editable. In earlier versions of Toad, we have the privilege to select the columns to create insert statements. I guess the alternative way is to create a temporary table with selected columns and then create insert statements. Please advice. Thanks in A…

Select the rows you want in the grid.
Right-click->Export Dataset.
Choose "insert statements".
Check the box that says "Export only the selected rows".

[JohnDorlon]

How about:

create table table1 as (select * from table1@original_database where ..... );

using a where clause that will limit it to the rows you actually want?

Oracle does not keep track of the "original" rows in a table or where they came from, so there is no way to select just those rows unless you know which ones they are and can use a where clause to select them.