I'm having a bad mental block today. I'm trying to import a file containing a single table into an existing schema, but I know I have to drop the table in the schema first. What do I need to do?
I know to import into the existing schema, the table has to be dropped. I can do this "imp file=file.dmp log=log.log fromuser=schema1 touser=schema2 table=table" but something has to come before that (dropping the table).
|