Oracle Database Import and Export

To import the company's database into your own computer (you will need to enter commands under the command window)

To export the base code for a database:

Exp Zj_user_kf/[email protected]_4 file=d:\test3.dmp full=y

Import Database: The first is to create a new user

It is strange that I exported the database again when the import of IMP 00037 error, with the Dungo later sent my database, the code is:

Imp zjph_newuser/zjph_newuser file=e:\zjph_newuser10g20131025.dmp full=y ignore=y

Can not add @orcl default is this. Simply drag the file to the Command window to copy the address.

Oracle Database Import and Export