Exp/imp is an executable file under the operating system placed in the directory/oracle_home/bin
The Exp/imp tool compresses data backups from a database into a binary system file that can be migrated between different OSes
It has three modes:
A. User mode: Export all user objects and data in the object;
B. Table mode: Export all tables or tables specified by the user;
C. Entire database: Exports all objects in the database.
The Exp\imp import and Export command uses
CMD below:
Export: Exp username/[email protected] file= ' file exists path ' owner= (user);
To export only the table structure, without exporting the table data, simply add a parameter to the command line Rows=n
To export the specified table:
Example: EXP scott/tiger grants=y tables= (emp,dept,mgr)
View EXP Command Parameters exp help=y
See Help, Analysis. Add the appropriate conditions to your needs.
Import: Imp Username/password
View IMP Command parameters imp help=y
See Help, Analysis. Add the appropriate conditions to your needs.
The following actions need to be performed under the user with Execute permission
To delete all objects under a user:
Drop User xxx cascade;
Drop tablespace XXXX including CONTENTS;
To create a user :
Create user username identified by password;
Authorized users :
Grant Create session,create any table,create any view,create any index,create any procedure,create any trigger,create any Type,create any sequence,alter any table,alter any procedure,alter any trigger,alter any type, alter any sequence,drop any Table,drop any view,drop any index,drop any procedure,drop any trigger,drop any type,drop any sequence,select any table,i Nsert any table,update any table,delete any table to username;
To User tablespace: (You can create table spaces for users individually, or you can use the system tablespace, the users table space used here)
Alter user username quota unlimited on users;
Oracle Imp/exp DMP File