Oracle data import and export, client

1: A client must be installed when you use toad to connect to Oracle,

Select instantclient, but if you want to use the DMP file of the imp/exp database or perform the sqlplus operation, you need to select the following (Administrator) [runtime, you have never used custom settings.

2: imp/exp

A: create a user and grant DBA permissions.

Create user zsedu identified by zsedu;

Grant DBA to zsedu;

B: Configure net configuration Assistant

Configure the listener first (the name is the same as the name of the Oracle service installed), and then configure the local net service name. After the test, click Next.

C: run the command imp credu/credu @ myorcl file = D:/zsedu. dmp full = y ignore = Y [@ service name following -- (Step B )]

IMP username/password @ myorcl file = D:/zsedu_all.dmp full = y ignore = y

 

Exp username/password @ myorcl file = D:/cxyx1.dmp full = y