Tutorial IT Point: exp Utility

exp Utility

exp Utility:- Export utility is used to take a backup of Database.

We can export below through exp utility
1) Export full database
2) Export one or more specific Schema/User
3) Export one or more specific Tables
4) Export all objects in a Tablespace

There are 3 level of export available
1) Database
2) Schema
3) Table

Features available in export utility
1) Export logs can be saved in text file
2) Controlling output dump filename
3) Export only selected rows from a table
4) Controlling constraints, grants, triggers and indexes
Using wildcards to export multiple tables

There are three methods to connect using exp utility to export data from Oracle
1) Interactive
2) Non-Interactive
3) Parameter file.

1. Interactive Mode:- When we write exp in command prompt and hit enter, you are entering the interactive mode,where it will prompt you for various values before exporting the Oracle table data.

First, it will ask for the Oracle schema’s username and password.
This username can be the name of the schema that you are planning to export, or a username
who has DBA privilege to export other user’s objects.

1) Take a Scott schema backup through interactive mode

When you hit Enter again, It will take backup of Scott schema. If you want backup any other schema then you have to put schema name then hit Enter.

2) Take a Full Database backup through interactive mode