Member Avatar for shapam

i want to know tht how to overwrite data(Tables) with existing tables in oracle database.
first i imported some tables using .dmp file then some table_names was in tht .dmp file.
then again i run tht import command with tht same syntax now tht showing some tables are already exist in database.

can anyone help me to fix this warning..

  • 2 Contributors
  • 1 Reply
  • 79 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

If you are using IMP command you need to use the parameter DATA_ONLY.

If you are using IMPDP command you need to use the parameter TABLE_EXISTS_ACTION.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.