Import table data to nonexistant or renamed table in Oracle
Posted on 2007-08-04
Hi I'm trying to import a table from one database that has a an extra column third from the bottom ot table. The table I'd like to import it to does not have this column this a test database. So what I did was renamed the target table so that I won't lose the table definition and I started the import. Will the import not see this table create the table and insert the data? Do you know how I can do this. I don't have a lot of time. And I'm only looking a 500,000 rows.