Export Modes

Table	Exports specified tables in the user's schema, rather than all tables. A privileged user can qualify the tables by specifying the schema containing them. The default is to export all tables belonging to the user doing the export.
	Exports in table mode do not include cluster definitions. As a result, the data is imported into unclustered tables. Thus, you can use Export to uncluster tables when there is not enough free space in your database.
User	Exports all objects in a user's schema (such as tables, data, grants, and indexes). A privileged user exporting in user mode can export all objects in the schemas of a specified set of users.
Full Database	Only users with the EXP_FULL_DATABASE role can export in this mode. All objects in the database are exported, except those in the schema of SYS. (Objects owned by SYS are generated during database creation for internal and administrative use. Because they are not exported, you should not create a user table or any other object under SYS.)

See "Export Parameters" for more information.

Table 1 - 1 shows the objects that are exported in each mode and the order in which they are exported:

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	snapshots	tablespace definitions
table data	snapshot logs	profiles
table constraints	job queues	user definitions
owner's table grants (1)	refresh groups and children	roles
owner's table indexes (2)	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 constraints	table definitions	resource costs
table triggers	table data	rollback segment definitions
	table constraints	database links
	owner table grants	sequence numbers
	owner table indexes (3)	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
	user stored procedures	table data
	user stored functions	table constraints
	user stored packages	table grants
	analyze cluster	table indexes
	referential constraints	analyze tables
	referential constraints	column comments
	triggers	audit
		referential integrity constraints
		all synonyms
		all views
		all stored procedures,
		all stored packages
		all stored functions
		all triggers
		analyze cluster
		default and system auditing
Notes:
1. Owner's grants for the tables are exported in table mode.
2. Owner's indexes on the specified tables are exported in table mode.
3. Only indexes on the user's tables are exported.

Table 1 - 1. Exported Objects