Oracle Export Import Table space creation

//sqlplus command before backing up the database create a database DMP deposit directorySqlplus/Nologconn/ asSysdbasql> Create or Replace directory Expdir as 'E:/kxdb'; the directory was created. CMD://Export DatabaseEXPDP emms/emms123 Directory=expdir dumpfile=emms2.dmp logfile=EMMS2.log//Importing DMPIMPDP emms/emms123 Directory=expdir dumpfile=emms2.dmp//UninstallE:\app\Administrator\product\11.2.0\dbhome_1\deinstall\deinstall//Database1. Emms EMMS1231: Creating a temporary tablespace create temporary tablespace emms_temptempfile'C:\app\administrator\oradata\orcl\EMMS_TEMP.dbf'size 50m autoextend on next 50m maxsize 20480m extent management local; 2: Creating a data table space create tablespace emmslogging datafile'C:\app\administrator\oradata\orcl\EMMS_DATA.dbf'size 50m autoextend on next 50m maxsize 20480m extent management local; 3rd Step: Create user and specify table space create user Emms dentified by EMMS123defaulttablespace emmstemporary tablespace emms_temp; 4th step: Grant CONNECT,RESOURCE,DBA to emms the user permission;

Oracle Export Import Table space creation