Database Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

import the full dump and overwrite the exist database

82132206-ce57-4577-8309-bf7012cc3928Mar 18 2015 — edited Mar 23 2015

Hello everyone,

I must import the full dump in the existing database. I want to import and update the data from the productive environment in the test environment. In MS SQL Menagement Studio you can restore the databese quickly (Tasks / Restore /Database).

I'm looking for the similar method in Oracle.

When I try to import the dump manuel, I use this: imp ..... full=y

Then I get the message: cannot overwrite the existing tables or table exist.....

What is the simpler way to update the oracle database?

Thank You very much.

Tom

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 20 2015

Added on Mar 18 2015

#database-key-features, #export-import-sql-loader-external-tables, #import

7 comments

9,398 views