Oracle Database--EXP export Oracle database tables and IMP import Oracle database tables

EXP Export Oracle database table: (as native administrator), refer tohttp://jiqinlin.iteye.com/blog/758469 Export TABLE: Exp username/password @localhost (IP address): Port number/Database instance name file= local address \ Want to generate an indication. DMP owner= (username, Password) eg:exp C # #tjuser/TJUSER@LOCALHOST:1521/ORCL file=c:\adc160624.dmp owner= (C # #tjuser, Tjuser)//tables under the current user database name, instance Name query: (Administrator ID)1. Enter cmd command: sqlplus//Enter the SQL statement State 2. Enter the database username, password 3.select name from v$database respectively;   Query database name select instance_name from V$instance;  Querying the database instance name select Instance_name,host_name from V$instance; Querying the database instance name, host name Note: Plsql Developer development tool with export Import functionExport tables: Exporting the table structure and data export user objects: Create a table statement (storage structure) View all tables under the XXX user of the Oracle database:Select table_name from dba_tables where owner= ' XXX '; Oracle Database Creation User: (Need to unlock, assign permissions to user after creating user)Create user user_name identified by 123456;        User_name for username, 123456 for password alter user user_name account unlock;       For the user user_name unlock, do not understand the lock user can not login grant connect,resource,create to user_name;      Grant SYSDBA to user_name for user_name connection, creation, and so on; Assigning permissions directly to a user (here for data administrators) to user_name to view users who have SYSDBA or Sysoper permissions:SELECT * from V$pwfile_users; Delete the user, with the user action of the database table deleted together:Drop user user_name cascade;
IMP Import Oracle database tables:Reference http://blog.csdn.net/zhuxiaowei716/article/details/44651465 Imp {u_name}/{u_pwd}@{local_svrname} fromuser={from _user} touser={u_name} File={dmp_file_path} ignore=y; Eg:imp C # #tjuser/TJUSER@LOCALHOST:1521/ORCL fromuser=c# #tjuser touser=c# #tjuser file=c:\adc.dmp ignore=y; (Note: You need to create a table space before you import a database, create a user, assign rights to a user, etc.)