SQL> create user bob identified by bob;
User created.
SQL> grant create session, resource to bob;
Grant succeeded.
SQL> conn bob/bob
SQL> create table tab1(col1 char(1));
Table created.
SQL> create index tab1_idx on tab1(col1);
Index created.
SQL> create or replace procedure myproc is begin null; end;
2 /
Procedure created.
C:\>exp bob/bob file=bob owner=bob
Export: Release 11.2.0.3.0 - Production on Thu Dec 20 14:57:50 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing option
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user BOB
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user BOB
About to export BOB's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export BOB's tables via Conventional Path ...
. . exporting table TAB1 0 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
SQL> drop table tab1 purge;
Table dropped.
SQL> drop procedure myproc;
Procedure dropped.
C:\>imp bob/bob file=bob full=y
Import: Release 11.2.0.3.0 - Production on Thu Dec 20 14:58:26 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing option
Export file created by EXPORT:V11.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing BOB's objects into BOB
. . importing table "TAB1" 0 rows imported
Import terminated successfully without warnings.
C:\>
SQL> select object_name,object_type from user_objects;
OBJECT_NAM OBJECT_TYPE
---------- -------------------
MYPROC PROCEDURE
TAB1_IDX INDEX
TAB1 TABLE
SQL>