##################################################################### ## export.sh ## ##################################################################### exp userid=scott/tiger file=scott.dmp log=exp_scott.log rows=n ##################################################################### ## import.sh ## ##################################################################### imp userid=scott/tiger file=scott.dmp tables=emp,dept log=scott.ddl show=y ##################################################################### ## example output file: scott.ddl ## ##################################################################### Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production Export file created by EXPORT:V09.02.00 via conventional path import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set import server uses US7ASCII character set (possible charset conversion) . importing SCOTT's objects into SCOTT "CREATE TABLE "DEPT" ("DEPTNO" NUMBER(2, 0), "DNAME" VARCHAR2(14), "LOC" VAR" "CHAR2(13)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 3" "2768 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USERS" LOGGING NOCOMPRESS" "CREATE UNIQUE INDEX "PK_DEPT" ON "DEPT" ("DEPTNO" ) PCTFREE 10 INITRANS 2 " "MAXTRANS 255 STORAGE(INITIAL 32768 FREELISTS 1 FREELIST GROUPS 1) TABLESPAC" "E "USERS" LOGGING" "ALTER TABLE "DEPT" ADD CONSTRAINT "PK_DEPT" PRIMARY KEY ("DEPTNO") USING I" "NDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 32768 FREELISTS 1 F" "REELIST GROUPS 1) TABLESPACE "USERS" LOGGING ENABLE " "CREATE TABLE "EMP" ("EMPNO" NUMBER(4, 0), "ENAME" VARCHAR2(10), "JOB" VARCH" "AR2(9), "MGR" NUMBER(4, 0), "HIREDATE" DATE, "SAL" NUMBER(7, 2), "COMM" NUM" "BER(7, 2), "DEPTNO" NUMBER(2, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRAN" "S 255 STORAGE(INITIAL 32768 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USER" "S" LOGGING NOCOMPRESS" "CREATE UNIQUE INDEX "PK_EMP" ON "EMP" ("EMPNO" ) PCTFREE 10 INITRANS 2 MAX" "TRANS 255 STORAGE(INITIAL 32768 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "" "USERS" LOGGING" "ALTER TABLE "EMP" ADD CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO") USING INDE" "X PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 32768 FREELISTS 1 FREE" "LIST GROUPS 1) TABLESPACE "USERS" LOGGING ENABLE " "ALTER TABLE "EMP" ADD CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO") REFEREN" "CES "DEPT" ("DEPTNO") ENABLE NOVALIDATE" "ALTER TABLE "EMP" ENABLE CONSTRAINT "FK_DEPTNO"" Import terminated successfully without warnings.