Linux and Oracle commands used

--- Use an oracle user to go to sqlplus to delete the user and create another user and grant permissions

-- The permission must have synonym; otherwise, an error occurs when the imp dmp file is used.

Su-Oracle

Sqlplus/As sysdba

Drop user base cascade;
Create user base identified by zdsoft default tablespace tbs_base;
Grant connect, resource, create table, create view, execute any procedure, create any synonym to base;

 

-- Exit to execute the command line to import DMP data to the database
IMP system/zdsoft file = center2010-08-04.dmp fromuser = sxcenter touser = base2

 

-- Export the user's database to the DMP File

Exp base/zdsoft file = base2.6/base2.0 _ 201008.dmp

 

-- Export the specified table to dmp

Exp base2/zdsoft file = base2.6/base2.0 _ 201008.dmp tables = base_class, upper, base_family, base_grade, base_school, base_student, upper, base_unit, base_user, base_order, su_ware, su_server, upper

 

-- Copy the base2.6 folder to another machine.

Oracle@192.168.1.86:/home/Oracle/SCP-r base2.6/