Member Avatar for Perry31

Hi,

I want to take backup of all my tables in my system and i want to use in other system.Tell me how to take back up tables in oracle 9i and how to import or use those backup table in another system???

  • 2 Contributors
  • 1 Reply
  • 95 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

You need to take and export of the schema and import the same into the target system.

you need to use the following commands for the purpose.

EXP
IMP

please find the details here , here and here.

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.