Oracle creates tablespace, backs up/restores database dmp

Note: 1. if you open it in PL/SQL or other tools, directly modify the [italic bold Section] in the following code and execute 2. make sure that the path exists. For example, [D: \ oracle \ oradata \ Oracle9i \] means that the path of the file to be saved exists/* consists of four steps * // * Step 2: create temporary tablespace */create temporary tablespace user_temp tempfile 'd: \ oracle \ oradata \ Oracle9i \ user_temp.dbf 'size 50 m autoextend on next 50 m maxsize 20480 m extent management local; /* Step 2: create a data table space */create tablespace user_data logging datafile 'd: \ oracle \ oradata \ Oracle9i \ user_data.dbf 'size 50 m autoextend on next 50 m maxsize 20480 m extent management local;/* Step 4: create a user and specify the tablespace */create user username identified by password default tablespace user_data temporary tablespace user_temp;/* Step 2: grant the user permissions */grant connect, resource, dba to username; backup: exp username/password @ database file = d: \ backup. dmp exp root/password @ database file = d: \ backup. dmp Restoration: imp username/password @ database fromuser = username 1 touser = username 2 file = d: \ backup. dmp imp username/password @ database fromuser = username 1 touser = username 2 file = d: \ backup. dmp imp username/password @ remote machine name_database fromuser = username 1 touser = username 2 file = d: \ backup. dmp