Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

should i drop schema or truncate tables before importing?

673322Jan 6 2009 — edited Jan 6 2009

I have exported a dump of the whole schema form oracle database. I need to import this to another database with a different schema name but same tables. The only thing i am doing is this to bring data consistent with the other database.

Now Do i need to drop schema or do anything like that to avoid and redundancy or i can just go ahead and do the import? Please let me know how to do it. I would prefer not deleted any tables but truncate all the data if needed from about all 200 tables.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 3 2009

Added on Jan 6 2009

#general-database-discussions, #oracle

3 comments

2,334 views