Oracle database DMP file Import and Export

I. Database DMP file Export

Under the PL/SQL tool, select Export Tales, select all tables, and select the exported path.

Second, database DMP file Import

Create user table space;

Create User: Grant DBA to AML;

Execute Import Script: (premise: Windows Server has created TNS connected to database)

IMP username/password @tns user file=***.dmp (DMP file path) full=y;

This article is from the "sea pick-up Shell" blog, please be sure to keep this source http://angeljing.blog.51cto.com/7370594/1936660

Oracle database DMP file Import and Export