Re: How does one exp/imp of table into a different table in the same schema?

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 2000/07/13
Message-ID: <8klg8d$472$1@garnet.tc.umn.edu>#1/1

Look at the problem differently. Reduce the requirements to "dump table into a different table in the same schema." Do not use exp/imp.

SQLPLUS and spool to a file and use sqlload to stuff it into another table.

A different method. Relax the same schema requirement, now "dump table to a table" just grant permissions to another schema.table with the same name and use exp/imp.

-- 


---------------------------------------------------------

Steven Hauser 
email: hause011@tc.umn.edu   URL: http://www.tc.umn.edu/~hause011


---------------------------------------------------------

Received on Thu Jul 13 2000 - 00:00:00 CDT