Oracle uses the EXPDP/IMPDP command to import and export data

1. Open Sqlplus Login and create Export data store directory sqlplus/as sysdba Direct return without entering the password　　Create or replace directory Databak as ' D:\bak\temp ';　　 SELECT * from Dba_directories; --See if the path is set successfully　　 2. Give users access to read and write Grant Read,write on directory databak to blog; --blog user name　　 3. User full Data exportEXPDP blog/[email protected] Directory=databak dumpfile=blog.dmp　　Logfile=blog.log Schemas=blog4. Import DataIMPDP user/[email protected] Directory=databak dumpfile=blog.dmp logfile=blog.log schemas=blog　　

Oracle uses the EXPDP/IMPDP command to import and export data