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

Import: Release 9.2.0.4.0 - Production on Fri Aug 5 08:59:46 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=>'13816361');"
 "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 TRIGGER "SCOTT".alt_session"
 "after logon on database"
 "begin"
 "if sys_context('userenv','session_user') ='SCOTT' Then"
 "      execute immediate 'alter session set SKIP_UNUSABLE_INDEXES = TRUE' ;"
 "end if;"
 "end;"
 "ALTER TRIGGER "ALT_SESSION"  ENABLE"
Import terminated successfully without warnings.