jw> create table t1 (c1 date);

Table created.

jw> create table t2 (c1 date);

Table created.

jw> insert into t1 values(sysdate);

1 row created.

jw> commit;

Commit complete.

jw> create trigger trig1 after insert on t1 begin
  2  insert into t2 values(sysdate);
  3  end;
  4  /

Trigger created.

jw> host exp jon/jon file=t1.dmp tables=t1

Export: Release 11.2.0.1.0 - Production on Tue Aug 17 12:07:41 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

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

jw> host imp jon/jon file=t1.dmp full=y ignore=y

Import: Release 11.2.0.1.0 - Production on Tue Aug 17 12:07:47 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

Export file created by EXPORT:V11.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing JON's objects into JON
. importing JON's objects into JON
. . importing table                           "T1"          1 rows imported
Import terminated successfully without warnings.

jw> select * from t2;

C1
---------
17-AUG-10

jw>

Pretty much the same as John Watson's session.

:
  1  create or replace trigger ttestTrig
  2  after insert on dept
  3  for each row
  4  begin
  5  insert into ttest values (:new.dname);
  6* end;
SQL> /

Trigger created.

oracle@kaapi#exp scott/tiger@someDb tables=dept triggers=y                

Export: Release 10.2.0.1.0 - Production on Tue Aug 17 07:41:20 2010

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


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                           DEPT          4 rows exported
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.



oracle@kaapi#sqlplus -s scott/tiger@someDb <<EOF
> truncate table dept;          
> truncate table ttest;
> exit;
> EOF

Table truncated.


Table truncated.



oracle@kaapi#imp scott/tiger@someDb tables=dept ignore=y 

Import: Release 10.2.0.1.0 - Production on Tue Aug 17 07:43:42 2010

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


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing scott's objects into scott
. importing scott's objects into scott
. . importing table                         "DEPT"          4 rows imported
Import terminated successfully without warnings.
oracle@kaapi#


oracle@kaapi#sqlplus -s scott/tiger@someDb <<EOF
> select * from dept;                              
> select * from ttest;
> exit;
> EOF

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON


C1
------------------------------
ACCOUNTING
RESEARCH
SALES
OPERATIONS