Import Modes

Table	This mode allows you to import specified tables in your schema, rather than all your tables. A privileged user can qualify the tables by specifying the schema that contains them. The default is to import all tables in the schema of the user doing the import.
User	This mode allows you to import all objects that belong to you (such as tables, data, grants, and indexes). A privileged user importing in user mode can import all objects in the schemas of a specified set of users.
Full Database	Only users with the IMP_FULL_DATABASE role can import in this mode. All objects in the export file are imported.

To select table, user, or full database mode, specify TABLES=tablelist, FROMUSER=userlist, or FULL=Y, respectively. A user with the IMP_FULL_DATABASE role must specify one of these options, or else an error results. If a user without the IMP_FULL_DATABASE role fails to specify one of these options, then a user-level import is performed.

Table 2 - 3 shows objects that are imported in each mode and the order in which they are imported.

Table Mode	User Mode	Full Database Mode
For each table in the TABLES list:	For each user in the Owner's list:	All database objects except for those owned by SYS:
table definitions (1)	snapshots	tablespace definitions
table data	snapshot logs	profiles
table constraints	job queues	user definitions
owner's table grants (2)	refresh groups and children	roles
owner's table indexes (3)	database links	system privilege grants
analyze tables	sequence numbers	role grants
column comments	cluster definitions	default roles
audit	For each table that the user owns:	tablespace quotas
table referential constrains	table definitions (1)	resource costs
table triggers	table data	rollback segment definitions
	table constraints	database links
	table grants	sequence numbers
	table indexes (4)	all snapshots
	analyze table	all snapshot logs
	column comments	all job queues
	audit	all refresh groups and children
	private synonyms	all cluster definitions
	user views	table definitions (1)
	user stored procedures, packages, and functions	table data
	analyze cluster	table constraints
	referential constraints	table grants
	triggers	table indexes
	postable actions	analyze table
		column comments
		audit
		referential integrity constraints
		postable actions
		all synonyms
		all views
		all stored procedures, packages, and functions
		all triggers
		analyze cluster
		default and system auditing
Notes:
1. Table definitions include comments and audit options.
2. Owner's grants for the tables are exported in table mode.
3. Owner's indexes on the specified tables are exported in table mode.
4. Only indexes on the user's tables are exported.

Table 2 - 3. Exported Objects