It is an export of all objects in a specific schema or set of schemas so that a user cannot export another schema unless he has the FULL_EXP_DATABASE privilege.

The SCHEMA is simply the set of objects that belong to a specific user.

A- How does the VBS database administrator export a SCHEMA.

C:\>EXP SYSTEM/SYS FILE=D:\EXPORT\VBS.DMP LOG=D:\EXPORT\VBS.LOG OWNER=VBS

Note that while exporting the VBS SCHEMA, the Triggers, Indexes and table data were exported, but this can be ignored using the options

INDEXES=N & TRIGGERS=N & ROWS=N

We also chose the OWNER option to specify the SCHEMA we want to export, of course more than one SCHEMA can be specified in one operation.

B- How can the user export the VBS SCHEMA or in other words how does the user export the VBS objects that he owns?

C:\>EXP VBS/VBS FILE=D:\EXPORT\VBS.DMP LOG=D:\EXPORT\VBS.LOG

Note with me here we do not resort to the OWNER option because the VBS user here wants to export the objects that he owns. Any user who does not have the EXP_FULL_DATABASE permission cannot export any other SCHEMA.