bayaim——达梦数据库 导入导出

导出：

E:\dmdbms\bin\dexp.exe """SYSDBA"""/"""******"""@LOCALHOST:5236 DIRECTORY=E:\dmdbms FILE=bai01.dmp TABLES=("""DMHR"""."""DEPARTMENT""") TABLESPACE=N DROP=N LOG=exp_2019_08_16_14_03_13.log LOG_WRITE=N

 

导入：

E:\dmdbms\bin\dimp.exe """SYSDBA"""/"""******"""@LOCALHOST:5236 DIRECTORY=E:\dmdbms FILE=bai01.dmp IGNORE=N COMPILE=Y INDEXFIRST=N TABLE_FIRST=N LOCAL=N COMMIT_ROWS=5000 FAST_LOAD=N LOG=imp_2019_08_16_14_05_28.log LOG_WRITE=N

 

CREATE TABLE "DMHR"."EMPLOYEE"
(
"EMPLOYEE_ID" INT NOT NULL,
"EMPLOYEE_NAME" VARCHAR(20),
"IDENTITY_CARD" VARCHAR(18),
"EMAIL" VARCHAR(50) NOT NULL,
"PHONE_NUM" VARCHAR(20),
"HIRE_DATE" DATE NOT NULL,
"JOB_ID" VARCHAR(10) NOT NULL,
"SALARY" INT,
"COMMISSION_PCT" INT,
"MANAGER_ID" INT,
"DEPARTMENT_ID" INT,
NOT CLUSTER PRIMARY KEY("EMPLOYEE_ID"),
CONSTRAINT "EMP_EMAIL_UK" UNIQUE("EMAIL"),
CONSTRAINT "EMP_DEPT_FK" FOREIGN KEY("DEPARTMENT_ID") REFERENCES "DMHR"."DEPARTMENT"("DEPARTMENT_ID"),
CONSTRAINT "EMP_JOB_FK" FOREIGN KEY("JOB_ID") REFERENCES "DMHR"."JOB"("JOB_ID"),
CHECK("SALARY" > 0)) STORAGE(ON "DMHR", CLUSTERBTR) ;