SQL> host exp scott/tiger tables=avgsal

Export: Release 10.1.0.2.0 - Production on Wed Oct 25 10:12:30 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 done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                         AVGSAL          5 rows exported
Export terminated successfully without warnings.

SQL> host imp tester/tester

Import: Release 10.1.0.2.0 - Production on Wed Oct 25 10:12:38 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

Import file: EXPDAT.DMP >

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V10.01.00 via conventional path

Warning: the objects were exported by SCOTT, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no > n

Ignore create error due to object existence (yes/no): no > n

Import grants (yes/no): yes > y

Import table data (yes/no): yes > y

Import entire export file (yes/no): no > y

. importing SCOTT's objects into TESTER
. . importing table                       "AVGSAL"          5 rows imported
Import terminated successfully without warnings.

SQL>