When e is used to create a tablespace, user, imp, exp, And conn [html]/*, it is divided into four steps * // * Step 4: create a temporary tablespace */create temporary tablespace user_temp tempfile 'e: \ oracle \ oradata \ user_temp.dbf 'size 50 m autoextend on next 50 m maxsize 20480 m extent management local; commit;/* Step 2: create a data table space */create tablespace user_data logging datafile 'e: \ oracle \ oradata \ user_data.dbf' size 50 m autoextend on next 50 m maxsize 20480 m extent management local; commit; /* Step 2: create a user and specify the tablespace */create user BSP_HUABEI identified by BSP_HUABEI default tablespace user_data temporary tablespace user_temp; commit;/* Step 2: grant the user the permission */grant connect, resource, dba to BSP_HUABEI; commit; // The table space imported through the statement can be different, however, your user and password must be consistent. imp BSP_HUABEI/BSP_HUABEI @ orcl file = f: \ work \ database \ daochu. dmp full = y if you directly execute the import command in the imp.exe file: f: \ work \ database \ daochu. do not add parameters such as full = y after dmp // export exp BSP_HUABEI/BSP_HUABEI @ // 192.168.0.209: 1521/tsorcl file = d: \ daochu. dmp // delete a user and the following table drop user USERNAME cascade; commit; // connect to the database sqlplus "BSP_HUABEI/BSP_HUABEI @ // 192.168.0.209: 1521/tsorcl "conn" sys/123456 @ // 10.8.114.2: 1521/orcl as sysdba // If you export ncg/ncg @ // 192.168.0.209: 1521/tsorcl in exp.exe