2 ways Oracle Exports DMP files

Exporting data using exp and EXPDP

1.exp Export Data Command

Exp gd_base/@192.168. 13.211 file=d:\export\gd_base.dmp log=d:\export\gd_base.log full=y

2.EXPDP Exporting data

(1) CMD window to connect to database, go to Sqlplus page

Sqlplus Sys/[email protected]192.168. 13.211/oanet as Sysdba

(2) Create a directory object (created with Administrator account login)

' D:\FZB ';

Once created, Exit Sqlplus.

(3) Create the appropriate directory on the operating system , such as creating a folder in the D drive directory Fzb

(4) Connection Database Execution Export command

Import the base library and the Dbwizard library all at once

EXPDP system/123123@192.168. 13.211/oanet   directory=dump_dir dumpfile=gd_base_and_gd_dbwizard.dmp   schemas=gd_base, Gd_dbwizard

2 ways Oracle Exports DMP files