oracle@mutation#imp scott/tiger fromuser=scott touser=scott show=y log=scott.log file=scott.dmp

Import: Release 9.2.0.4.0 - Production on Tue Jul 19 08:55:51 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
 "BEGIN  "
 "sys.dbms_logrep_imp.instantiate_schema(schema_name=>'SCOTT', export_db_name"
 "=>'MUTATION', inst_scn=>'12580535');"
 "COMMIT; END;"
 "CREATE TABLE "DEPT" ("DEPTNO" NUMBER(2, 0), "DNAME" VARCHAR2(14), "LOC" VAR"
 "CHAR2(13))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 1"
 "048576 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USERS" LOGGING NOCOMPRESS"
. . skipping table "DEPT"

 "CREATE TABLE "EMP" ("EMPNO" NUMBER, "ENAME" VARCHAR2(10), "JOB" VARCHAR2(9)"
 ", "MGR" NUMBER(4, 0), "HIREDATE" DATE, "SAL" NUMBER(7, 2), "COMM" NUMBER(7,"
 " 2), "DEPTNO" NUMBER(2, 0))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 "
 "STORAGE(INITIAL 1048576 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USERS" L"
 "OGGING NOCOMPRESS"
. . skipping table "EMP"

 "CREATE TABLE "PLAN_TABLE" ("STATEMENT_ID" VARCHAR2(30), "TIMESTAMP" DATE, ""
 "REMARKS" VARCHAR2(80), "OPERATION" VARCHAR2(30), "OPTIONS" VARCHAR2(255), ""
 "OBJECT_NODE" VARCHAR2(128), "OBJECT_OWNER" VARCHAR2(30), "OBJECT_NAME" VARC"
 "HAR2(30), "OBJECT_INSTANCE" NUMBER(*,0), "OBJECT_TYPE" VARCHAR2(30), "OPTIM"
 "IZER" VARCHAR2(255), "SEARCH_COLUMNS" NUMBER, "ID" NUMBER(*,0), "PARENT_ID""
 " NUMBER(*,0), "POSITION" NUMBER(*,0), "COST" NUMBER(*,0), "CARDINALITY" NUM"
 "BER(*,0), "BYTES" NUMBER(*,0), "OTHER_TAG" VARCHAR2(255), "PARTITION_START""
 " VARCHAR2(255), "PARTITION_STOP" VARCHAR2(255), "PARTITION_ID" NUMBER(*,0),"
 " "OTHER" LONG, "DISTRIBUTION" VARCHAR2(30), "CPU_COST" NUMBER(*,0), "IO_COS"
 "T" NUMBER(*,0), "TEMP_SPACE" NUMBER(*,0), "ACCESS_PREDICATES" VARCHAR2(4000"
 "), "FILTER_PREDICATES" VARCHAR2(4000))  PCTFREE 10 PCTUSED 40 INITRANS 1 MA"
 "XTRANS 255 STORAGE(INITIAL 1048576 FREELISTS 1 FREELIST GROUPS 1) TABLESPAC"
 "E "USERS" LOGGING NOCOMPRESS"
. . skipping table "PLAN_TABLE"

Import terminated successfully without warnings.