Requirements: The company set up the report library environment data from the production environment Oracle data, so you need to use Kettle to import Oracle data into the reporting database on a daily basis (this article does not discuss how to use kettle to guide the data, do not repeat), To guide the data we need a complete set of table structures to produce Oracle databases. While both the environment and the Oracle database are deployed in a Linux environment, it is necessary to use data pump technology to import and export data in a Linux environment
Above for requirements overview
Specific implementation (i.e.: Operation steps):
Su-root--Switch the root user (log in to Oracle users because they do not know the password of the Oracle user using root)
Su-oracle--Switch The Oracle database under the root user
Ps-ef|grep Smon---View db instance
Export oracle_sid= Instance name----ORACLE instance
Sqlplus Sys/manager as SYSDBA; ----Log on to the database user database connection
SELECT * FROM dba_directories-----View the database virtual directory (where the exported data is stored)
Grant Read,write on directory virtual directory name to database user name;------Grant read-Write permissions to users
Grant Imp_full_database,exp_full_database to database user name;-----give users permission to import and export
-----------two forms that are exported from the user
EXPDP User name/database name schemas= user name dumpfile=dmp file name. DMP directory= Virtual directory name logfile= log name. log
EXPDP database name directory= virtual directory name dumpfile=dmp file name. DMP logfile= Log. Log schemas= user name
----------two forms imported from the user
IMPDP username/password directory= virtual directory name dumpfile=dmp file name. DMP logfile= log name. log schemas= User name
IMPDP database name directory= virtual pathname dumpfile= import file name. DMP logfile= log name. log remap_schema= export source database user name: Import source database user name;
The above is the data pump import and export data of the approximate steps, may be too rough, later to do the perfect bar, but also hope that we can put forward good suggestions for improvement, learn together
Data pump import and export operation to Oracle database on Linux environment