Oracle DBAs...need your help

[TheyCallMeBruce]

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).

[ah123]

You need to drop or truncate the table if I recall correctly -

Dropping table = "drop table xxx"
Truncate table = "truncate table xxx"

(remove quotes, xxx=name of table)

Hope that is what you were looking for...

[TheyCallMeBruce]

Originally posted by ah123@May 27 2005, 03:37 PM
You need to drop or truncate the table if I recall correctly -

Dropping table = "drop table xxx"
Truncate table = "truncate table xxx"

(remove quotes, xxx=name of table)

Hope that is what you were looking for...

Thanks, but I manage to figure it out anyway. I just had to drop all the keys, drop the table, import the table, and rebuild my keys. things are fine now.

[Shawnski]

An alternative in the future for you, should you not what to drop and recreate the indexes, is to import your file into a temporary or staging table, truncate your production table then append to it from the temporary one.

Adds the benefit of being able to view the data before you append it into production, and can be faster.