SQL> host imp scott/tiger@orcl show=y log=test.log full=y

Import: Release 10.1.0.2.0 - Production on Sat Oct 21 09:07:03 2006

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.01.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing SCOTT's objects into SCOTT
 "CREATE TABLE "TEST" ("SAL" NUMBER(8, 2))  PCTFREE 10 PCTUSED 40 INITRANS 1 "
 "MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POO"
 "L DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS"
. . skipping table "TEST"

Import terminated successfully without warnings.

SQL>

SQL> host imp scott/tiger@orcl show=y log=test.log full=y indexfile=test.sql

Import: Release 10.1.0.2.0 - Production on Sat Oct 21 10:00:53 2006

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.01.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. . skipping table "TEST"

Import terminated successfully without warnings.

SQL> edit test.sql